Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Convert String to JSON; Create a Table

Hi All, Thank you in advance for helping me. I need to convert the output of this into a table or array so MS Flow can identify each number and assign it in order as they appear to a database of clients.  I am having trouble converting the output into a table because it says the output is a string not an array.  Ideally I would like the output to be converted to this JSON output. So I can design a flow which matches the numbers to customer. I.e. This week customer 2 & customer 33 is a match, customer 35 & Customer 13 is a match and so forth.  

Community Support
Community Support

Hi @pladavm ,


I have made certain tests and research, however, I haven’t found out an available way to convert String to a table. I will help do more research on this issue.


By the way, we could use split function to convert string to an array, for your reference.



Best regards,



Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,512)