This is a bit of a weird one, but I'm having an issue with Power Apps or maybe SharePoint. I have an app that's using a patch statement to send over a Boolean value to a SharePoint list. The SharePoint lists stores that value in a Yes/No column. In another app, I'm trying to pull the information back into a collection based on that column where the value is true, so in essence:
ClearCollect(col_SharePoint_Data, Filter('List Name', Username = txt_Username.Text && Submitted = true));
where Username is a name in the column, txt_Username is filled in by the user, and Submitted is the name of the column storing the Boolean.
When I use the statement above, it's not pulling the correct data.
However, when I switch the statement to say,
ClearCollect(col_SharePoint_Data, Filter('List Name', Username = txt_Username.Text && Submitted = 1));
it works just fine, but there's a warning in PowerApps stating that I'm attempting to compare incompatible types (numbers and Booleans).
Can someone please help me understand how to make the first statement work so I can resolve the warning message? Just to reiterate and summarize, the first statement did not work at all. No errors or anything, it just didn't pull any data. The second statement (using the number 1 for true) did pull the data I needed it to, but there's a warning stating I'm comparing incompatible types.
