cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
t1agow
Frequent Visitor

Add new rows in excel to an existing sharepoint list

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

1 ACCEPTED SOLUTION

Accepted Solutions
Nived_Nambiar
Resolver I
Resolver I

Hi @t1agow 

 

Currently i had sharepoint list with existing data

 

Nived_Nambiar_0-1627149278417.png

Now used a flow as below

Nived_Nambiar_2-1627149843368.png

 

 

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

Nived_Nambiar_1-1627149752989.png

action details

Nived_Nambiar_3-1627149890730.png

 

 

 

 

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

Nived_Nambiar_4-1627150010841.png

 

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

Nived_Nambiar_5-1627150092748.png

 

 

 

 

Mark it as solution if it helps you

 

Regards,

Nived N

 

 

View solution in original post

4 REPLIES 4
Nived_Nambiar
Resolver I
Resolver I

Hi @t1agow 

 

Currently i had sharepoint list with existing data

 

Nived_Nambiar_0-1627149278417.png

Now used a flow as below

Nived_Nambiar_2-1627149843368.png

 

 

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

Nived_Nambiar_1-1627149752989.png

action details

Nived_Nambiar_3-1627149890730.png

 

 

 

 

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

Nived_Nambiar_4-1627150010841.png

 

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

Nived_Nambiar_5-1627150092748.png

 

 

 

 

Mark it as solution if it helps you

 

Regards,

Nived N

 

 

View solution in original post

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

Nived_Nambiar
Resolver I
Resolver I

Hi @t1agow 

Glad to know that my answer worked for you

so for the next case, u can try the 

 

formatDateTime() expressions
 
Let me know if it helps you around
 
Regards,
Nived N

@Nived_Nambiar 
I got the solution
I had to add this 

'addDays('1899-12-30',int(item()?['Data']),'yyyy-MM-dd')'

Thank you !

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (3,137)