How to get all results in one place

(0) Share

Report

Posted on by moerah

327

Hi All,

im trying to get all result in one place so i can use it in power app gallery, i can do it for one SP list but i need to filter through 4 SP list see screenshot below

Thank you 😊

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Assuming the lists have the same columns you can use Union() to join two lists together into a combined array. To combine 4 lists you'll need to do it three times in succession. Its not a requirement but I would suggest using a Data Select after each of the Get Items actions to isolate only the columns you want in the final array. But once you are done you'll have a single array with the combined results of all four lists.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
moerah 327 on at

Like (0)

Report

@Pstork1 thank you for the reply

so i ended up creating 4 flow run for each putting each into collection in power app then combining all 4 collection into one, seems to work

another question is would i hit threshold/delegation if the records hits above 5k, i am using startswith for my filter query in getitems to avoid this, will this work?

Was this reply helpful? Yes No