cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

Hi @Anonymous

 

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

Hi @Anonymous

 

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

Anonymous
Not applicable

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? 

 

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

Anonymous
Not applicable

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?

 

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
)
Anonymous
Not applicable

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,171)