Use the share point item which patch from power apps

[Casey_W]

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.

[StalinPonnusamy · Accepted 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

[Casey_W]

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. 

[StalinPonnusamy]

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.