Unanswered

Filtered collection in preview dropdown displayed not as text values but as unrelated numbers.

(0) Share

Report

Posted on by EOWWOE

I've written a formula that filters out projects from an overall project list if they appear in a SharePoint timesheet list.

Filter(ProjectList, Not(Projects in 'Timesheet Lines'.Project))

Strangely using this formula in the Items property of a preview dropdown doesn't display the correct text values, but a mysterious sequence of numbers. Referencing the selected value of the dropdown (drp_NewlineProject.Selected.Projects) returns the correct value though. The classic dropdown doesn't have this issue.

Here is a screen shot of the buggy preview dropdown (selected) and the classic correct one on the right.

Has anyone else seen this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

Hi @EOWWOE ?

What is Items of modern Dropdown? What is type of Projects?

Best regards,

Rimmon

Was this reply helpful? Yes No
EOWWOE 2 on at

Like (0)

Report

The table Projectlist has a text column Projects, the one I'm filtering. I've placed the formula in the Items property of the modern/preview dropdown.

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @EOWWOE ,

Please use "Projects" in display field of drop down.

If above doesn't work, try use AddColumns.

AddColumns(<your original filter formula>,"test","Projects")

Then select "test" column in display field.

Best regards,

Rimmon

Was this reply helpful? Yes No