You’re offline. This is a read only version of the page.
Hello,
quite fresh in Power Automate and I am having this situation, where I have no idea how to manage it:
Item in the list is created manually, some fields are mandatory, some not, which remain empty in moment when item is created.
When item is created I have automatically triggered flow to add empty excel template in the item attachment, taken form Documents in Sharepoint site: "Get file content using path" + "Add attachment". Excel is consisting of Table with the same columns structure as columns in sharepoint list to be updated. Fields going to be later updated by this excel are are not those mandatory columns.
Now user will add requested data in the excel attached in the item.
And now, I need to create manually triggered flow to update the existing item in sharepoint list and its columns, by uploading data from excel attached in the item without changing mandatory columns defined in moment of item creation.
Gurus, please help me to build this flow
Thank you very much
Hi @PeterBelko
I am afraid currently this is not possible under Microsoft Flow.
You can't get the data of the table in Excel from the attachment column, because the List rows present in a table cannot be located.
This link also mentions that it is impossible to get the data of the Excel table in the attachment column.
Update SharePoint List using Excel Attachment - Power Platform Community (microsoft.com)
But you can create a new idea through the below URL, then ask your colleagues to raise up the votes.
The product team has direct visibility of these ideas and they will implement it on the basis of the highest number of votes received.
Best Regards,
Levi
Share
Report
All responses (
Answers (
237
