Answered

When a file is updated get the file and attach it based on a column data

(0) Share

Report

Posted on by SB-wrk

Hi Everyone,

I have a spreadsheet (fileowner.xlsx) in a SharePoint folder which has list of file owners' email addresses in one column and next column is the list of file names with their extension.

In the same folder I have all the files stored (spreadsheets).

I want if a file (spreadsheet ) gets updated, trigger a flow:

A. Look it up in the list of file names then list of file owners email address in fileownser.xlsx --->>> if file name = file names (formatted header)

B. Attach the updated file to an email from list of file owners' email addresses (formatted header) and send it to the file owner.

Can anyone help me with tips please?

Thank you

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (2)

Sort by

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @SB-wrk ，
I did a test for your reference.
In my scenario:
My Excel table:
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SB-wrk 80 on at

Like (0)

Report
Copy link

Link copied!

Hi Sunshine Gu,
Thank you very much for your instruction. It is working fine, however, when I test the flow I see this error.

However, the flow works fine and I received the email after updating a file. Do you know why I'm getting failures while its working fine?

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

Like (0)

Report
Copy link

Link copied!

Hi @SB-wrk ,
Post a screenshot of the configuration of your 'Send an email (V2)' control.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SB-wrk 80 on at

Like (0)

Report
Copy link

Link copied!

Hi Sunshine Gu,
I keep changing the "Body" to "File content" but when I press save and run the test, it switches back to "Body". I think this is the issue.

Regards,
SB

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

Like (0)

Report
Copy link

Link copied!

Hi @SB-wrk ,
This is not the problem. It is normal to switch to 'body'.
Please post a screenshot of your entire flow.
I can't see any problem from this screenshot for the time being.

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SB-wrk 80 on at

Like (0)

Report
Copy link

Link copied!

Sure, and thank you

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

Like (0)

Report
Copy link

Link copied!

Hi @SB-wrk ，
There is no problem with your flow configuration.
I have never encountered this situation before.
Could you show me the error information of your 'Send an email (V2)' control?
Like this:
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SB-wrk 80 on at

Like (0)

Report
Copy link

Link copied!

Hi Sunshine Gu,
Actually each time I make a change to a spreadsheet, I receive two emails.

Regards
SB

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @SB-wrk ，
How many times does your ‘condition’ control equal ‘true’?
Make sure there are no files with the same name in the 'file names' column of your excel sheet.
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
SB-wrk 80 on at

Like (0)

Report
Copy link

Link copied!

Hi Sunshine Gu,
You are 100% correct, I had the same name in one file name column.
That was the issue. 👏
Thanks heaps for your great help. 🙏

Was this reply helpful? Yes No