Hello
I need to populate several excel template files using the same sharepoint list, so when a new row is createad in my SPlist, the data should be copied in different excel files. Someone can help me to reach the target using powerautomate flow?
Hi @marcomizz,
I am afraid that you could not choose which column to copy from your SP list, which should be sepcifed not dynamically selected
thanks for your suggestion.
in my scenario I have to copy in several excel files not the same items of my sharepoint list, suppose I have a share point list with 10 columns like below:
Item | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | Data8 | Data9 |
1 | 10 | 20 | 30 | 15 | 2 | 10 | 4 | 5 | 8 |
2 | 70 | 1 | 10 | 15 | 14 | 8 | 6 | 99 | 5 |
then suppose I have to copy in two different exel files (in table format), for each item in the SP list the following data:
excel file 1: the Data1/Data3/Data4
excel file 2: the Data2/Data5/Data6/Data7/Data8/Data9
so I need choose in powerautomate flow, which column I need to copy from my share point list and in which excel file I need to copy those fields.
Best Regards
marco
Hi @marcomizz,
Do you want to copy item to different excel files at the same time?
If so, I think you need to list different tables at the same time, here is a simple demo for your difference:
I use the trigger when an item is created or modified, if you just create new items, you could use the when an item is created instead.
For the condition, just to check if the common column in your Excel table has existing value, in my scenario, Title is the common column between SP list and Excel table, if the new created Title equals to any Title in excel file, just update the existing row in Excel, otherwise, created a new row.
Okay, I will endeavor to assist but have a look at the following from@DamoBird365 first:
https://www.youtube.com/watch?v=RB_ySjhm9Sg
It might give you some pointers as the way to handle this issue.
Regards,
Andrew