You’re offline. This is a read only version of the page.
3
Hi,
I'm running a flow getting data from D365 F&O. In the Get table-step I'm trying to filter the entity BatchOrderHeaders and want a filtered list where StartedQuantity = ScheduledQuantity.
Example table
| BatchOrderNumber | BatchOrderStatus | ScheduledQuantity | StartedQuantity |
| 1111 | Created | 500 | 500 |
| 1112 | Reported as Finished | 300 | 321 |
| 1113 | Estimated | 320 | 320 |
What I want the query to do is to return the rows from order number 1111 and 1113.
I've tried (without success):
Hi @ravitiate ,
I'm sorry that the ODATA filter query does not allow comparisons between two columns.
I suggest you to use filter query to achieve column-to-column comparison.
I have made a test for your reference:
1. I am using SharePoint as data source.
2. Use filter query to filter items whose amount column and number column are equal.
Best Regards,
Levi
Share
Report
All responses (
Answers (
