Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Export data from Excel to SharePoint List uncomplete

(0) ShareShare
ReportReport
Posted on by 49

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 ?

  • Mansoor88 Profile Picture
    49 on at
    Re: Export data from Excel to SharePoint List uncomplete

    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

     

     

     

  • Mansoor88 Profile Picture
    49 on at
    Re: Export data from Excel to SharePoint List uncomplete

    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

  • v-bacao-msft Profile Picture
    on at
    Re: Export data from Excel to SharePoint List uncomplete

     

    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,

  • Mansoor88 Profile Picture
    49 on at
    Re: Export data from Excel to SharePoint List uncomplete

    Hello,

     

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

     

    Many thanks, 

  • v-bacao-msft Profile Picture
    on at
    Re: Export data from Excel to SharePoint List uncomplete

     

    Hi @Mansoor88 ,

     

    Please enable Pagination and set the Threshold as follows:

    63.PNG

     

    Best Regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow