Answered

Excel Table is Blank with no info

(0) Share

Report

Posted on by vanemuno

I'm creating a connection from Smartsheets into Excel table. The run is successful, but the data from Smartsheets does not populate at all in the Excel table. What am I missing? Please advise.

All responses (2)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report
Re: Excel Table is Blank with no info

Hi @vanemuno,

@ChristianAbata is correct, you should use the Add a row into a table action to populate these data from Smart sheet.

The Create table action just creates a table, not do the data operation, when you add the new row into the table, you need to extract the data get from the Smart Sheet by using the expression:

body('Get_a_sheet')['rows']

Then, you could refer to this post to learn how to process the data:

https://powerusers.microsoft.com/t5/Building-Flows/I-need-help-transposing-data-into-a-usable-array/m-p/533040#M68887

Then like @ChristianAbata shows, append these data into the Add a row into a table action.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Excel Table is Blank with no info

yes @vanemuno pleasee see this example you need to add datas as json, every column as my example shows.