Showing results for 
Search instead for 
Did you mean: 

Conversion of String to Collection/Table

I am reading excel data to powerapps using Power automate, trying to return the datatable as an output variable. Since table or array is not one of the supported return types from Power automate, I am converting the datatable to String using string() function in the flow. The output from the flow looks something like :


[{\"@odata.etag\":\"\",\"ItemInternalId\":\"9094dee0-283d-4091-aa13-ca3a0bf1afcf\",\"Name\":\"Sravya Bollineni\",\"Employee Alias\":\"\",\"Gift Card Code\":\"YKY4-WSZAW3-FVN2\",\"Reference ID\":\"'6014853089037510\",\"Amount\":\"500\"},{\"@odata.etag\":\"\",\"ItemInternalId\":\"8d655149-2001-4840-b85a-deb2d3a42b3b\",\"Name\":\"Sai Phani\",\"Employee Alias\":\"\",\"Gift Card Code\":\"YKY4-WSZAW3-FVR3\",\"Reference ID\":\"6014463089037510\",\"Amount\":\"500\"}]


Now, I am required to convert this response to a valid collection in the Apps. I do not see any difference in the format using JSON(the above value). How do I convert this to a datatable or a collection which I can loop through. Any help much appreciated!!!!



Advocate I
Advocate I

Have you tried  to generate a schema from your excel payload and pass it back to PowerApps using a the response connector? 


Hey @JordanDeVan,


Thanks for responding. I framed a response schema within the flow and tried sending it to PowerApps using the HttpResponse action. That worked 🙂 

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,766)