Powerapps > Power automate : how to pass array/table to Power automate from powerapps?

(0) Share

Report

Posted on by Oskarkuus

1,097

I have a gallery with ID numbers in powerapps.

I want to pass these ID numbers (gallery) to power automate so i can create a FOR EACH flow.

For each ID, do this......

But i can not figure out how to pass the gallery data to power automate.

It complains on needing a text value. If i concat the data, it works... but it all comes in one string... i need it to be able handle each record in the gallery as one value. So i can do an action on each ID.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Pass a string of comma-separated IDs. Then split the string to array.

Was this reply helpful? Yes No
Oskarkuus 1,097 on at

Like (0)

Report
Copy link

Link copied!

just that, how to split a comma separated string to an array in power automate?

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-split

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Oskarkuus

As mentioned by @VictorIvanidze the split function will return an array.

split(<your variable>,',')

In the above formula, it will return you an array.

Then you might need to Filter for blank space, and Select individual items.

I have a blog which cover the above topic, https://clavinfernandes.wordpress.com/2020/08/06/record-microsoft-form-choice-response-to-the-sharepoint-list/

You can find full details from step 5 to step 10.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No