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

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
RobElliott
Super User
Super User

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

Hi Rob, very good solution indeed.

Ramin

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,699)