Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Duplicate Check with a True/false column type



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 ));

Submit (Form..............;



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.




Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,436)