Hello everybody
Can someone tell me where can I search the best way to copy multiple data from excel to any existing sharepoint list(4k+ data)?
It will run weekly +-
I'm a begginer in PowerAutomate and I want to understand how I can simplify this kind of work
Solved! Go to Solution.
Hi @t1agow
Currently i had sharepoint list with existing data
Now used a flow as below
1. Create a Scheduled flow
2. Inside it to to read the excel file, used the List Rows Present in Table action from Excel (Online) Business connector. [ here i had stored the excel file in one drive, with a table name Table1.]
Excel data is as below
action details
3. Now used the apply for each action to loop through each row of the excel , iterating through values variables.
Inside it used the create item in sharepoint action
screenshot added for better explanation
u can see i had added Name, ID, Job to Title, ID_1, Job under list using this
After running i got item from each row in excel added as below
Mark it as solution if it helps you
Regards,
Nived N
Hi @t1agow
Currently i had sharepoint list with existing data
Now used a flow as below
1. Create a Scheduled flow
2. Inside it to to read the excel file, used the List Rows Present in Table action from Excel (Online) Business connector. [ here i had stored the excel file in one drive, with a table name Table1.]
Excel data is as below
action details
3. Now used the apply for each action to loop through each row of the excel , iterating through values variables.
Inside it used the create item in sharepoint action
screenshot added for better explanation
u can see i had added Name, ID, Job to Title, ID_1, Job under list using this
After running i got item from each row in excel added as below
Mark it as solution if it helps you
Regards,
Nived N
Thank you @Nived_Nambiar !
I have problems with date format, how can I solve this problem? It goes with number format and PowerAutomate don't acept it
Thank you in advance
Hi @t1agow
Glad to know that my answer worked for you
so for the next case, u can try the
@Nived_Nambiar
I got the solution
I had to add this
User | Count |
---|---|
27 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
50 | |
29 | |
28 | |
24 | |
20 |