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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,730)