Answered

Filtering options in drop down box

(0) Share

Report

Posted on by bropx024

So, I have a timesheet app in which users can go into a new timecard and from a dropdown list, select a list of projects and enter time against it.

The table that the Powerapp uses has a column which states whether the project is "Live Project", "Project finished" or "Project not kicked off". I only want the guys to see a dropdown list of "Live Project" options in the dropdown.

Currently, my items formula is

Search(Choices(Timesheet.ProjectDesc),DataCardValue8_1.SearchText,"Value")

I need to keep the search option in there as I allow the user to search within the dropdown, which speeds up the search for them.

Can somebody help me please?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @bropx024

What is the type of Project Type column?

Can you try to use the expression as:
If Project Type is a choice type field:
Search(Filter(Timesheet, ProjectTypeColumnName.Value = "Live Projects").ProjectDesc,DataCardValue8_1.SearchText,"ProjectDesc")

If project Type is a single line of text field:
Search(Filter(Timesheet, ProjectTypeColumnName = "Live Projects").ProjectDesc,DataCardValue8_1.SearchText,"ProjectDesc")

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,660 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @bropx024 ,

Try
Filter(Search(Choices(Timesheet.ProjectDesc),DataCardValue8_1.SearchText,"Value"),Project="Live Project")
Replace Project with whatever your field name is.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up.

Was this reply helpful? Yes No
bropx024 12 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you for the urgent response.

The "Project Status" field is from a sharepoint page and is a choice of the 3 options.

I have tried both formulae and they don't seem to work unfortunately, I get no options in my dropdown box still. I have included jpegs to show. The second one actually returns a red error and the first returns a warning, so I would assume that the first formula is nearest to the goal

Thank you

Was this reply helpful? Yes No
bropx024 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz, thanks for the prompt response

I still get no drop-down options using this formula, but it doesn't return an error. The formula seems to check out, maybe its a problem with the data somehow?

Thank you

Was this reply helpful? Yes No
bropx024 12 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz PPS, I had to use .value in the filter as it returned a red error if I didn't include it

Was this reply helpful? Yes No
WarrenBelz 155,660 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @bropx024 ,
I actually did a quick test in a new blank app on a SharePoint Choice field and the the format I gave you worked perfectly.

Was this reply helpful? Yes No
bropx024 12 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz thank you, i've put it as the solution as the problem is obviously somewhere with my data

Thanks for your help

Was this reply helpful? Yes No