cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andy88
Level: Powered On

Make Rating Mandatory

Hi, 

 

I have a star rating system from 1-5, when we refresh the page the ratings should clear and be set to the default of 0. However we do not want anyone to skip those questions and output a rating of 0 so would like the button to move to the next page to be disabled when the rating is 0 (rating not filled in). 

 

Any help would be great. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Make Rating Mandatory

Hi @andy88

 

Assuming that your button calls the Navigate function, you can wrap this in a conditional statement to prevent the navigation when the rating value is 0. The formula would look something like this:

 

If(Rating1.Value <> 0, 
    Navigate(YourOtherScreen, ScreenTransition.Cover), 
    false
)

 

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Make Rating Mandatory

Hi @andy88

 

Assuming that your button calls the Navigate function, you can wrap this in a conditional statement to prevent the navigation when the rating value is 0. The formula would look something like this:

 

If(Rating1.Value <> 0, 
    Navigate(YourOtherScreen, ScreenTransition.Cover), 
    false
)

 

View solution in original post

andy88
Level: Powered On

Re: Make Rating Mandatory

Thanks for the reply. 

 

The button actually patches to my SP list rather than Navigate. 

 

Can I use 

If(Rating1.Value <> 0,

 part of the code to prevent the patch? 

 

Super User
Super User

Re: Make Rating Mandatory

Yes, you can use that syntax to prevent the patch.

andy88
Level: Powered On

Re: Make Rating Mandatory

Hi would the code be like this: 

 

If(Rating1.Value<>0, Patch(
    SPList,Defaults(SpList),
    {Columnname:Dropdownname.Selected.Value}
   )),false

Not sure if this is right?

 

Super User
Super User

Re: Make Rating Mandatory

I think your closing bracket is in the wrong place, but assuming that your rating control is called Rating1, then this code should work.

 

If(Rating1.Value<>0, 
Patch(SPList,Defaults(SpList), {Columnname: Dropdownname.Selected.Value} ),
false
)
andy88
Level: Powered On

Re: Make Rating Mandatory

Thanks, got it working so that it won't navigate or patch when the rating is 0. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 165 members 6,238 guests
Please welcome our newest community members: