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

How do I get the output of get a row? (excel business) into variables

Hi I am able to run the flow, and i get the values i was looking for with the connector "Get a row",

 

but now I am not able to take the output into variables? they simple dont appear as option in the dynamic content.

I am a beginner in this, any help/ indication will be really appreciated

 
 
 
 
 
1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Gaca1 ,

 

I suggest you compose the body first : 

outputs('Get_a_row')?['body'] , then see what is coming in the column values like columnname_x0023_ then use it in compose like 
 
outputs('Get_a_row')?['body/columnname_x0023_'] for each column with respective columnname.
 
Thanks
 

View solution in original post

5 REPLIES 5
Gaca1
Frequent Visitor

image.pngimage.png

Hi @Gaca1 ,

 

Output of Get a row shows all columns when I am trying to use in Compose action. likewise it should be visible for you when you try to use them in another action.

 

Thanks

Gaca1
Frequent Visitor

Hi @ManishJain ,

 

thanks for your answers, but even if a use compose action, the output of get a row is not being show in the dynamic contect in order to select it 😞

Hi @Gaca1 ,

 

I suggest you compose the body first : 

outputs('Get_a_row')?['body'] , then see what is coming in the column values like columnname_x0023_ then use it in compose like 
 
outputs('Get_a_row')?['body/columnname_x0023_'] for each column with respective columnname.
 
Thanks
 

View solution in original post

Gaca1
Frequent Visitor

@ManishJain thank you so much!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,069)