How to use OData filter in Power Automate on SharePoint lookup columns

In this video you will see how to write OData filter query for Power Automate Get Items action to filter SharePoint list items for Lookup field.
To enroll in my Udemy courses see below link for discount vouchers sslwsh008.securedata.net/dotn...
This video contains:
- 0:00 Introduction
- 1:25 Our scenario
- 2:00 Suggested solution
- 2:57 You need SharePoint Online Client Browser
- 3:40 Creating the Power Automate flow
- 5:25 Writing the OData filter for person field in Get Items action
- 11:28 OData filter query for Lookup field
- 15:22 Testing the filters in Power Automate flow
- 17:19 Conclusion
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb

[@marciokataoka]

Great video! For those(like me) who don't have admin rights in Sharepoint, there is another way to get the static name of the fields: On list settings, go to Columns session and click on the column you want. In the browser URL field, you will see the static name at the end of the site address after '&Field='

[@AlirezaAliabadi]

Thank you. These are the comments I really appreciate :)

[@kamenivanov8508]

Thank you, thank you, thank you Alireza, thank you lifesaving video

[@lxz86]

Fantastic video, very useful on my work. thanks so much

[@jeanlouisterranova2042]

Hello, is there any possibility to identify all flows in my environment that were ran in a specific day or specific period of time whatever the type of flow (schedule, automated, instant...)? Thank you

[@chandramohan1349]

Thanks for posting, a new way of learning. Question- How StaticName different from list field system name? just curious.

[@AlirezaAliabadi]

Static name is created with lots of restrictions. Special characters and space cannot be part of static name, but users want special characters and space in column names to make it more readable. On the same note, users change title all the time while internal column name must stay the same considering all the code relies in that column regardless of the title.

[@bmassimo1966]

Thanks a very good explanation. One question: is it possible to filter in the same way list or libraries with more then 5000 items?

[@AlirezaAliabadi]

Yes. Your limit is not the number of items in the list. Your limit is the number of the items that Get Items returns. By default that limit is 100, but you can increase it to 100,000 in the settings. Then the challenge will be the time-out error processing it :)

[@jeanlouisterranova2042]

Hello, is there any possibility to identify all flows in my environment that were ran in a specific day or specific period of time whatever the type of flow (schedule, automated, instant...)? Thank you