cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abuxbaum107
New Member

Using Power Automate to intake documents

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!

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

NiloferA_0-1638426599389.png

 

Let me know how it goes.

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

View solution in original post

6 REPLIES 6
NiloferA
Super User
Super User

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.

NiloferA_0-1638347341600.png

 

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

 

abuxbaum107
New Member

 

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!

 

image001.jpg

 

 

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
New Member

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!

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

 

NiloferA_0-1638426599389.png

 

Let me know how it goes.

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

View solution in original post

abuxbaum107
New Member

thank you so much! It worked!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,595)