Using Power Automate to intake documents

[abuxbaum107]

I have created a basic flow to create an Excel table record row for anyone who adds a document to a specified SharePoint Folder (an intake system). It currently works for tracking data such as document title, date of creation and file location. I am having trouble finding the expression to record who uploaded the document (e.g. returning a line saying 'File Creator name'). Does anyone know of what expression to use to add the name of the uploader to the Excel Table. Thank you and appreciate the help!

[NiloferA]

Hello @abuxbaum107 ,

Can you share a screenshot of what you are doing currently in the Flow?

If I understand correctly, you are trying to record the Author of the File in the Excel Table and finding it difficult to extract it. You can find the 'Created By' which is an object and expands to give you the Account's info about who created the File from Dynamic Content and should be able to use it in any expression.

Have you tried to limit the Columns in the Trigger with Views by any chance? If you have it maybe possible that Created By is not one of the columns added to your View and thus you are not able to see it in the Dynamic Content.

Please give a Kudo or Mark this Reply as a Solution if it resolved your problem. Thanks!

[abuxbaum107]

Thank you for your help! See my flow below. The flow runs and all the fields get updated (that have dynamic/static content in them) in Excel except the 'Nominator' column. I pulled the Author display content from another flow, as it does not show up as an option in this flow. Also, I don't think i have limited columns by view but I have not able to confirm that. Any other thoughts would be helpful!

 

[NiloferA]

Hello @abuxbaum107 ,

In that case, add another action called "Get File Properties", pass the File ID from the Trigger. This action will return all the properties associated with the file including Created By. You can the use this from the Dynamic Content into Nominator field of your Excel Table.

Please hit Kudo or Accept this Reply as Solution if it resolved your problem. Thanks!

[abuxbaum107]

I think I understand this better but how do you pass the file ID from the Trigger. When I add the 'Get File Properties', it requires me for an ID which I do not have because it is not created until the trigger is set off. Thank you!

[NiloferA · Accepted solution]

Hello @abuxbaum107 ,

In that case you will have to use an additional action called "Get file metadata using path", and pass the file path which you will get from Dynamic Content of the Trigger. This action will return ItemID which you can then pass to the Get file properties action to get all the File Properties you need. Please see the screenshot below for reference

Let me know how it goes.

Please hit Kudo or Accept this Reply as Solution if it resolved your problem. Thanks!

[NiloferA · Accepted solution]

Please hit Kudo or Accept this Reply as Solution if it resolved your problem. Thanks!

[abuxbaum107]

thank you so much! It worked!