Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 1,095

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.

 

  • CFernandes Profile Picture
    CFernandes 8,146 on at
    Re: Powerapps > Power automate : how to pass array/table to Power automate from powerapps?

    @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.

     

    Untitled.png

     

    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!

     

     

     

     

     

  • VictorIvanidze Profile Picture
    VictorIvanidze 11,853 on at
    Re: Powerapps > Power automate : how to pass array/table to Power automate from powerapps?

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

  • Oskarkuus Profile Picture
    Oskarkuus 1,095 on at
    Re: Powerapps > Power automate : how to pass array/table to Power automate from powerapps?

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

  • VictorIvanidze Profile Picture
    VictorIvanidze 11,853 on at
    Re: Powerapps > Power automate : how to pass array/table to Power automate from powerapps?

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard