I come from a programming background so I feel this should be an easy answer. I have a form with radio buttons that submit the selections to a sharepoint list. My question is, I want to average up the selections from the radio buttons up and display the average on a seperate screen. In I'm assuming would be a text label. Is this the right way? Or is it possible to pass values to a seperate screen?
In my text label where I'm trying to pass the values I have,
Average(Radio1.Selected.Value, Radio2.Selected.Value...RadioN.Selected.Value)
Solved! Go to Solution.
I was able to fix it, I had to move the average function in front of the submitForm function in the on select function
Programming not so helpful experience, more of Excel formula building that is helpful!
All your controls are global in the app, so you can access them from any screen. You don't need to pass it to the screen.
So, with the formula you have for your text label, what is the issue?
Hi,
You can use Set function to save value to a variable - Set(varTotal, "Hello") on a button click that is used to navigate from one screen to other screen. https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-variables Here is the link for your reference
The issue is that nothing is showing up in the text label.
Have you submitted the form that contains the Radio Controls? If so, then depending on the default mode of the form and any other functions (such as NewForm) that you might issue, the Radio controls may not have the value on them any longer.
Hi You can use OnChange property of radio buttons -
OnChange property you can set variable - Set(varAvg, Average(Radio1.Selected.Value, Radio2.Selected.Value))
I have the DefaultMode set to New with every submission.
I was able to fix it, I had to move the average function in front of the submitForm function in the on select function
User | Count |
---|---|
126 | |
87 | |
84 | |
75 | |
69 |
User | Count |
---|---|
214 | |
178 | |
139 | |
105 | |
83 |