web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How create a table fro...

Power Apps

Answered

How create a table from a JSON string

(0) Share

Report

Report

Posted on by WebPortal

2,297

Hello,

Assuming the global variable gblBusinessNames is the following string:
{
"businessNames": [
"FreshFusion",
"HybridHarvest",
"DigitalGreens",
"VirtualVeggies",
"TechFarmers"
]
}

How to create a collection colBusinessNames from this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @WebPortal,

This can be achieved by (1) using the ParseJSON function, (2) looping through the businessNames table and (3) defining the values as Text.

ClearCollect( colBusinessNames, ForAll( Table(ParseJSON(gblBusinessNames).businessNames), Text(Value) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No

Join the conversation