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:
If ( Isblank(Lookup(Incidence; IncidenceID = DataCardValue1 && YESNO = DataCardValue2 ));
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.
Keep up to date with current events and community announcements in the Power Apps community.
Check out the latest Community Blog from the community!