Power Apps Dropdown from Sharepoint List of Column Type "Choice" not filtering correctly

(0) Share

Report

Posted on by jbl012

Hello, I have a Sharepoint list with a column 'Tasking Entity' of type "Choice" connected to a dropdown in Power Apps, with the intent that the dropdown will filter a gallery of rows in the Sharepoint list by the selected 'Task Entity' so that users can view all rows under that 'Tasking Entity', however, I keep getting an error that my types are incompatible for comparison even though they are both type "Record." Here's my dropdown code:

Choices('R9 Power Apps Input Form'.'Tasking Entity')

And here is my gallery code:

Filter('R9 Power Apps Input Form',

'Tasking Entity'=Dropdown2.Selected)

The gallery code gives the following error message: "Incompatible types for comparison: Record, Record."

Can anyone help with this issue? Thanks in advance!

Categories:

Building Power Apps

Power Apps Dropdo...

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@jbl012 - assuming the Choice field in your data source is a single-select choice field, try:

Filter( 'R9 Power Apps Input Form', 'Tasking Entity'.Value = Dropdown2.Selected.Value )

Was this reply helpful? Yes No
jbl012 17 on at

Like (0)

Report

That worked, thank you!

Was this reply helpful? Yes No