cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
t1agow
Advocate I
Advocate I

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 II
Resolver II

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 II
Resolver II

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

 

 

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 II
Resolver II

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (2,610)