Notifications
Announcements
Hello,
I am trying compare two columns in Sharepoint list. Its column A and B. What will be in A and wont be somewhere in B, I want to save to column C.
Can I ask you for help please?
Thank you,
Jan
@Anonymous so you are looking to compare if Column B value does not contain value of Column A, then update value of Column C?
Also can you provide the data type of Column A and Column B in SharePoint?
Almost you have right. I dont need update value in column C - this column is empty and I need insert only non exist values in B.
Data type will be string.
Best regards,
okay, i didnt get this "insert only non exist values in B", can you provide sample values which can be in Column A and column B, for me to understand how to provide best suggestion on doing the comparison?
Yea, no problem.
This attachment will show you, what I need. I have columns Test1 and Test2. I need take value from Test1 and check if exist in Test2. If not, insert it to column No exist in Test2.
okay, so looks like you are using number values in the Test1 and Test2 columns, would that be the case in actual values? If yes then the comparison should be equals not contains and if the columns are to store text values then comparison can be contains, let me know.
It will be text with numbers
You can configure the condition as shown in below screenshot
I tried you recommendation and it doesnt work. It gave me error that first argument must be object, array or string.
I tried inicialization to array but it still doesnt work. 😕 Have you some tips please?
Error:
@Anonymous the data type of Test1 and Test 2 does not look same. Can you add two compose actions before the condition, and then assign Test 1 value to 1st Compose action and Test 2 value to 2nd Compose action and share the screenshot of both compose action from the flow run, for me to see what value is stored in Test1 and Test2?
No problem 🙂 I created again in EN version. It could be better for you.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional
