Answered

Radio button filling value when not required

(0) Share

Report

Posted on by Farsie

Hello all,

I’m hoping you can help me with this problem – I’m teaching myself as I go so it is probably a simple solution, but I haven’t been able to figure it out.

I’m trying to build an app to be used for quality monitoring. There are several interaction types that are monitored, and a number of subcategories. I have two dropdowns, one for the interaction type and one for the subcategory. The visibility of criteria changes depending on the selections made from these two dropdowns.

Each criteria is a choice column in a SharePoint list, with the choices set as Yes, No, N/A. The default is set to blank. Criteria that are not visible are set to fill ‘N/A’. N/A can also be used by people completing the form if the criteria isn’t relevant to the circumstances.

There will be times when the form cannot be completed in full in one sitting, so there are three status options also in a dropdown of Completed, In progress, and Invalid.

If this happens, when the status is set to ‘In progress’ and the form saved I want any criteria that do not have an entry to save as blank, however they are currently defaulting to N/A. This obviously presents an issue when returning to complete the review.

I’ve tried both these options in the default value without success:

Option 1 -

If ('criteria1_DataCard2'.Visible= false, "N/A", ThisItem.’criteria1'.Value)

Option 2 –

If(IsBlank(DataCardValue11.Selected.Value) || IsBlank(DataCardValue12.Selected.Value)," ", ThisItem.’criteria1'.Value)

What am I missing here?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Farsie ,

Could you please share more details about your scenario? What's the Items property of Radio control? Plus, could you clear the logic and tell us When will the radio value default to blank and when will it default to "NA"? If the logic is clear, formula would be quite simple.

Best regards,

Was this reply helpful? Yes No
Farsie on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni ,
The items property of each radio control is set to
Choices('Full Criteria List'.'criterianame')

With the criterianame matching to each criteria, e.g. if the criteria is 'Did the agent greet the caller?' it would be Choices('Full Criteria List'.'Did the agent greet the caller?')

The logic for the radio controls is:
If the user has selected an option = the selected option
If the criteria datacard visibility is set to false = N/A
If the user has selected no option = blank.

I would prefer to have the N/A linked to the datacard visibility because it will save work in the long run if the requirements of a criteria change, however if necessary, could also be linked to the two dropdowns selecting the interaction type and subcategory - following this path is how I ended up with option 1 vs option 2.

Does this help?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Farsie ,

I didn't see the logic relate to status, so I assume when the status combo box has selected "In progress" the Radio will also default to blank:

If (!'criteria1_DataCard2'.Visible, "N/A", If(IsBlank(criteria1ComboBox.Selected.Value) || StatusComboBox.Selected.Value = "In progress", ""))

Best regards,

Was this reply helpful? Yes No
Verified answer

Farsie on at

Like (1)

Report
Copy link

Link copied!
Hi @v-jefferni ,

The above formula doesn't work as criteria1 is a radio control, not a combo box. I've amended it to this, and it appears to be working - just making the distinction because it's exactly the kind of thing that I would get tripped up on at my skill level, and I hope this can help someone else in the future.

If (!'criteria1_DataCard2'.Visible, "N/A", If(IsBlank(ThisItem.'criterianame'.Value) || reviewstatusbox.Selected.Value = "In progress", "", ThisItem.'criterianame'.Value))

Thank you very much for your help!

Was this reply helpful? Yes No