Seach a SharePoint list for entries where two columns match

(0) Share

Report

Posted on by Community Power Pla...

Let's say a thousand items.

Colums 1 to colum 10,

I need to search where (column 4 = "hello_world") AND (column 5 = 09/09/2022)

(edit, you know what I mean when I say "column)

I can do the rest.

What I aim to do is get all the matchin enteries in an array and then email it. (I think I can do that without assistance).

Its the initial searching I am having issues with,

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

RobElliott 10,383 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous for the get items action to bring back more than the default 100 you need to click on the 3 dots at the top right of the action then select Settings. In the pane that appears turn on the Pagination toggle and enter a number into the Threshold field that is more than the number of items in your list. Then click Done.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

How could I have missed "OData Filter.".
That is EXCATLY what I wanted.
<not relevant>
..as an aside while googling it, I found out that "get items" by default only returns 100 items. Have to revisit all my old scripts where the amount has grown since the original tests. "can it scale?" I was asked.
</not relevant>

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!
You can achieve this using the Filter Query in a Get items action.

What are the field types you are trying to filter on? Single line of text, Date/Time, etc.?

Also are any of the columns you are trying to filter on Calculated columns? They aren't supported in a Filter Query, but you can filter further on Calculated columns post getting the items in a Filter Array.

See example below where I have a Single line of text column called "Code" and a Date column (set to Date only) called "Review Date" (internal name is ReviewDate).

My list of items for testing:
In this example I want to only retrieve the items where the Code is ABC123 and Review Date is 10/18/2022. So it should pick up only Alpha and Delta in this instance.

Flow below using the OData Filter.
Notes:
The columns you put in the filter are using the internal names of the columns.
The date will always be in the format Year-Month-Day.

You can then build up your results you want to send out from the items returned. There are multiple options on how to do this depending on the actual output you want. If you just wanted an HTML table then you can use the Create HTML table action and just add the fields you want to show.

If you want help with the rest of it then let us know.

Was this reply helpful? Yes No