cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sharram
Level: Power Up

Filter dropdown choices based on column value

Hi,

I have an manager approval flow for a document library. To the table I've added a column called Approved with Yes and No(default) values.

A user selects an entry and starts the flow.

When a manager has approved, the flow changes the value of Approved column for that entry to Yes.

I want to control the dropdown not to show the approval flow if an entry, with Approved value Yes, is selected. So only entries with No as value are allowed to start the flow.

Thanks

Ramin

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Filter dropdown choices based on column value

Hi Ramin @sharram, you can't hide the menu option but what you want to achieve can be done by creating a button in your list which only shows if the Approval is No. Laura Rogers has described this at https://wonderlaura.com/2018/07/18/button-in-sharepoint-list-to-trigger-microsoft-flow/

Rob
Los Gallardos

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Filter dropdown choices based on column value

Hi Ramin @sharram, you can't hide the menu option but what you want to achieve can be done by creating a button in your list which only shows if the Approval is No. Laura Rogers has described this at https://wonderlaura.com/2018/07/18/button-in-sharepoint-list-to-trigger-microsoft-flow/

Rob
Los Gallardos

View solution in original post

sharram
Level: Power Up

Re: Filter dropdown choices based on column value

Hi Rob, very good solution indeed.

Ramin

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 344 members 1,741 guests
Please welcome our newest community members: