Answered

How do I overwrite an excel file downloaded as an email attachment daily (newbie)

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am new to Power Automate. I have managed to create a workflow that captures an email when it comes in. And saves the attachment to a folder on OneDrive (business). Its an excel file generated and sent from another system on a daily basis.

I want the file to always be the same name and to get overwritten each day. As its being referenced by Power BI as a visual report.

Can Power Automate undertake this function?

Thanks.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Here is test for your reference:

[List files in folder]: List the files in the folder
[Condition] Determine whether the attachment name is the same as the file name in the folder
If the same, update the file,
If different, create a new file

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft Firstly, thank you so much for taking the time to respond and assist me. I am trying to follow your instructions but I seem to be going wrong somewhere. I don't seem to be able to get the yes and no option. Not sure where I am going wrong.

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

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Could you provide some screenshots about the error and your flow?

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey @v-chengfen-msft ,
I have solved it, I went back and created a new flow from scratch using your instructions. Thank you so much for your help!!!!

Was this reply helpful? Yes No
DO-10111352-0 34 on at

Like (0)

Report
Copy link

Link copied!

so what are the steps??

Was this reply helpful? Yes No