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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.