Hide or lock values in dropdown based on other outcomes of other columns

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I have a status column with f.e. the following options:

- Prospect

- Committed

- Greenlight

I was wondering if it is possible to hide or lock for example greenlight and unhide/unlock it when another column has a specific value, for example, the user can only choose the status greenlight if Target Amount reached 1000 or over.

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous You have to filter out the items you don't need in the Items property of the dropdown control. The formula will look like, Filter(your_data_source, If(TargetAmount<1000, Status<>"Greenlight",true))

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you for your reply! However, it concerns a model driven. Is it also possible for a model driven?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous You could probably achieve that through Business Rules.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No