Automate using sharepoint list item to update attachment's excel table

(0) Share

Report

Posted on by LeoTan72

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.

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni on at

Like (0)

Report

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,

Was this reply helpful? Yes No
LeoTan72 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

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,

Was this reply helpful? Yes No
LeoTan72 6 on at

Like (0)

Report

Thanks, will out this flow.

Was this reply helpful? Yes No