Can creating an Excel workbook trigger a flow？

[GUOGUO]

Hi all,

I make monthly issue tracker with Excel workbooks in a folder . eg . The folder now has contained 7 workbooks （Jan..July）.

Can i utilize a flow to import items in every workbooks to a sharepoint list ，and if a new workbook created， can i use the flow to append the items in the workbook to the sharepoint list automatically.

Thanks

[eric-cheng · Accepted solution]

Hi @GUOGUO ,

You can create a flow that is triggered when a file is created in a Sharepoint folder which will then get the rows within the Excel table and write to a SharePoint list.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

[GUOGUO]

Thanks a lot.

By the way, the local folder doesn't work ,right?

[GUOGUO]

Hi Eric

Thanks for your reply,

When I add action "get a row" ,i have no idea about how should I specify the file name ?  I will upload a weekly report workbook every week.

[eric-cheng · Accepted solution]

Hi @GUOGUO 

By local folder do you mean on your local computer? You can use the file system connector but you will need a data gateway.

Back to your question, because your file will be dynamic, you will need to use a Get Tables first.  Pass in the identifier from your trigger as the file. (see below).

After that, you can use the List rowa and pass in the identifier for the file and the name of the table in the previous step.  If you have multiple tables, use a condition to select the right one.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

[GUOGUO]

Hi Eric, 

Thanks a lot for your help.  

I have no idea why i cannot find dynamic item Name under table option of List rows present in a table . 

 

And as I know that  ‘List rows present in a table‘ action only gets the first 256 items of the table. How should I config the  Skip Count field to skip the items that already have copied to the list.

Thanks a lot

[GUOGUO]

And if the file is dynamic , how should i configure options in Create item ? Thanks a lot.

[eric-cheng]

Hi @GUOGUO ,

I posted the reply for dynamic files in your other thread.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up