Flow Excel sheet into Sharepoint every 1 hour

[Anonymous]

Hello,

I am building a flow to export an Excel worksheet into a SharePoint list every hour. It needs to be every hour because the spreadsheet is constantly getting updated. 

So far I have the occurrence set to every 1 hour and "get worksheets" but I can't figured out which action to import the worksheet into a SharePoint list.

Thank you for the help!

[AnthonyAmador]

Hi @Anonymous 

I think you can use the "list rows present in a table" action and then copy those values using "create item" action, I think it should look like this.

Hope this helps.

Cheers.

[Anonymous]

Thank you! 

There are a few things that I am not sure to enter. I don't know what to enter for the table portion in the screen shot below. I want the entire spreadsheet to import to Sharepoint.

[AnthonyAmador]

You have to format your info in excel as a table.

Let me know if that helps.

[Anonymous]

It is formatted as a table but there aren't any options in the drop down for the table. It says "no items".

[AnthonyAmador · Accepted solution]

Try refreshing the flow and check the tables in the excel file.

If the problem persist, consider open a ticket with Microsoft Customer Support here is a link on how to do so:

https://docs.microsoft.com/en-us/power-platform/admin/get-help-support/ 

Hope this helps.

Cheers.

[Anonymous]

It worked, thank you!

[AnthonyAmador]

Glad to help. 

Consider marking the thread as solved to help others find it more quickly.