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
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (56,173)