Hello,
I'm using a True/False Column type in sharepoint,
I have a incidence ID column.
Every incidence ID can reported up to two times. One time with true and one time with false from the incidence column. In PowerApps I'm using a slider for that.
Now on the OnSelect button in PowerApps I'm making a duplicate composite key check on those two columns:
OnSelect:
If ( Isblank(Lookup(Incidence; IncidenceID = DataCardValue1 && YESNO = DataCardValue2 ));
Submit (Form..............;
Notify(........
Now the duplicate check seemingly is working on the incidenceID but not on the Boolean column.
For instance I submit a IncidenceID which I already submit before, but with a different Boolean value, it completely ignores the YESNO column and notifies me that ID is already in the list.
I hope someone can tell why and if there is a workaround for that?
Thank you very much in advance.
Best.
