Answered

while trying to show/hide a 'radio button' field on select change of a particular value in dropdown list in power apps, facing an issue from SharePoint side. The values are by default entered in the SharePoint list .

(0) Share

Report

Posted on by SOWMYA_RAJ

while trying to show/hide a 'radio button' field on select change of a particular value in dropdown list in power apps, facing an issue from SharePoint side. The values are by default entered in the SharePoint list .

Tried using this particular formula in "visible" property of a 'radio button' field : "If (Dropdown2.SelectedText.Value="Building A", true, false)".

So it's working fine in power apps side , like the 'radio button' field appears accordingly with "drop down " value selection. But in SharePoint side it's taking by default value "yes" from the 'radio button' field. So irrespective of any value given in "drop down " in power apps , in SharePoint it shows some or the other value rather than showing blank option for the particular 'parking slot' field, even though if we are keeping it hidden in power apps side , for different drop down value.

So , the admins accessing for a record , will assume everyone needs 'parking slot' according to SharePoint default values displayed.

So, the concept is for some 'buildings' , the 'parking slot option' should be hidden , for other buildings the option needs to be visible to book it . Please find the attached screenshots of the same. 'buildings'- drop down.

'parking slot option'- radio button.

So , if i select 'building B' here , in the SharePoint side for that particular records registered with 'building B' i need 'parking slot option' to be blank . It should be applicable to 'building A' the values 'yes' or 'no'.

Please do help here , have timelines to this project very nearby. Do revert back for any more details needed in detail.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @SOWMYA_RAJ ,

Firstly, you can simplify the Visible property of the radio control to simply

Dropdown2.Selected.Value="Building A"

which will either be true or false and will therefore reflect in the visible state of the control.

I am assuming you are using a Boolean (yes/no) field in SharePoint for this control. You cannot have a blank value on one of these, however you could change the Default to No/false. The other option would be to change this to a Text field in SharePoint and hard-code the drop-down Items with [“”, “Yes”, “No”] with the Default

If( Dropdown2.Selected.Value="Building A", "No", Blank() )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi thanks a lot for the options provided for the above, the SharePoint type used was " choice type (with radio buttons option) for "parking slot" field in power apps.

Also this field "parking slot" should be an required field to fill in power apps , only when an particular "dropdown value " is selected , not for all the values in dropdown(in this case "buildings"), kindly help how this can be achieved.

Was this reply helpful? Yes No
WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous ,

Firstly, you will need to change the Default to something suitable for all options (or have no Default).

Then you can test for it being visible and having no input on the save function

If( YourRadioControl.Visible && IsBlank(YourRadioControl.Selected.Value), Notify("Input required for xxxx", Error), Your current save code )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you so much for the response . Can you kindly mention in which "property" this code needs to be applied ? Is it in "display mode" property of control?
If( YourRadioControl.Visible && IsBlank(YourRadioControl.Selected.Value), Notify("Input required for xxxx", Error), Your current save code )
, to make the field as required , only for few selected values

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous ,

The code I supplied is for your save function. It checks whether the control is visible (hence an input is required) and then if so looks for input. If there is none, a message is generated, otherwise, the form saves as normal.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thanks a lot for checking on this , yes the code was fixing there . But I couldn't find the "on save" property for that particular control. so, I have made similar changes in the "display mode" function. Please find the attached screenshot for same , not sure how "on save" property is not visible here.

Also , I'm able to find the "thumbs up ' symbol but not , 'accept as solution' option . So , i did marked as 'thumbs up' , so the issue is resolved & will be helpful for others:)

Was this reply helpful? Yes No
WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous ,

You originally posted this thread as @SOWMYA_RAJ .

If you log in as this user, you will be able to accept it. Also, there is no “on save” function - I was referring to the button where you SubmitForm to save.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply . Yes , got it . Sorry I couldn't login to old account 'Sowmya raj' because of some account issues , not sure of exact issue. So here I have marked 'thumbs up' symbol which was possible . So the solution will be helpful for others.

Was this reply helpful? Yes No