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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,161)