Using OData Filters in Microsoft Flow actions

In this video we describe use of OData in Microsoft Flow and how we can build efficient and light-weight Flows. Then we get into OData limitations and under development parts that hopefully Microsoft release them soon.
Microsoft Flow Crash Course

Master Microsoft Flow Expressions in 2 Hours

LinkedIn:

Twitter:

Instagram:

[joepark]

Thanks for this! I started with your video on "How to Copy and UPDATE List Items from one SharePoint list to another list (Part 2)" and had to come here for some more on ODATA queries. Following your example, I was able to copy new items and update existing items from one list into another by querying on a unique field. Very satisfying to see it in action!

[gabororoszi]

The OData filter query: UnitPrice eq '' is now working in the "List rows present in a table" action with Excel file in SharePoint

[kiberPin]

It's very interesting just to watch it. I use these technologies in my work and it would be interesting for me to learn more about the array filter, and about everything else, if you have time for it.

[MrPsith]

Dear Sir, Thank you so much now i'm understanding how to use ODATA filter value that i need.

[thnkngwlnts]

Hello Alireza, is there a way to do a filter on a list of SharePoint libraries to return a result based on a input string? Something like a wildcard search on certain columns within a set of document libraries. I see that the contains or substringof OData filter functions are not supported for some reason.

[mfzasr]

Hi, I've a excel table based on which some graphs are drawn. However, the graph requires the zero values to be excluded, for which I used the simple filter function in excel. My requirements is the flow to update/refresh the filter in the above-mentioned table every time when a response is updated to the table via form submission.. So that graph get updated as well. Appreciate if you could help me in this regard.

[Aristotin]

Excellent! So lets talk more about Power Automate.

[twilightcloudcoderz-tcc]

Two different excel filter query is possible!?

[radhikaM]

Dear Ali sir, How can filter data (using OData) by matching Created By(current list) with Person type(from another SP list) column? I tried so may mix and match combinations but no success.

[Doc]

Hello Sir. Thank you for all your videos. I have a question for this one. I wanna get all items (either from a SharePoint list, or excel file) with a specific date. I want to create a monthly report excel file with all items included, which I got from that query. It’s a list with all items from the last month. Would that be possible?

[Rameshkumar-cric]

Hi .. below is my requirement can you help me

When the item is created in SharePoint list . I need the same information to reflect in Mail. Can you please help to sort out this

[aicragerenev]

How can i append all results in a string.?