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 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.

Top Solution Authors
Users online (1,509)