You’re offline. This is a read only version of the page.
6
I am fairly new to power automate.
Is it possible to update the excel file attachment in sharepoint list using the item inside the list?
I wish to do the following example:
1) create an sharepoint list item
2) auto attach an excel file after item is created
3) read one of the item entry and update the excel file attachment (copy sharepoint list item "name" and update excel table "name")
Is it possible to do that?
Thank you.
Hi @LeoTan72 ,
So, there would always be a single record in the file of an item in the list, am I right? If this is the case, you can use the initial excel file as a template, copy the file and create a new one use the file content of template file, add a row to the table in this new file using SP list new data, add the updated file into list item Attachments field, delete the new file and make the drive clean.
Best regards,
Thanks for the reply.
I thought of that flow too, but the file that is going to be auto attached may be edited by multiple user at the same time and the information entered would mixed up.
example:
file_a is for auto attachment
for every new entry, file_a will be edited first in input "name" and auto upload into the list as attachment
if there is a concurrent entry and edit by multiple user, would there be multiple "name" into the that file as attachment?
meaning instead of each file_a contains a single individual "name", it would have multiple different "name" inside file_a.
Hi @LeoTan72 ,
If the Excel file is saved in a library or OneDrive folder and will be added into the default Attachments column of the list, you'd better update the file first using SP item values and then add this modified file as an attachment.
Best regards,
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
