Forum Discussion
If(Not(IsBlank([DataCardValue]) is always returning true in cases where it should not
I have a Power Apps Canvas app with a tab-like experience developed. The tabs are created from a gallery of buttons. There are fields on each tab. If a tab is selected, the tab fill should be bl...
- I started a new issue titled: Incompatible types for comparison. These types can't be compared: Table, Number. Setting this update as the best response on this issue so the issue won't have duplicate tickets.
I have made an additional discovery on this issue but not yet identified a resolution:
If the Visible Property is set to true so the field always shows
and the Gallery Fill property is set so that the field having a value is the only condition:
If(Not(IsBlank([DataCardValue14.Text])), Color.Green, Color.Gray)
the issue persists.
I tried setting the default value to 5, and then setting the Gallery Fill property to this:
If([DataCardValue14] = 5, Color.Green, Color.Gray)
This did not work but it did provide information about the issue:
Power Apps shows "Incompatible types for comparison. These types can't be compared: Table, Number."
So assuming 5 is the number, it looks like PowerApps sees DataCardValue14 is a table.
In the backend SharePoint, DataCardValue14 is a Single Line of Text field with no validations and it is not required. I do not know why PowerApps sees this field as a table. I have not found anything useful so far Googling the issue.
If the Visible Property is set to true so the field always shows
and the Gallery Fill property is set so that the field having a value is the only condition:
If(Not(IsBlank([DataCardValue14.Text])), Color.Green, Color.Gray)
the issue persists.
I tried setting the default value to 5, and then setting the Gallery Fill property to this:
If([DataCardValue14] = 5, Color.Green, Color.Gray)
This did not work but it did provide information about the issue:
Power Apps shows "Incompatible types for comparison. These types can't be compared: Table, Number."
So assuming 5 is the number, it looks like PowerApps sees DataCardValue14 is a table.
In the backend SharePoint, DataCardValue14 is a Single Line of Text field with no validations and it is not required. I do not know why PowerApps sees this field as a table. I have not found anything useful so far Googling the issue.
I started a new issue titled: Incompatible types for comparison. These types can't be compared: Table, Number. Setting this update as the best response on this issue so the issue won't have duplicate tickets.
