You’re offline. This is a read only version of the page.
Announcements
28
I have a SharePoint List with 2 columns, AssignedID and CompletedID. ID values are stored in each of these in the following format "1,2,3,4". What I am trying to do is anytime a new ID is added to the CompletedID column, it must be removed from the AssignedID column. I have two array variables storing these columns values, varAssignedIDArray and varCompletedIDArray.
varAssignedIDArray = "1,2,3,5"
varCompletedIDArray = "2,3"
Filter Result should be: "1,5"
Any variation I try either provides a result of null or "1,2,3,5". Can't seem to actually get it to filter.
The attached screenshot is the best formula I can come up with.
Help!! Thank you!
Hi @dbeckemeyer
Here is the sample flow:
[
1,
2,
3,
5
]
[2,3]
Next, add "Filter array" action to get the required array:
Share
Report
All responses (
Answers (
@not(contains(variables('varCompletedIDArray'), int(item())))
The output of filter action:
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
