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

Automatic update excel to sharepoint list

Hi Team,

In my SharePoint list, there are nearly 2 lakh rows with 4 columns. I have uploaded this data using import spreadsheet app.

Is there any option, If I modify that excel, it should be automatically update in SharePoint list without writing MS flow.
Flow is taking long time to get the records.
Thanks in Advance.

 

 

2 REPLIES 2
v-yutliu-msft
Community Support
Community Support

Hi @Nisha_18 ,

Do you want to update sharepoint list automatically when updating Excel?

Usually, we could only use PowerApps to update Excel or sharepoint list.

While based on your description, I think you want to update these two at the same time.

I'm afraid there's no direct way to make this currently in PowerApps.

As an alternative way, I suggest you save the data in collection before update it to Excel.

Then, use this collection to update Excel and sharepoint list at the same time.

For example:

1)I assume that you use a form to update Excel.

2)save the form's data as a collection:

ClearCollect(newdata,Form1.Updates)

 

3)use this to update two data source:

Collect(exceltable,newdata);Collect(listname,newdata)

 

 

 

Best regards,

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

Hi @v-yutliu-msft 
Thank you for your suggestion. You are correct. I need to update these two at the same time.  I think collection will save only 2000 records. But I have around 2 lakh records in my excel.

Is there any script available to run for automatic updation.?

Thanks in Advance.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (49,127)