Unanswered

Attach a created file to an email

(0) Share

Report

Posted on by Heather340

Hello!

I've been trying different solutions on this forum but can't seem to get the final steps in my flow to work. I created a data request form, which when filled out, populates a Word template and creates a file in Sharepoint. Next, I'd like to take that file and email it to both the person who filled out the form and the data manager. However, I'm having issues connecting back to the file that was just created in Sharepoint. Flow as follows. It's failing at the Get File Metadata point.

Thank you for any suggestions!

Screenshot 2022-12-30 160859.png

2Screenshot 2022-12-30 161000.png

3Screenshot 2022-12-30 161045.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Your Get File Content is using the List Item ID not the File Identifier. So you aren't geting the right file content.

Was this reply helpful? Yes No
Heather340 12 on at

Like (0)

Report

@Pstork1 Thanks for identifying the issue. Which is the correct input to use under File Identifier in Get file metadata and Get file content?

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Instead of ItemId or ID look for 'Id' . Or if you know the relative path where you created the file you can use that path inside an EncodeUriComponent() function to create the file identifier. The file identifier is the relative path to the file where all the special characters have been replaced with hex equivalents.

Was this reply helpful? Yes No
Heather340 12 on at

Like (0)

Report

@Pstork1 Beautiful! That did the trick. Thank you for the clarification and quick response.

Was this reply helpful? Yes No