cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mansoor88
Helper I
Helper I

Export data from Excel to SharePoint List uncomplete

Hello guys,

 

Hope you and your relatives are fine?

 

my problem is, I have one excel file to export and update to a Sharepoint List, 

and i made the flow but the Sharepoint list doesn't recall all the row, it means in the excel file I have 354 rows, and during the export i have only 256 row?

 

even for the update it dosn't work.

 

Please could you give me advise ?

5 REPLIES 5
v-bacao-msft
Community Support
Community Support

 

Hi @Mansoor88 ,

 

Please enable Pagination and set the Threshold as follows:

63.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello,

 

I did try, but didno't workout. I uploaded from excel  by exporting to Sharepoint

 

Many thanks, 

 

Hi @Mansoor88 ,

 

Could you share the full screenshot of the flow configuration?

Make sure that when you open Settings again, Pagination is already enabled.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

automate excel to sharepoint_0.JPGautomate excel to sharepoint_1.JPGautomate excel to sharepoint_2.JPGautomate update sharepoint from excel_3.JPGautomate update sharepoint from excel_4.JPGautomate update sharepoint from excel_5.JPG

Hello,

 

Thank you for helping me. I am learning through online tutorial.

 

Besides, here are some extra information:

I have created two Flows:

the first flow to export from Excel to Sharepoint List,

the second flow to update the sharepoint List based on the Excel Update.

 

The issues that I have face, 

1) If i do the export trigger, It does not recover all the rows, despite the paginationation and threshold activated and filled > I have 352 Rows in the Excel sheet, but i have only 255 rows recovered in the Sharepoint List.

 

2) if I do the Update flow, its is not updating accordingly, I have some extra rows created in duplicate for non purpose. result i have 300 rows after the update flow, which means 255 row initially imported, then 45 extra rows duplicates.

 

I am fresher, but determined to learn and make it by my way.

Please advise when the mistakes occur.

 

Many thanks for your support.

Best regards

 

 

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

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

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,284)