Unanswered

Other users have issues attaching files from OneDrive to Email

(0) Share

Report

Posted on by PowerAppsNoob3

I have made an app where users can enter data, add attachments, save to SharePoint and send an email.

The email is meant to contain a PDF with the data they've entered and the attachments they've uploaded.

This is all running and working for me, but when I invited another user to the app, the attachments are not being added to the email.

In order to make the PDF, I have build a Power Flow that makes an HTML file using the concat function, which is then converted to a PDF on OneDrive.

The attachments are then uploaded to the same OneDrive folder using a simple Create File flow and the ForAll function in Power Apps.

Then i use a flow to take the files from the OneDrive folder and add them as attachments to the email.

The CreatePDF flow is running fine for the other user and so is the UploadAttachments flow. The files are being created and added to the users OneDrive.
The email is also being sent, with the correct text and information, but without the attachments.

Since the two other flows are running and creating the files without problem, I don't understand why there is a problem connecting with OneDrive and retrieving the attachments.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report

Hi @PowerAppsNoob3 ,

Please switch to classic designer.

Repopulate dynamic content.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
PowerAppsNoob3 14 on at

Like (0)

Report

Hello v-yetonggu-msft,

That doesn't seem to change anything.

I built the flows in the classic designer and only took the pictures in the new designer.

I need the attachments to be added to the same email, not each have their own.

It works fine for me, but not for the other user.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

Hi @PowerAppsNoob3 ,

If I understand correctly, do you want to send all attachments in one email?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
PowerAppsNoob3 14 on at

Like (0)

Report

Yes, it's important that all attachments are added to one email.

I have managed to make this work, as I've shown on the screencap, but it does not work for the new user I've shared my app with.

Was this reply helpful? Yes No
james1994 229 Moderator on at

Like (0)

Report

Hey @PowerAppsNoob3,

In the flow run history for the other user, is there anything in the output of the AttachmentsArray compose action?
Would you be able to share the flow run history for the AttachmentsArray and List files in folder action?

Was this reply helpful? Yes No
PowerAppsNoob3 14 on at

Like (0)

Report

Hello james1994,

I had the user run the flow and it ran "succesfully" as usual, with no attachments added to the email.

The List Files In Folder value turned out to have a problem.

This made the entire Get File Content process skip and as such the AttachmentArray had nothing in it.

The email attachments are "null".

Normally the process runs fine:

Was this reply helpful? Yes No
james1994 229 Moderator on at

Like (0)

Report

Are the attachments and pdf being saved in your OneDrive then?

From your post, I believe you have 3 flows?
I'm thinking that your create pdf and upload attachments flow has the run-only user permissions set to use your connections instead of the users connection (saving attachments to your OneDrive), while the send email flow is running on users connection (looking for files in their OneDrive folder, or the other way around).

Was this reply helpful? Yes No
PowerAppsNoob3 14 on at

Like (0)

Report

The attachments and PDF are being saved in the current users OneDrive.

The new user has no problems with making the files in their OneDrive, which is part of the reason why i am so confused. 2 of my flows are running fine, using their OneDrive, but the third is not.

I do indeed have 3 flows. One for creating the PDF, another for uploading the attachments, and the last one attaches the attachments to the email and sends it.

Was this reply helpful? Yes No
james1994 229 Moderator on at

Like (0)

Report

In the details page of your Send email flow, can you check what the run-only permissions are? Is it set to "Provided by run-only user" or "Use this connection..."?
I am suspecting that the flow may be using your connection, so it would be trying to get files in your OneDrive and not the user's.

Was this reply helpful? Yes No
PowerAppsNoob3 14 on at

Like (0)

Report

Hey james1994,

Thanks for continuing to be a help.

All 3 apps are set to run-only user.

I associated them with the app as well.

Was this reply helpful? Yes No