Trying to build a flow that adds a row into an Excel table whenever a document in a Sharepoint library is added, deleted or modified

[tmarius]

Hi,

I am trying to build a flow that adds a row into an Excel table whenever a document in a Sharepoint library is added, deleted or modified. The flow works... but it adds blank rows into the Excel table.

The flow is very simple:

But it does not what I want

I need to add a row into an Excel table with specific information:

• Name of document (including path to existing subfolders)
• action performed (Add, delete, edit)
• date/time of action
• username of person who performed action

I did not know what the structure of the table should be, so I created a generic empty table... but the flows adds blank rows.

I don't know from where to take the info needed and how to construct the row to add into the table.

Please help!

Thank you!

[v-mengmli-msft · Accepted solution]

Hi @tmarius ,

I recommend you try another trigger.

For create file and modify file, I recommend you create following flow.

Dynamic value of trigger contains information of file what you want.

You should compare Created and Modified to check if the file is created or modified

If they are same, that means the file is newly created.

For delete file, you should create another flow.

Use Get file properties to get information of file.

Best regards,

Rimmon

[tmarius]

Hi @v-mengmli-msft ,

thank you for your help. Is there any way to write into an excel table a row with data regarding the file? (eg Filename with extension, Modified by, etc)?

Sending the data by mail is not a solution for us. We're having a documents library frequently modified by our partners and our team need to have a clear view on which document was modifed, by who and when, and to take action upon. Having all this data written into an Excel file would allow us to better manage the modifications in the document library. (Having Sharepoint sending alerts is also not good)

I noticed I can add the data needed into an email body - but I cannot add it into an Excel row?

Is this possible?

Thank you,

[v-mengmli-msft]

Hi @tmarius ,

You should create a table firstly.

Then use "Add a row into table" and put information into corresponding columns.

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept it as a solution.

If you have another question, please post it in new post.😀

Best regards,

Rimmon

[wildeH]

I believe you know more about flows than I do, but I have to share these thoughts as I read them while learning to use Power Apps, Dataverse and the available import and export and edit-data-in-excel options.

I have noticed a few tips in the 2 answers so far.

I noticed right away that you want the info in Excel and not email it, and that you have in fact started by creating a spreadsheet.

What I do not know, is whether you have:

• made sure the spreadsheet contains one worksheet only
• used the intended column names so that they match the fields you are using
• formatted the data in the sheet to be a Table (a single command, not a range of formatting steps) and not a Range (which is the default)

I wish you success and am keen to see how you (or someone else) solves this! And out of curiosity and not as if it is going to solve the actual problem... have you considered saving the rows to a SharePoint List?