cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ez1138
Helper V
Helper V

Outputs Syntax

Hi, I have trying to output the "State_Name".  Any insight would be appreciated!

 

outputs('Apply_to_each')....['State_Name']....?

 

This is the from the "Apply to each"

 

{ "@odata.context": "https://flow-apim-msmanaged-na-centralus-01.azure-apim.net/apim/sql/xxxxxxxxxxxxxxxxxx/$metadata#dat...", "value": [ { "@odata.etag": "", "ItemInternalId": "xxxxxxxxxxxxxxxxxxxx", "State_Name": "Florida", "State_Abbr": "FL", "State_ID": 9 } ] }

6 REPLIES 6
PrasadAthalye
Super User
Super User

Are you calling REST API Or Reading SharePoint List Item using GetItems? For example, if you are reading dropdown values using GetItems, you can use something like below...

 

items('Apply_to_each')?['Currency/Value']

 

For Send HTTP request to SharePoint, you can refer following...

 

https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-s... 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community
Pstork1
Dual Super User III
Dual Super User III

Are you doing a Parse JSON on the output before trying to access the value?  To do that you'll have to remove/replace the '@' characters.  They are invalid in Flow for JSON.  But after processing the JSON for the StateName would be

('Apply_to_each')['State_Name']

That's assuming the Apply to each is looping on the Value property array.

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
ez1138
Helper V
Helper V

2021-03-21_13-59-48.jpg

Using Azure SQL.  I have a bunch of parallel branches, that all work fine.  This one would pull from the state table with the State_ID as the PK.  

When I run the flow, this is what I see.  I do see the "Florida".  Do I need to add a "Compose" or something?

 

2021-03-21_14-04-29.jpg

Okay. Are you trying to figure out how to use the output of Get rows SQL action to read State_Name value somewhere else? If yes, can you use compose and try like below?

 

Outputs('Get_rows_(V2)')?['State_Name']

 

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (37,950)