Answered

Change all blank fields to N/A on button press?

(0) Share

Report

Posted on by Farsie

I'm back struggling with radio buttons again, haha.

Scenario is an app for quality monitoring across several interaction types and subcategories - these are selected using two dropdowns.

Criteria visibility is linked to these dropdowns, and if a criteria isn't visible it is automatically marked N/A. Reviews can be saved partway through when review status is set to 'In progress' through a dropdown, and criteria that have not yet had a response filled in maintain their blank state.

This is the current formula:

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

There will be times when an interaction being reviewed is incomplete, meaning the rest of the criteria after that point will be marked 'N/A'. To save time, I want to have a button users can press to mark any criteria that do not have a response as 'N/A' at that point. I've created a variable, and have it set to false on screen load, and on button press the context is updated to true, however I cannot get the radio buttons to respond as I want - depending on what I do the criteria will either remain blank, or all criteria including ones that have a response will be changed to N/A.

Does anyone have any suggestions on how to get this working?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Farsie

can u try this:

If( !'criterianame_DataCard2'.Visible, "N/A", If( varMarkNA && IsBlank(ThisItem.'criterianame'.Value), "N/A", If( IsBlank(ThisItem.'criterianame'.Value) || DataCardValue22.Selected.Value = "In progress", "", ThisItem.'criterianame'.Value ) ) )

onselect of button:

Set(varMarkNA, true) // Sets the variable to true

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings
Farsie on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmbr1606 ,

Unfortunately not - if I have a selection made for the criteria already, it will change it to N/A as well. 😞
Verified answer

Farsie on at

Like
a
(0)

Report
Copy link

Link copied!
After some more fiddling, I've figured this one out.

Default of radio control:
If( !'criterianame_DataCard2'.Visible, "N/A", If( varMarkNA && !varradio && IsBlank(ThisItem.'criterianame'.Value), "N/A", If( IsBlank(ThisItem.'criterianame'.Value) || DataCardValue22.Selected.Value = "In progress", "", ThisItem.'criterianame'.Value ) ) )

Onchange for radio control:

Set(varradio, true)
Onselect of button:

Set(varMarkNA, true)

Onvisible for the screen:

Set(varMarkNA, false); Set(varradio, false)