Multiple selection checkboxes with Text Input saved to a SharePoint field

(0) Share

Report

Posted on by kmw1130

991

I posted this question already and I didn't mean to mark the answer as "answered" because I still had some question with the answer, which I never heard back. So I'm here to ask again if this is possible or what would be a best solution.

I have a multiple choice SharePoint field currently, which all works great, but now the user wants an additional text input box next to each of the checkboxes to add a percentage. All checkboxes with input text field can't exceed 100%.

This is currently what I have, which works:

This is the default on the each check box (except the name of checkbox changes):

If(chkboxITM.Text in ThisItem.Capability.Value, true, false)
 
And on the update of the Datacard:
ForAll(
    ForAll(Split(Concatenate(
        If(chkboxITM.Value, chkboxITM.Text & ",", ""),
        If(chkboxITO.Value, chkboxITO.Text & ",", ""),
        If(chkboxMission.Value, chkboxMission.Text & ",", ""),
        If(chkboxCyber.Value, chkboxCyber.Text & ",", ""),
        If(chkboxDigital.Value, chkboxDigital.Text & ",", ""),
        If(chkboxData.Value, chkboxData.Text & ",", "")
    ),
    ","
    ), {Result: ThisRecord.Value}),
    {Value:Result}
)

I don't know how to get the values to save of each input text box and to save in the SharePoint list, maybe something like this:
ITM-50%, MS-50%.

Is this even possible with a Multiple Choice SharePoint field?

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Abdul Wahab 49 on at

Like (0)

Report
Copy link

Link copied!

It appears that this is the most straightforward way to fulfill such a requirement using SharePoint.

Abdul Wahab
Direct: +923323281237
Email: abdulwahabubit@outlook.com
LinkedIn: https://www.linkedin.com/in/abdul-wahab-a5b8b011a/
Twitter: https://twitter.com/Abdulwahabubit
GitHub: https://github.com/AbdulWahabWarind
YouTube: https://www.youtube.com/channel/UCBjgLqLK_2kU-3bwo4McrTw

Was this reply helpful? Yes No
kmw1130 991 on at

Like (0)

Report
Copy link

Link copied!

Abdul Wahab,

It only fulfills part, it doesn't save the % values to the SharePoint List (Concatenate them with the checkboxes) and it does not save the values when the form is opened back up in either View or Edit.

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @kmw1130

Try this in the Update of the Data Card
With{ { _String: If( chkboxITM.Value, chkboxITM.Text & "," ) & If( chkboxITO.Value, chkboxITO.Text & "," ) & If( chkboxMission.Value, chkboxMission.Text & "," ) & If( chkboxCyber.Value, chkboxCyber.Text & "," ) & If( chkboxDigital.Value, chkboxDigital.Text & "," ) & If( chkboxData.Value, chkboxData.Text & "," ) }, With( { _Data: Split( Left(_String, Len(_String) - 1), "," ) }, ForAll( _Data As _D, {Value: _D.Value} ) ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @kmw1130,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kmw1130 991 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz,

I am going to try your recommendation and will post if it was successful. Thank you!

Was this reply helpful? Yes No
kmw1130 991 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz,

I tried you suggestion and didn't get any errors, but it doesn't save the % values.

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You have the same names for the text field as the check boxes

Was this reply helpful? Yes No
kmw1130 991 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz

The checkboxes I was going by another example I found online. I have InputText boxes called:

The default on the checkboxes is:

Are you saying if I use the chkboxITM.Text for the % value, that it will save ITM: 50% into SharePoint?
This is what it looks like now in SP:

Was this reply helpful? Yes No
WarrenBelz 153,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Yes, you need to reference the text boxes in the second parameter of each set (example below assumes that is a Modern Text Input you are using)
If( chkboxData.Value, 'txtData%'.Value & "," ) & . . .

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
kmw1130 991 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz,

Almost! It saves it correctly in SharePoint:

When Editing or Viewing, the ITM checkbox is not checked any longer

Was this reply helpful? Yes No