I have a gallery with multiple items, and when a button is clicked, I want to check whether a specific value in a column can be found anywhere else in the SharePoint list.
Example from list:
Title | Internal ID
1 | 123
2 | 456
3 | 456
4 | 456
In my Gallery, I have listed Title 1 and 2 (not 3 and 4).
When the button is clicked, I want it to count the number of items in the list with the same internal ID (should be 1 and 3, in the example above, but only update context if > 1).
I've tried to use CountIf with the statement, but I just cannot figure out how to check all records in the SP list (I could do it by adding a non-visible gallery which displays all items in list, but that would make more clutter in the app than necessary).