cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Casey_W
Helper I
Helper I

Use the share point item which patch from power apps

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.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Super User
Super User

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.

StalinPonnusamy_0-1637554435969.png

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"}

StalinPonnusamy_1-1637554598693.png

Use Dynamic content and use Value property

StalinPonnusamy_2-1637554697951.png

 

Result

StalinPonnusamy_3-1637554752231.png


Thanks,
Stalin - Learn To Illuminate

View solution in original post

3 REPLIES 3
StalinPonnusamy
Super User
Super User

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.

StalinPonnusamy_0-1637554435969.png

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"}

StalinPonnusamy_1-1637554598693.png

Use Dynamic content and use Value property

StalinPonnusamy_2-1637554697951.png

 

Result

StalinPonnusamy_3-1637554752231.png


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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,632)