Hey @S140
can you please share that what the error you are facing?
Before sending the email with options You have to Get file content using path.
Solution:
I am again sharing the flow please follow this -
Step 1: Start with a Trigger
Step 2: Initialize Variables
FilePath: String
Length: Integer
SplitPath: Array
Step 3: Use Action - List rows present in a table
Step 4: Use Action - Apply to each
Inside Apply to each:
Set Variable:
Name: FilePath
Value: Choose the column which contains the FilePath (for example, the Path column).
Example Value: C:\Users\SayanPatra\OneDrive - XYZ LLC\Desktop\sayan\cian.pdf
Set Variable:
Name: SplitPath
Value: split(variables('FilePath'),'\')
This expression splits the file path based on "\" to extract the file content later.
Set Variable:
Name: Length
Set Variable :
Name - FilePath
This expression reconstructs the file path. After using this expression, you should get: Desktop\sayan\cian.pdf.
Step 5 : Use Action inside Loop - Get file content using path
Step 6 :
Use Action inside Loop - Send Email with options
Send Email with options (As I can see that you have to take the Email Id from Excel so in To Section You can Pass the value dynamically directly without spliting)
Attachments : (Value : variables('SplitPath')[sub(variables('Length'),1)] This Expression will help to get the file Name for Example : cian.pdf according to my file path)
ContentBytes : Pass the Variable FilePath
Note: Ensure there are no empty parameters in the Send Email with options action.
Additional Note:
If your file path is not as long as the example path (C:\Users\SayanPatra\OneDrive - XYZ LLC\Desktop\sayan\cian.pdf), you can use the path directly in the Get file content using path action and in the Send Email with options action.
------------------------------------------------------------------------------------------------------------------------------
If my suggestion helped you, please give it a Thumbs up 👍 and Mark it as a Solution 🤖.
Thanks,
Sayan Patra
RPA Developer
