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

[Gaca1]

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

[Gaca1]

[ManishJain]

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]

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 😞

[ManishJain · Accepted solution]

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

 

[Gaca1]

@ManishJain thank you so much!

[GuyBoswell]

Mine is the same - can see the raw output in the flow history but can't write the output to a Compose or any other action

[GuyBoswell]

The output of Get A Row is not available as an input to Compose action

[GuyBoswell]

Hi @Gaca1 , did you ever find a solution?