ODATA filter query equal to other column

(0) Share

Report

Posted on by ravitiate

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):

'StartedQuantity' eq 'ScheduledQuantity'
equals(['StartedQuantity'], ['ScheduledQuantity'])

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-liwei-msft on at

Like (1)

Report

Re: ODATA filter query equal to other column

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

Was this reply helpful? Yes No