I have a column in the datavserse table with the data type Yes/No and now I want to check in the powerapp whether this value is set to Yes or No. I want to check whether this value is set to Yes or No in the powerapp. This was also possible with the command:
If(ThisItem.Favorit,'Star 24dp_blackOn', 'Star 24dp_black')
The command is executed on an image so that it switches through an onselect between two different images.
But I had to change the structure and therefore I no longer access the table directly but via a collection.
ClearCollect(colSearchFavourites, AddColumns('Order Employee Activities', "FavouriteStatus",Choices('Favourite (Order Employee Activities)')))
Then I had to change the command on the image to:
If(ThisItem.FavouriteStatus, 'Star 24dp_blackOn', 'Star 24dp_black')
I get the following error message: Invalid argument type (Table). Expecting a Boolean value instead.
Do any of you know a solution to my problem or possibly a better solution? (Attached is a picture of the column in question.)
The general problem: I had to restructure the collection because I needed a full text search on my table. The search was triggered via an input field. In the table there are different data types, text and numbers. The problem was that I could not search numbers and texts at the same time with Search. So I was recommended by the community to do it via the collection and then my current problem appeared.
