a strange issue that when i normally use the FX to filter the gallery data by dropdown control but doesn't work this time.
the FX on the Item of gallery is filter(sharepointlist name, choices column.Value= dropdown.selected.Value) it show the error : "Incompatible types for comparison. these types can't be compared: Table,Text." any idea?
Also I would like to build a column chart in Power apps that X line put in Choice column value and Y line countrow.
by the way The Choice column is enabled "Allow multiple selections"
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.