cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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
Highlighted
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
Highlighted
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

Highlighted
New Member

Re: Filter dropdown choices based on column value

Hi Rob, very good solution indeed.

Ramin

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (7,046)