Check box in edit screen

[Anonymous]

Hi 

I got a requirement add check box in edit screen,instead of default combo box.

Data source is from share point as below

this is sharepoint view in the form

Share point details as below

I removed existing combo box in the data card and try to add check box as below ( just two for testing )

How can I write code in update function in data card. It gives me errors and no idea how can I integrate check box to match with it..

Please help on this

[CNT]

@Anonymous Is the number of choices in the sitting column static or will it change over time?

[v-albai-msft · Accepted solution]

Hi @Anonymous ,

I did a test on my side for you reference.

You can see below screenshot, I have added 5 checkboxes inside Siting DataCard :

Here is the code in Update property of Siting DataCard:

ForAll(
       Split(Concatenate(
                        If(Checkbox1.Value, Checkbox1.Text & ",", ""),
                        If(Checkbox2.Value, Checkbox2.Text & ",", ""),
                        If(Checkbox3.Value, Checkbox3.Text & ",", ""),
                        If(Checkbox4.Value, Checkbox4.Text & ",", ""),
                        If(Checkbox5.Value, Checkbox5.Text & ",", "")                
               ),
               ","
        ),
        {Value: Result}
)

You can check result now, try to add a new list item through your app.

Besides, based on your own requirement, maybe you need to set Defaults property of each checkbox, so that when you edit an existing record, the corresponding checkbox will have the value.

So set the Default property of the SitingCheckbox to following(my control name is Checkbox1😞

If(Checkbox1.Text in ThisItem.Siting.Value, true, false)

Set the Default property of the SetoutCheckbox to following(my control name is Checkbox2😞

If(Checkbox2.Text in ThisItem.Siting.Value, true, false)

Repeat above step for all other checkboxes.

Best regards,

Allen

[Anonymous]

@v-albai-msft , Really appreciate your support. I feel it is so great... 

As you said, I create a like this ( Still testing)

and cording 

ForAll(
Split(Concatenate(
If(Checkbox1.Value, Checkbox1.Text & ",", ""),
If(Checkbox1_1.Value, Checkbox1_1.Text & ",", ""),
If(Checkbox1_2.Value, Checkbox1_2.Text & ",", ""),
If(Checkbox1_3.Value, Checkbox1_3.Text & ",", ""),
If(Checkbox1_4.Value, Checkbox1_4.Text & ",", "")
),
","
),
{Value: Result}
)

No errors give in the code, but when I try to add a record, it trigger run time error

the issue is, I couldn't find any filed call Title, What can be this issue ? 😞

[CNT]

@Anonymous Title is a field automatically created in a SP list and it is mandatory. But you can change it, GO TO,

Click in Title

Change to No

Refresh the datasource inside the Power App

Please remember to give a 👍 and accept the solution as it will help others in the future.

[Anonymous]

Hi @CNT 

When I check, there wasn't Title column. So for testing, I added it. But same error is triggering 😞 

I am not the one who build SP table initially. Do u think is this due to  Title column was renamed to some other name ?

[CNT]

@Anonymous Yup, that's possible. It could have been renamed. As I had mentioned, SP by default adds this mandatory Title Column and when PA writes back to SP, because this Column is not getting patched, u'r getting an error. Please ask the creator of the SP list about the mystery behind the Title column. Hope this helps!

[v-albai-msft · Accepted solution]

Hi @Anonymous ,

You can get Required information for all columns in below Columns section:

All these required columns should have values when saving into Sp list on App side. Add all your required columns in your form or make them unrequired(not suggest).

I would strongly recommend you not to change the column property, just add these required columns into your form, since make them unrequired may cause other issues(especially for the Title column, this is very important in SharePoint side when doing some search function).

Best regards,

Allen

[Anonymous]

Hi @v-albai-msft @CNT 

you both are gr8. Really help to fix my app issues.  yes, as you mention Comment column had required tick, so I added it into PA. Now issue get solved. 

Thanks a again Guys. 🙂

[CNT]

@Anonymous Glad to help!

Please remember to give a 👍 and accept the solution as it will help others in the future.