Hi,
i want to Use the share point item which patch from power apps to trigger a flow, send email and create a word doc. but the problem is the information i get is a Array. i just need the value of each column, could you please help ?
each array is like :{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":22,"Value":"Holger9"}
i just need the Value, ( Hoger9) here.
Thanks a lot.
Solved! Go to Solution.
Hi @Casey_W
I assume you are getting this Array (data) in Power Automate and the data needs to be extracted from JSON.
Below are steps to show how to extract the data using Parse JSON Step.
Insert a Step Parse JSON
1. Set the content
2. Click Generate from the sample
A window will open and enter
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":22,"Value":"Holger9"}
Use Dynamic content and use Value property
Result
Thanks,
Stalin - Learn To Illuminate
Hi @Casey_W
I assume you are getting this Array (data) in Power Automate and the data needs to be extracted from JSON.
Below are steps to show how to extract the data using Parse JSON Step.
Insert a Step Parse JSON
1. Set the content
2. Click Generate from the sample
A window will open and enter
{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":22,"Value":"Holger9"}
Use Dynamic content and use Value property
Result
Thanks,
Stalin - Learn To Illuminate
Thanks a lot Stalin. It works now.
by the way if i have a array included a lot of object, just a single one. then if there is a smart way ? currently i use follow your steps to do it one by one.
Hi @Casey_W
Whatever the response (JSON) you are getting from the Request, we need to generate a sample response. Otherwise, the system can't parse it.
User | Count |
---|---|
253 | |
113 | |
92 | |
48 | |
38 |