Filtering dataverse data starting with dropdown values

(1) Share

Report

Posted on by Misa

248

Hi.

I have a dropdown that lists project numbers. For example, a project number would start with12345.345. I would like to filter a table with project numbers that start with12345.345. I tried using

Filter(Projs, ProjNumb = StartsWith(ProjNumb, dd_Proj_Numb.Selected.Value) in the Items field and its not working.
 
Thank you for looking.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mark Nanneman 991 Moderator on at

Like (1)

Report
Copy link

Link copied!

Just use the StartsWith operation (delete the "ProjNumb =" operation). You're not looking for what ProjNumb is equal to, you're looking for what it starts with.

Filter(Projs, StartsWith(ProjNumb, dd_Proj_Numb.Selected.Value))

The Filter function basically just returns items from a collection that cause a "True" boolean after going through whatever formula you put in the Filter.

Was this reply helpful? Yes No
Misa 248 on at

Like (1)

Report
Copy link

Link copied!

Thank you soo much @mark_n!! Not sure what i was thinking. It worked.

Was this reply helpful? Yes No