cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Finding File ID?

I created a flow that is triggered by a SharePoint file being modified and once modified, the flow sends an email to an admin account. Presently, the email is very rudimentary - there is only text that I have populated saying "the file has been updated", however, I'd like to provide more details in the body of the email. I'd like to include the following:

 

1) Who modified the file

2) What modifications were made to the file

 

I know that #1 should be pretty easy to accomplish using the SharePoint action, "Get File Properties". The challenge for me is trying to figure out what the "ID" of the file is. I've employed the trial and error method to hopefully guess the correct file ID, but after 3 days of failed attempt after failed attempt, I'm posting here. Is there a straightforward way for me to figure out the ID of the file that I'm trying to access?

 

MS Flow Help #1.JPG

4 REPLIES 4
courtneo
Microsoft
Microsoft

Hi @Anonymous,

 

File ID will be an output from the "when a file is modified or created" trigger - this should be the id you need to pass to your 'get file properties' step:

 

temp.png

 

 

 

Anonymous
Not applicable

Thanks for the response @courtneo

 

Does it matter that I use the "When a file is created or modified" trigger without the "(properties only)"? The basic "When a file is modified or created" trigger is the one that I use, but there doesn't seem to be an ID output.

 

I'm trying to track a specific file that's in its own folder. I just attempted to run my flow the way you suggested, and it doesn't allow me to drill down to the folder that contains the file I'm tracking.

Ah, you are facing the trouble that the trigger you are using ("When a file is created or modified" without "(properties only")) does not return the file id, it only returns the file GUID (as "File Identifier") .. Unfortunately that id cannot be used to fetch the file with a "get file properties" action - that action needs a number so the "file identifier" token will not even show as a possible input for that action..

 

Apparently this issue is on the SharePoint team's Radar. In the meanwhile, I am afraid the other "(properties only)" trigger is the only one that currently supports what you are trying to do ..

ch2017
Advocate III
Advocate III

retrieve the file path from your trigger "When a file is created" (without properties)

then use that as argument for the action "Get file metadata using path"

that will provide you the file ItemId (integer value)

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!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (3,090)