Unanswered

Compare content of a Sharepoint List Item with another Sharepoint list Item

(0) Share

Report

Posted on by Lucky1975

Hi All,

I'm really new to Sharepoint and automation. I do have an education in IT so I can learn quickly, but I'm struggeling to find all the knobs and buttons etc...

What I am aiming to do with my sharepoint list is the following:

I have one Sharepoint list. In this list there is a colum defined as "ToSingnBy" and another column that is called "Signedby".

If the two columns in the same row match (after that everyone has signed documents and added their name to "signedby" I want another column ("Status) to change value ("Unsigned --> Signed).

The "ToSignBy" and "SignedBy" columns are of the type "person or group" and sometimes contain more thane one person. So I assume I have to compare them via an array of some sorts?

Can anyone point me in the right direction ?

Kind regards,

Luc

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

You are probably looking for something along these lines

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Lucky1975 2 on at

Like (0)

Report
Copy link

Link copied!

Thanx Darren,

I understand this logic, however, there is a possibility that there is more than one name selected in either the "ToSignBy" field and/or the "SignedBy" field. All of the names in "SignedBy" all have to be present in the "ToSignBy" regardless of the order they occur before a certain status can change

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

Apologies for the misunderstanding. So you need to put the results in an Array and then compare the arrays. For instance:

Also be careful is you are updating a record in the same list you are triggering from. You could create an infinite loop of triggering flows. If so make sure you have conditions\flags in the flow to stop the loops.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No