Skip to main content

Notifications

Topic Creation & Management
Unanswered

Reformat json append attribute in object

Posted on by 2

Hi all,

 

Has anyone to reformated json from

Data:[
{
"optvalue": "BO",
"opttext": "Belleza Office"
},
{
"optvalue": "SO",
"opttext": "Simprug Office"
}]

 

to 

{
"0": "Belleza",
"1": "Simprug Office"
}

 

 

in copilot studio formula, without using power automate ?

 

 

I have try to use FORALL, but the result is not what i need.

{"0": "Belleza"},
{"1":"Simprug"}

 

Here the code using FORALL

ForAll(Topic.Var1.DATA, { optvalue :optvalue})

 

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 137,998

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,059

Leaderboard

Featured topics