Where to add the filter

[Tango]

Hi, I have a SharePoint list that will be used to store when alerts need to be sent. This will be based on a column called AlertDate.

I plan to schedule the flow to run once a day to look for Items that have an AlertDate equal to today.

Question is what would be best practice regarding where to put the query? Would it be inside a get items or before that be in say a condition?

 Thanks in advance

Todd

[Pstork1 · Accepted solution]

The best place to do a filter like that would be in the Get Items itself as an OData query, but that can be difficult to do.  The next best place to put it would be in a filter array action after the data is retrieved in the Get Items.  There is no way to add it to a condition before you get the data in the Get Items.

[Tango]

Thanks @Pstork1 

[Tango]

Thanks for your post.

what about doing the filtering in the view inside SharePoint and selecting that view in limit columns by view?

[Pstork1]

That will limit the columns returned, but doesn't do anything for filtering and sorting the data returned.  Power Automate only uses the views to get the list of columns to retrieve.