getting data from excel row and attaching another file to same mail

(0) Share

Report

Posted on by Khan321

233

Hi EveryOne 🙂

1. I have an excel file with more than 500 rows and each row represents a customer with data.

and

2. I have complete excel file for each row of above file in another one drive folder. Files are saved with customer number.

I can create a flow which will take data from each row(number 1) and populate it on word file and attache it to the mail but:

Is it possible to get same customer excel file(nummber 2) which is on the one driver folder with many other excel files and attach it to the same email?

We save the excel file on one drive with customer number and customer number is also in excel file(number 1) in each row.

Thanks for help.

Let me know if i have not explained very well.

Naji

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (1)

Sort by

schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

Yes, you can get the file content from a SharePoint folder using the file name (and you can make that filename dynamic)
You'll need this action
And then you can add that content as the attachment's content and set a name for it.

Was this reply helpful? Yes No
Khan321 233 on at

Like (0)

Report
Copy link

Link copied!

Thanks you @schwibach .

My excel files are located at one drive. Do we have OneDrive action?

Du you have any link :)?
BR
Naji

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

Use the OneDrive for business connector.
There is an action Get File Content using Path
This will explain it.
(214) Flow Actions: OneDrive for Business - Get File Content Using Path - YouTube

Was this reply helpful? Yes No
Khan321 233 on at

Like (0)

Report
Copy link

Link copied!

@schwibach thanks 🙂

I have made flow where i attached the poulated world file with the name of Policy Number(A special number).
Now i want to attach another file which is saved with the name of same Police Number but located in another folder. There are many other files with different police numbers, how to make the flow to attach the right file which has same Police Number as in email.

How can i make the "Get file content dynamic"

I have tried alot but no luck 🙂

Please take a look of the pictures:
Once again thanks for your help.

Was this reply helpful? Yes No
Verified answer

schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

Put the dynamic content "path" in a compose action.

This will give you a string that contains your special number.

Then you take that text and exchange your number for a dynamic reference to the number.

Then you put the outputs of that action in the "Get file content using path" action.

ok?

Was this reply helpful? Yes No
Khan321 233 on at

Like (0)

Report
Copy link

Link copied!

@schwibach Thanks for you help 🙂
It went a bit above my head. sorry 🙂
In compose i Chose "Path"

How can i do the number 2 you wrote?

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

add a second compose action where you reference your policy number.

Then have the flow run once, so the path appears in one compose action and the policy number in the other.

Then you take the result of the first compose action (that contains the policy number somewhere in the middle) and copy it into the compose action... the you have the path to one item hard coded.
In that compose action you replace the hard coded policy number with the reference you have in the other compose action...

Then you have a dynamic reference to the path that you want.

Make sense?

Was this reply helpful? Yes No
Khan321 233 on at

Like (0)

Report
Copy link

Link copied!

@schwibach Thank you for you help and patience 🙂

Is this correct ?
I ran flow and took output of the first compose and put it in the compose 2 and then i chose the Policenr dynamically where Policenr was hard coded.

and this is how the files look, which it should take dinamicaly.

and then i used "get file content" chose compose 2 and attach the "get file content" to email but not working 🙂

BR
Naji

Was this reply helpful? Yes No
schwibach 2 Moderator on at

Like (1)

Report
Copy link

Link copied!

This looks good.

Can you show the outputs of the two compose actions, the action you inserted afterwards and the error it gives you?

Was this reply helpful? Yes No
Khan321 233 on at

Like (0)

Report
Copy link

Link copied!

@schwibach Yes Offcourse 🙂

error: It says the file id is not valid.

Was this reply helpful? Yes No