Answered

Flow to Email Individual Documents from a Document Set

(0) Share

Report

Posted on by ajoconnell

Hi!

I'm fairly new to Power Automate and I'm looking to create a flow that will take the each document in a document set and send individual emails with the document attached.

The Document Set:

The "Example" set:

I've tried "Get file content" but I keep getting an error. Are there any better ways to accomplish this?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@ajoconnell

Is the 'Get File content' action block the one that throws an error? If so, which 'File identifier' are you using as its input?

Any screenshot from your Flow design and/or execution error is appreciated

Thanx!

Was this reply helpful? Yes No
ajoconnell on at

Like (0)

Report
Copy link

Link copied!

Hi @efialttes ,

The trigger I used was a manual "For a selected file"

For "Get File Properties" I used the ID from "For a selected file" and for "Get File Content" I used the "Get File Properties" identifier.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (2)

Report
Copy link

Link copied!

Hi again

Thanx for the screenshot!

I've just implemented these three steps and the execution succeeds.

Can you specify a bit more what do you mean when mentioned that 'I've tried "Get file content" but I keep getting an error'?

Thanx!

BTW here you are a couple of links to resources on Document Sets and Microsoft Flow

https://sergeluca.wordpress.com/2019/04/17/microsoft-flow-and-document-sets-while-waiting-for-modernization/

https://karinebosch.wordpress.com/2018/11/08/microsoft-flow-create-a-document-set/

Hope this helps

Was this reply helpful? Yes No
ajoconnell on at

Like (0)

Report
Copy link

Link copied!

The error I get is:

{
"status": 404,
"message": "File not found\r\nclientRequestId: 0fcf9aaa-fdf6-4ad2-9440-644b7319a81d\r\nserviceRequestId: 0fcf9aaa-fdf6-4ad2-9440-644b7319a81d"
}

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@ajoconnell

I think you should doublecheck the value currently assigned as 'Get file content' File Identifier.

On the execution screenshot your shared, I see your file identifier does not include the file extension.

Now, when I successfully execute my test flow, I can see the file extension:

Please hover your mouse over the dynamic content you currently has assigned as 'File identifier' input and verify it matches with the one I assigned

body('Get_file_properties')?['{Identifier'}]

Hope this helps

Was this reply helpful? Yes No
ajoconnell on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Weird 🤔

Is it 'Site address' the same in both action blocks?

Did you try to remove and add the 'Get file content' action block again?

And, doublecheck if the connection your are currently using for these two action blocks is the same?

And, make sure you are executing the flow, I mean not using 'Test' option 'Using data from previous runs' from Designer view?

Thanx!

Was this reply helpful? Yes No
Verified answer

ajoconnell on at

Like (1)

Report
Copy link

Link copied!

After some troubleshooting, I was able to finally achieve what I was looking to do.

Using a Document Set, I needed to upload multiple documents and have an email sent with each file attached to one document set manually:

In the "Example" doc set, there are three files:

Flow trigger "Document Transmission":

Once triggered, it sends off three different emails :

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

OMG!

That's the reason why there was not an extension on your 'Get file properties' File Identifier output!

Congrats! Please note I've just marked your last reply as 'Solution'. I think it will be very helful for others facing this same issue.

Thanks for spending some time to share the way you fix it!

Was this reply helpful? Yes No