Share
Report
29Hello,
I am trying to create a Flow starting from the arrival of an Email with a specific Excel Attachment.
The Mail is always from the same Sender with a specific Value in the Subject so it's possible to specify in the Trigger, the Excel File also always has the same Name.
The Process itself is uploading the arriving Excel File to SPO and continuing from there with Listing up specific Rows and sending that Data to further work with it.
There are 2 major Problems with it.
1. As the Excel Actions in Flow can only be used on an already existing Excel File, the Attachments must always have the same Name so that they can overwrite the previous Version, which sometimes fails as SPO says the File is locked even tough it wasn't touched in over a day.
2. Even when the new Excel File overwrites the old one this sometimes messes with the Action "list up rows in a table" as the table Value gets changed and so the Flow fails.
If there are any ways to avoid these Issues please let me know. I am aware that using SPO Lists or updating an Excel that is already in SPO would be much easier but as of now they want me to try starting the Process from the arrival of the Email.
All responses (
Answers (
