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 :
Power Platform Community / Forums / Power Apps / retrieveing value from...
Power Apps
Unanswered

retrieveing value from powerautomate json

(0) ShareShare
ReportReport
Posted on by 9

Hi,

I have a flow that returns a record, in that i have a collection, that collection i have to store it in a item in powerapps to populate in a combobox. what is the format for it?(The column type is multi select lookup column)

I tried this which is not working,

SelectedComplianceSafetyStandards: ForAll(
Table(ParseJSON(Text(Value.SelectedComSafStandards))),
{
Id: Value(ThisRecord.Value.Id),
Value: Text(ThisRecord.Value)
}

 

In Json format it is populating like this:

"SelectedComSafStandards": [
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 3,
"Value": "Mechanical"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 1,
"Value": "Solvent"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 27,
"Value": "Personal factors"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 2,
"Value": "Electrical"
}
]
)

 

Kindly provide a solution

 

Categories:
I have the same question (0)
  • LaurensM Profile Picture
    12,516 Moderator on at

    Hi @Aravindhan,

     

    The following code did the trick for me:

    ForAll(
     //Replace ReferenceToJson with e.g. the variable where the text output of your flow is stored
     Table(ParseJSON(ReferenceToJson).SelectedComSafStandards),
     {
     Id: Value(ThisRecord.Value.Id),
     Value: Text(ThisRecord.Value.Value)
     }
    )

     

    With the code above I would expect that your flow returns the JSON as a text field. ReferenceToJson will need to be replaced with a reference to the flow text output - this can be the flow run itself or a variable that stores the flow output. The JSON output that was shown in your topic will also need to be enclosed with curly brackets:

    {
     "SelectedComSafStandards": [
     {
     //Object 1...
     },
     {
     //Object 2...
     }
     ]
    }

     

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

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard