Unanswered

Send email with attachment using PAD.

(0) Share

Report

Posted on by AT88

Hi All,

I am trying to send an email with attachments using PAD. The files are present in the folder, and the filename is present in the Excel sheet. The PAD has to match the filename with the Excel sheet and folder. If it matches, then it has to attach the file and send an email. The problem I am facing is that inside the folder, the filename is present with the invoice number (e.g., sample_2342.pdf). But in the Excel column, only the filename is present (e.g., sample). It has to attach the file with the name sample_2342.pdf. Please guide me on how to resolve this issue.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

CristinaValdes 65 on at

Like (1)

Report

Hi,
Exist an action "Get files in folder", so you can make match and then get the name with ".FullName" property present in "Get files in folder".

Was this reply helpful? Yes No
AT88 34 on at

Like (0)

Report

Hi @CristinaValdes , Thank you for your response. But in the "Get files in folder" action I don't see ".FullName" property. I can see only ". count" property.

Was this reply helpful? Yes No
CU31080729-3 500 Moderator on at

Like (0)

Report

Hi,AT88
if your file name in folder is not unique then you can used get file in folder action and provide file filter name from excel (Like that :- Sample*) then you have got file path of that file you have to search then used this file path for as attachment for mail

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Chetan Ninghot

Was this reply helpful? Yes No
DeepaliJagtap 68 on at

Like (0)

Report

Hi,
You can follow steps mentioned below;
1.create list
2. use get files from folder action, o/p of this action is files
3. check if files.count>0
4. if step 3 is true then add files[0] to list var created in step 1 using add item to list action
5. use that list var directly as attachment when sending an email

You can use above set of action i.e. from step 2 to 4 in loop if filename to check is varying every time based on row in excel file.
please find below image for reference: note according to below code o/p filename with it's path will be in lstAttachment var, which can be used further.

Please mark this as solution if it helps you solve issue. Happy to help you more.

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

Read the data from Excel using Read from Excel worksheet. Let's say you store it in %ExcelData% (assuming that's a value from a single cell). Then use the name in a Get files in folder action, passing it in the file name filter as %ExcelData%*.pdf, as it supports wildcards. This will return a list of files. You can use the list directly in the attachments field when you send the email.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No