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
v-alzhan-msft
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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,490)