Answered

Use the share point item which patch from power apps

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Casey_W 41 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No