I have a Powerapp form tied to a sharepoint list with a required field called Services. The datacard receives its data from a choice list item which I deleted and instead created checkboxes. The card has the following update formula to track the selected choices to submit back to the Sharepoint list item Services. However, this required field does not generate an error when none of the checkboxes are selected. I feel the following "Update" formula may be the cause of the problem as I'm not too familiar with all the functions yet
If(chkAccounting.Value, chkAccounting.Text & ",", ""),
If(chkAudit.Value, chkAudit.Text & ",", ""),
If(chkConsulting.Value, chkConsulting.Text & ",", ""),
If(chkCompil.Value, chkCompil.Text & ",", ""),
If(chkIsIt.Value, chkIsIt.Text & ",", ""),
If(chkLit.Value, chkLit.Text & ",", ""),
If(chkRev.Value, chkRev.Text & ",", ""),
If(chkTax.Value, chkTax.Text, "")
Any help is greatly appreciated. Thanks!
Solved! Go to Solution.
I believe I did identify the field as a "choice" field, so you were correct in your assumption.
This formula works as now I see the error, but the problem it creates (and not sure if this is a function of the formula or my setup) is that if anyone goes back in to edit/view the record the record the radio button doesn't retain the option that was selected prompting the user to select it again.
How can I keep the appropriate radio button marked based on what the original requestor selected?
The control is a radio button control and the column in the Sharepoint is a "Choice", but multiple selections are not enabled/allowed. However, after I applied the default formula I'm still not seeing the radio option marked with the original selection when I edit the item. Any other ideas? thanks for your help.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200