Building a flow - save e-mail attachement and contiunously update it

(0) Share

Report

Posted on by anettpb

Hi Dear Community,

I would like to build a flow, which automatically update file content, in an existing file in Sharepoint.

The trigger is an e-mail which comes in a daily bases with a certain subject, from a certain person.

I already started it and it runs succesfully, but the file content is not updated at all.

Thank you for the tips and help in advance!

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @anettpb ,

Could you please show your flow?
Unfortunately, in SharePoint we cannot update it by creating a file with the same name. But if the name of your email attachment is always the same as the file name in Sharepoint, you can find it in Sharepoint through the file name, delete it, and finally create a new file.

Best Regards,
Dezhi

Was this reply helpful? Yes No
anettpb 18 on at

Like (0)

Report

Hi @v-dezhili-msft

The name of the attachement is changing, only the e-mail subject and "from", furthermore the content structure is the same.
So you suggest to always delete the previous versions and save the attachement as a new/create file & get content?
Anyhow I attached a pic about the flow.

Thank you,
Anett

automated flow.jpg

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

Like (0)

Report

Hi @anettpb ,

If the subject of your email is always the same, you can try to create a subject column in your SharePoint folder to store the subject of the email, then you can find the file through this column and delete it, and finally recreate a new file with the email attachment folder and update the subject column.
Below is my test for your reference.

Best Regards,
Dezhi

Was this reply helpful? Yes No
anettpb 18 on at

Like (0)

Report

Dear @v-dezhili-msft

Thank you for your help!
Unfortunately the flow failed. Based on the error message it cannot find the subject column in sharepoint.
I am sending the flow and the SP site set-up as well.

Can you please help me what can cause this problem?

Thanks a lot,
Anett

automated flow_v2...

automated flow_v2...

automated flow_v2...

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

Like (0)

Report

Hi @anettpb ,

Is the place I circled the column you added?
Please try to replace the s of the subject in the filter query with S.

Best Regards,
Dezhi

Was this reply helpful? Yes No
anettpb 18 on at

Like (0)

Report

Hello @v-dezhili-msft

Yes, you are right, that solved the problem, thanks a lot!
But here is another issue, the prev. file not has been deleted. The goal would be to have 1 file in this folder, with up-to-date data.
Is it possible that the ID is not enough to find the file what should be deleted? What if I choose Subject as well?

Thanks again your suggestions and help!

Best regards,
Anett

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

Like (0)

Report

Hi @anettpb ,

After the flow runs successfully, do you still have the files to be replaced in your folder?
You can check the running history of your flow to confirm whether the Delete file action is running well.
In order to prevent handwritten input errors, we can try to quote the email subject directly from the dynamic content.

Best Regards,
Dezhi

Was this reply helpful? Yes No
anettpb 18 on at

Like (0)

Report

Dear @v-dezhili-msft

I changed the manual typed parameters, but the files still remained in the folder:

Do you have any idea what is the problem?

Thank you so much,
Anett

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

Like (0)

Report

Hi @anettpb ,

Let's try to use filter array action.
Notice these two columns in the run output.

Best Regards,
Dezhi

Was this reply helpful? Yes No
anettpb 18 on at

Like (0)

Report

Dear @v-dezhili-msft

The delete function is still not working. It is weird that here I cannot find any data/code:

I edited the flow as you described:

Thank you for any further suggestion.

Best regards,
Anett

Was this reply helpful? Yes No