Answered

Excel Table is Blank with no info

Like (0) Share

Report

Posted on 22 Apr 2020 00:14:50 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.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-litu-msft on 22 Apr 2020 at 02:34:22

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.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on 22 Apr 2020 at 00:56:13

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.

Was this reply helpful? Yes No