power automate button: disable based on field value

[fess440]

Hi, assume i have 2 dates in my sample data: 1st jan'2021 & 1st feb'2021. Each date can be either approved/not approved. Assume 1st Jan'2021 is approved and 1st Feb'2021 is not approved. When I click on 1st Feb'2021, I want the power automate button to be enabled. When I click on 1st Jan'2021, I want the power automate button to be disabled. Essentially, I want the user to be able to start an approval process only for those dates that are not approved. Is it possible? I want to avoid the workaround of filtering the data for not approved only in the report. Thanks!

[Anonymous]

Hi @fess440 ,

There should be no similar function at present, you can submit your idea and vote on this page.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

This is surprisingly difficult to do. You cannot navigate to a bookmark based on a simple field selection (needs a button at least)  and you cannot yet change the appearance of the Power Automate button programmatically.

You may want to consider raising an idea or two for this.

[fess440]

@lbendlin is there a way to use RLS to hide the button? i just want to make sure that not every user can just haphazardly press the button. thanks for your time!

[fess440]

@lbendlin would it be possible to use RLS to create say 2 views: one where there is no button & another where there is a button for 2 different groups of users? i can make sure the right users press the button that way. i can make sure that automate permissions are assigned to the right users only but i don't want the button to be shown at all if not needed. thanks!

[lbendlin]

There are hacks that implement "page level security"  using RLS and hidden pages.  But they are just that - hacks. Anyone who has "Analyze in Excel"  access can still see all the data (according to their RLS permissions)