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!
In the meantime I tried to investigate what can be the problem, and it is turned out, that we have a Sharepoint bug probably. We have a tremendous number of files stored and used in a daily basis on that Sharepoint site and folder what I wanted to use at this flow, but somehow the flow can not find anything there (when I went to the failed test and checked the output file, there was no any sign in there, that any file is existing in this folder).
Can you help me where can I get support to try to fix this?
Thank you in advance,
Anett
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
Hi @anettpb ,
Let's try to use filter array action.
Notice these two columns in the run output.
Best Regards,
Dezhi
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
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
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
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
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
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
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
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492