Unanswered

PowerApps add score to Yes, No and NA Radio button

(0) Share

Report

Posted on by John-Gerald

Hello Folks, I'm working on an Audit app for my team and kind of stuck here... The functionality I need here is, If I select "Yes" or "NA" the points for the particular question should be updated. In this case its 6 points. If I select "No" then the points should be 0 for the initial question and -6 for the other questions as applicable. For now, I've managed to get only till here, but then this formula works for every single click, let's say if I select Yes first and then NA it adds 6+6. I just needed it to be 6 for the question and 0 or -6 incase of "No"... Any help is greatly appreciated. I'm really new to this and learning by our community's help.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like (0)

Report

Can you provide any information on you datasource? What is your datasource, how is you data modelled?...

Was this reply helpful? Yes No
Sumaira_Noor 18 on at

Like (0)

Report

@John-Gerald
Try below
If(yourRadioButtonName.Value="Yes",6,If(yourRadioButtonName.Value="No",0,-6))

Was this reply helpful? Yes No
bapala 247 on at

Like (0)

Report

Hi @John-Gerald,

It would be great if you can provide a data source where you are saving your data and how?
If I understood your question correctly, you can use something like below:

And use the 'label.Text' in Patch function to add this value to the data source.

Same goes for second question as well:

Hope this helps...!

Was this reply helpful? Yes No
John-Gerald 45 on at

Like (0)

Report

Thank you folks for your valuable time... The data source I use is SharePoint lists. I'm trying to do a similar "MS Forms/Quiz" kind of feature, but here is just 1 answer for every question. Scoring for "Yes" and "NA" is 6 and for "No" its 0. Do let me know if you need anything else.

Was this reply helpful? Yes No
John-Gerald 45 on at

Like (0)

Report

@jcfDaniel I've used SharePoint Lists as a data source here 😊

Was this reply helpful? Yes No
John-Gerald 45 on at

Like (0)

Report

@bapala this didnt work actually.

Was this reply helpful? Yes No
John-Gerald 45 on at

Like (0)

Report

@Sumaira_Noor This didnt work either, since I store the values on a global variable (PointsScore)

Was this reply helpful? Yes No
John-Gerald 45 on at

Like (0)

Report

I think I've found a solution, working on it. Will keep you all updated post-testing.

Was this reply helpful? Yes No
Verified answer

John-Gerald 45 on at

Like (0)

Report

I found a way to solve this problem... I created a set of new global variables for each of the question responses and then displayed them on each label - used this for each questions, renaming them as Q1,Q2,Q3, etc.

If(Q1PointsScore=0,If(Radio1.Selected.Value="Yes",Set(Q1PointsScore,Q1PointsScore+6))); If(Q1PointsScore=0,If(Radio1.Selected.Value="NA",Set(Q1PointsScore,Q1PointsScore+6)));
If(Q1PointsScore="",If(Radio1.Selected.Value="No",Set(Q1PointsScore,Q1PointsScore+0-6)));
If(Q1PointsScore=6,If(Radio1.Selected.Value="No",Set(Q1PointsScore,Q1PointsScore+0-6)));

Appreciate everyone's time and effort.

Was this reply helpful? Yes No