Unanswered

Modify a file then add it to an email [How to?]

(0) Share

Report

Posted on by paulb4

Hi everyone,

So let me explain everything: I created a Form on which the user has to fill differents things (questions 1, 2, 3, 4) and choose something from a list (question 5).

If he chooses the answers A, B, C or E in the list (question 5), then a file is sent to someone. The file is an Excel table.

But before the said file is sent, I need that the answers the user gave in questions 1, 2 and 3 has to be noted inside the file, in cells A10, B10 and F10.

The modified file is sent to the person.

Of course, I need to keep the initial file unmodified for the next users.

And this all happens right after an Approval step (so everything goes on if the approver said 'Approved').

So I can't manage to do everything that is in BOLD.

I'm really not confident with my skills with all of these tools so please if you answer, please be very precise on what I'm supposed to do, I'm easily confused with all of the options and possibilities (which I don't understand for most...sorry!)

Can you help me with all of that, please?

Oh and the file is in my OneDrive but I can put it in a SharePoint file, if it is required, of course. I guess people wouldn't be able to modify a file that is on my OneDrive?

So far, I didn't build anything for this particular flow because I just have no idea how to.

I want to create it separately to test it a few times and then if it's what I need, I'll add it to my existing flow (which I'm going to use).

T.H.A.N.K.S.

I hope someone will be able to help me.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-litu-msft on at

Like (0)

Report

Re: Modify a file then add it to an email [How to?]

Hi @paulb4,

According to your description of your requirement, you could create a Flow as below:

1. Create the trigger that When a new response is submitted, then get the response details;

2. Create the condition to determine the Question whether is equals D, then choose recipient to send email according to the response;

3. Update the row that A10, B10, and F10 store in, it should have some special value in a column, so I use the Number column with value 10 for the explanation.

4. After updating the Row, send the Excel file via email as an attachment;

5. Empty the row just updated for the next user by using the "null".

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
paulb4 44 on at

Like (0)

Report

Re: Modify a file then add it to an email [How to?]

Hello and thanks!

But I don't know how to send the file attached in the email...

What am I supposed to type???
Please!

Then I'll be able to test what you explained and I'll let you know if it works.

Thanks in advance @v-litu-msft .

Was this reply helpful? Yes No
paulb4 44 on at

Like (0)

Report

Re: Modify a file then add it to an email [How to?]

Hello,

I don't understand what I am supposed to type in 'Key Value', sorry...

For you to see what it looks like here's the file:

The cells A7 and E7 (not on the picture) are supposed to be modified (filled) then emptied after the email has been sent.

I tried to type 'Full name + user ID', it didn't work. I tried to type '7' ('cause you said to type '10' when I told it was cell A10 to be modified), it didn't work.
What must I do, please?

Here's the error message:

So how am I supposed to do, please?
Thanks in advance.

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

Like (0)

Report

Re: Modify a file then add it to an email [How to?]

Hi @paulb4,

You should add the Get file content action to get content of Excel file, then put the content into the Send Email action.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Like (0)

Report

Re: Modify a file then add it to an email [How to?]

Hi @paulb4,

You could create a column with a Special value for the Flow could finding the row, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No