Answered

Send Attachment Based on DropDown

(0) Share

Report

Posted on by theBrianL

I have a Power App connected to a SP List, and one of the fields is a dropdown. I want to send an email with an attachment based on the dropdown choice. The files are housed in a Document Library on the same SP site as the List. Or I can make a new List with the attachments. E.g. If Toyota is selected in the dropdown, I want to attach the Toyota.docx file to the Email. I've named all the files the same name as the dropdown choices. The Power Automate I'm using is triggered by 'When a new item is created'. Is this possible? Thanks!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @theBrianL ,

I have a test for your reference.
In my scenario, my fileName column is a radio selection column, which has three options corresponding to the file names of the three files in my SPfile folder.

Best Regards,
Dezhi

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

Thank you for posting. However, it attaches all of the files no matter which drop-down choice is selected. I don't see anything in the flow that is specifically looking for the drop-down value in the field called 'Category'? Also, not all categories have an associated file so would like it to not attach anything if there is no related file.

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

Not sure how yours only attaches one file? I rebuilt a test flow exactly like you have it and it still sends all of the attachments.

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @theBrianL ,

I'm very sorry for my mistake, I lost the most important part in my screenshot. We need to use the substringof() formula in the filter query to find the corresponding file in the folder according to the options in the item. Apologize again.

Best Regards,
Dezhi

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

That worked for attaching just the correct file-thank you! Now I'm getting this error I've never seen before when I try to open it:
I click Yes and then:

Was this reply helpful? Yes No
v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @theBrianL ,

Do you include the correct suffix in your email attachments?
What does the array you're using to hold the attachments look like?
Could you please show some screenshots of your flow in edit mode?
Sorry, I have never encountered this kind of error. You can try to create a new test flow and try to directly take a file in your folder and put it in an email attachment to see if it can be opened normally.

Best Regards,
Dezhi

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

I can open the documents fine on the SP and open the documents on the desktop that I used to upload to SP.

Was this reply helpful? Yes No
theBrianL on at

Like (0)

Report
Copy link

Link copied!

I figured it out. I had selected 'Body' instead of Get File Contents in the Append to Array Variable. It then changes it to 'Body'. It's working now. Thank you so much for your posts. This is amazing!

Was this reply helpful? Yes No