Share
ReportHello Microsoft Support Team,
I am working on a Power Automate flow using the Dynamics 365 Business Central connector.
My goal is to retrieve records such as:
-
Purchase Order Lines
-
Items
-
Item Ledger Entries
But I am facing multiple issues:
1. Filter Query Not Working
When I use the Filter Query option, dynamic fields are not appearing properly, and no data is returned.
Example filter:
It gives error:
-
Field 'inventory' is not filterable
2. Some Fields Are Not Recognized
When I filter using fields like:
-
status
-
outstandingQuantity
I get errors such as:
-
Could not find a property named 'status' on type 'purchaseOrderLine'
3. Dynamic Content Not Showing
When selecting tables like Purchase Order Lines, the connector shows the table name, but no proper columns or dynamic content appear.
4. Flow Scope Reference Error
When I use nested Apply to each loops, the flow fails with:
-
Cannot reference action inside multiple foreach scopes
Request
Can you please help me understand:
-
Why some Business Central fields are not filterable or available
-
Why dynamic content is missing
-
What is the correct way to filter Purchase Order Lines and Items
-
How to avoid foreach nesting errors in Power Automate
Thank you.
All responses (
Answers (
377
