comparing two sharepoint lists with lots of columns

(0) Share

Report

Posted on by myyytest

Hi guys

I am newto flow

I am having trouble using the Flow condition connector to compare two sharepoint lists with many columns. It is just so slow.

Is there a better way to do this? I have seen other use the Filtery array and the Odata Filter query to do this. Is this a good idea or is there something better for comparing 30 columns agianst another 30 solumns.

Thanks in advance,

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-litu-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @myyytest,

You could use the condition action to compare the 30 columns of the two SharePoint lists, you need to add two Apply to each actions to loop every item in the two lists, then you could add rows of condition just you like:

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

Was this reply helpful? Yes No
myyytest 28 on at

Like (0)

Report
Copy link

Link copied!

@v-litu-msft thanks for your help

I tried this but still not working, it only allows me to add a max of 10 conditions and not all conditions will complete because I am nesting conditings inside eachother.

Any idea on how I can consistently compare two lists with large columns?

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @myyytest,

You can create three groups in the condition, every group have 10 condition, for example, :

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

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @myyytest,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

Was this reply helpful? Yes No