Compare User's Current Access vs Previous Access

[fjlorenzo]

Hi Everyone,

I need to compare the access of all users from the current vs previous user listing. User can have one or more access and user's access is separated by a bar "|". Below are my tables. Thank you for your help.

Previous User List

Name	Access
Alex	Client Read Only Prod Account|Client Production Modify Broker
Allen	Client Read Only Prod Broker - Account
Romy	Client Read Only Prod Broker - Account
Malou	Client Read Only Prod Broker - Account
Jane	Client UAT Test|Client Read Only Prod Broker - Account|Client Production Modify|Client UAT
Ann	Client Read Only Prod Broker|Client Production Modify Account|Client Development
Adrian	Client Production Modify Broker|Client Production Modify|Client UAT|Client Full Access|Client Development|Client Production

Current User List

Name	Access
Alex	Client Production Modify Broker|Client Read Only Prod Account
Allen	Client Read Only Prod Broker - Account
Romy	Client Read Only Prod Broker - Account
Malou	Client Production Modify Broker
Jane	Client UAT Test|Client Production Modify|Client UAT|Client Read Only Prod Broker - Account
Ann	Client Development|Client Production Modify Account|Client Read Only Prod Broker
Adrian	Client Production Modify Broker|Client Production Modify|Client Development|Client UAT|Client Full Access|Client Production

[flying008]

Hi,@fjlorenzo 

FYI.

[fjlorenzo]

Hi @flying008 , looks good and thank you for responding. Can you send the workflow please.

[flying008]

Hi, @fjlorenzo 

I didn't saved the flow, maybe you can try it with above gif yourself.