Filter on items in sharepoint list using power automate flow

[Mona_Sultan]

Dears

Good Day ,

I need to filter on items in share point that have the same ID number using power automate flow .

Thanks

[abm]

Hi @Mona_Sultan 

Are you looking for how to filter the SharePoint records using Filter Query? If not could you please explain a bit more about the ID number you mentioned. Mean time please have a look at this tutorial record.

https://www.youtube.com/watch?v=bSkWdDnhCmQ

Thanks

[Mona_Sultan]

Hi  abm

The objective of the flow is to get items with the same ID Number in order to post it as a financial document 

Exp

Invoice Number		Value	Invoice ID
6589	Debit	2000	XYZ
	Credit	2000	XYZ
968	Debit	100	ABC
	Credit	100	ABC

[abm · Accepted solution]

Hi @Mona_Sultan 

Could you please explain where you getting the ID Number for comparison? Please explain with an example of data and your expected result.

Thanks