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

Problem of comparing CSV again Sharepoint list

Would someone please do me a favour for this task.

 

I can already get the CSV file row by row.

I would like to compare a incoming CSV file against the SP list items, using the ID_2, and Sequence column are key, if ID_2, Sequence are equal but ID_4 not equal, update ID_4 from CSV file to list, otherwise skip.

 

The image is a snapshot, I actually have around 10K rows in the CSV, which have similar structure. Thanks.

 

List:

Image_List.png

CSV File:

Image_CSV.png

0 REPLIES 0

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,319)