cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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

Highlighted
sharram
Level: Power Up

Re: Filter dropdown choices based on column value

Hi Rob, very good solution indeed.

Ramin

>