Filter Choices

(0) Share

Report

Posted on by ar87

353

Hi,

is there a way to filter Choice column (in Dataverse table) to not show one specific value from the dropdown list? This would only happen if a user didn't create a record in the previous step? Currently, the user can select any stage, but I want to disallow selection of 'Closed - Won' stage.

Screenshot:

This data card Items property is set to Choices(Stage), where Stage is choice column in Dataverse table.

Any advice is more than welcome.

Ty.

Best

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sdedic,

What do you mean by a user didn't create a record in the previous step?

Could you please share a bit more about your scenario?

If you want to filter choice values when a user has no created records in your data source, please try to set the Items property as below:

If(IsBlank(LookUp(Table,'Created By'.'Full Name'=User().FullName)),Filter(Choices(Stage),!(Value=Stage.'Closed - Won')),Choices(Stage))

Was this reply helpful? Yes No
ar87 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft,

First of all thank you for your reply and help.

So, in this application user fills in the form and creates a record called 'opportunity' (what I meant by previous step). Once the 'opportunity' is created, the app automatically creates another record called 'project request' and binds/relates it to the 'opportunity'.

Now, during that initial creation of 'opportunity' and 'project request' I don't want to allow users to have all stages in the 'Stage' field, as it doesn't make sense to select 'Closed - Won' stage since the opportunity/project hasn't started or been created yet. However, once this record is created, users have an option to edit the record, thus change the stage and close the 'opportunity'. Only at that point I want stage 'Closed -Won' to appear in the dropdown menu of the 'Stage' field.

Hope this makes things more clear.

Once again thank you for your help and time.
Best

Was this reply helpful? Yes No
ar87 353 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi again @v-qiaqi-msft,

the formula you provided above is working. All I needed to do is changing the condition to see if that particular project exists.

Thank you!

Was this reply helpful? Yes No