cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteveJebson
Frequent Visitor

Get value from JSON for SQL Update Row in Apply To Each

Hi,

I'm writing my 1st flow and i can't find a way to get the Job Line ID from the item in an Apply To Each, i've tried the Expression but to no avail. How would i extract the ID from the JSON ? Here's the flow...

 

SteveJebson_0-1595251426694.png

 

Here's the failed run msg....

SteveJebson_1-1595251674726.png

Any help appreacited, thanks

 

Steve

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Rahber
Super User
Super User

You should use the Parse Json action to get the value. https://www.youtube.com/watch?v=e0dzMqoJGtY

 

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

View solution in original post

1 REPLY 1
Rahber
Super User
Super User

You should use the Parse Json action to get the value. https://www.youtube.com/watch?v=e0dzMqoJGtY

 

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,

Rahber

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,348)