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

[@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

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

[@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.

[@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