Hi,
I'm trying to create Flow in Power Automate for Business Central but every time I try to use Find Data (v3) to filter, filters are not working.
I've watched most of tutorials, read documentation for OData in BC and every time I receive an error "Could not find a property name" and have no other idea what else to change. Without filtering flow works correct.
What I'm trying to do is to get Purchase Invoice Lines in Type= Comment and Description containing "order".
Error:
Raw input:
Thank you, that solved all of the issues :)
Please check you have correctly entered the field name as they are case sensitive also put the filter query like below
(agedAsOfDate eq @{variables('currentDate')}) and (balanceDue gt 0)
First of all, you are not using OData, but a standard API.
Your syntax is fine, but the fields in the API are case-sensitive.
For example,
So, change Description to description, Document_No to documentId, Type to lineType and try again. (Note that there is no Document No in this standard API, only documentId.)
Hope this helps.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156