i use the following steps to compare items in Excel and List

(0) Share

Report

Posted on by GUOGUO

389

Dear All

i use the following steps to compare items in Excel and List .. If the items in the Excel is exist in the List and has different value in vendor column , the flow will update items. Though , it has some bug .Could you please help to check? Thanks a lot.

Method 1:

Method 2:

So , i tried with following steps, but it will take a long time to update vendor column with a same vendor in every loop.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@GUOGUO

Can you please check my below blog post as I have detailed this solution:

https://onlinemgblog.wordpress.com/2021/05/29/building-flows-1-check-if-item-exist-and-update-if-exists/

Was this reply helpful? Yes No
Verified answer

GUOGUO 389 on at

Like (0)

Report
Copy link

Link copied!

Hi Mira ,
can I use ne =not equal in the expression to filter if items in excel has the same id items in the list and has different values in vendor. If so ,how can I get the id of these items? Thanks a lot.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@GUOGUO

I would suggest that you loop on the items on your Excel using apply to each and for each do Getitems to check if the items exist or not using filter expression if there is then you should update otherwise create new item in the sharepoint list, I don't know a way that can do this in one go.

Was this reply helpful? Yes No
GUOGUO 389 on at

Like (0)

Report
Copy link

Link copied!

Hi Mira
Thanks a lot.
Thanks for you help.

I only want to get the item IDs that meet the condition. I need the modified time.
m

Was this reply helpful? Yes No