web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :

Return an Array from Flow to PowerApps (Split Method)

Brian Dang Profile Picture Posted by Brian Dang 3,976

Now that you can return data from Microsoft Flow to PowerApps, how can you return a full array?

stored-procedure.png

Categories:

Comments

  • KrishnaV Profile Picture KrishnaV 5,023
    Posted at
    Return an Array from Flow to PowerApps (Split Method)

    Thank you a ton for the great video, I have enhanced the formula to get the data with dynamic length:
    ClearCollect(CollEMDetails,
    AddColumns(Split(EmployeeDetailsJson,"\n"),
    "Divison Owner",Mid(Result,Find("Dvowr/",Result)+6+3,(Len(Mid(Result,Find("Dvowr/",Result)+6+3)) - Len(Mid(Result,Find("~!",Result)))))));

    With this formula, I can get data with dynamic length.
    User Names.png

    Once again thank you for your detailed video.

     

    Regards,

    Krishna

  • AhJijo Profile Picture AhJijo
    Posted at
    Return an Array from Flow to PowerApps (Split Method)

    In "Select" step, I can't see the ResultSet, any idea why this happen?