Update excel from a sharepoint lists

(0) Share

Report

Posted on by Draqon

Hello,

I’m struggling a bit so I’ve decided to write down my problem.

I am creating lets say a document from a main form, optionally many other, small forms. In a flow, I would like to transfer list elements(from a main form) to an excel(Table1). It will be later redistributed throught an entice excel document. In the same document, I would like to put a list of items from a sharepoint list(a smaller – optional one), filtered by one field which they have in common, to an excel table(Table2), which will be later distributed to an “expense list”. Later on I would like to copy that document and transfer it to a different folder, or maybe I should do that at the beggining of a process.

Anyone know If that’s doable? Is It possible to do it the way I've described?Thank you in advance

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Update excel from a sharepoint lists

Hi @Draqon,

Yes, you could use the List rows present in a table action to get rows in the expense list, then use Add a row into a table action to append these data into the Table1.

And you could use Get items action of SharePoint connector to get items, then use Add a row into a table action to append these data into the table2:

Then use Copy file action could copy it to a different folder:

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