cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How do I a build table from scratch in excel using specified columns from sharepoint list data? (I'm getting errors and not sure why - see pics below)

How do I a build table from scratch in excel using specified columns from sharepoint list data? (I'm getting errors and not sure why - see pics below)

I am attempting to build a flow that will create a new worksheet and a new table in that worksheet (in an existing excel file in sharepoint). 

 

The flow is then supposed to take 3 specified columns from a SharePoint list ('Title', 'VisitDate', and 'Building Areas') and add them to the table under three columns called (Title, Date, Location). Also the flow filters the data so that only data from the last 7 days is pulled from sharepoint.

 

The worksheet was successfully created and the table was successfully created in that worksheet (it had 3 columns as specified). The data in sharepoint also filtered correctly. But, the sharepoint data was not added under those 3 columns properly and so the flow failed. Does anyone know how to fix this?

 

pictures attached below:

 

rsz_screenshot_272.pngScreenshot (276).pngScreenshot (275).png

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous ,

 

Please remove the last comma "," after the last column.

1.png

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @Anonymous ,

 

Take a try to enter the column value with type below:

{
    "column1":"value",
    "column2":"value"
}

The link below for your reference:

https://powerusers.microsoft.com/t5/Building-Flows/Create-a-Worksheet-and-Table-in-Excel-and-then-adding-data-to/td-p/183589

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Sorry for the late reply, I appreciate you answering my question, unfortunately when I tried this message I get the following error:

(Perhaps there is a step I'm missing that I have to do before}

avrahad_0-1594039954653.png

 

Hi @Anonymous ,

 

Please remove the last comma "," after the last column.

1.png

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (5,765)