cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dhananjaya
Helper I
Helper I

Check box in edit screen

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

dhananjaya_0-1621885749990.png

Share point details as below

 

dhananjaya_1-1621885852219.png

 

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

 

dhananjaya_2-1621885943483.png

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..

 

dhananjaya_3-1621886065694.png

 

Please help on this

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @dhananjaya ,

I did a test on my side for you reference.

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

v-albai-msft_0-1621910270188.png

 

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}
)

v-albai-msft_1-1621910270195.png

 

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)

v-albai-msft_2-1621910270203.png

 

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

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

v-albai-msft_3-1621910270206.png

 

Repeat above step for all other checkboxes.

Best regards,

Allen

View solution in original post

Hi @dhananjaya ,

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

v-albai-msft_0-1622079240740.png

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).

v-albai-msft_1-1622079461911.png

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

View solution in original post

9 REPLIES 9
CNT
Super User
Super User

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

v-albai-msft
Community Support
Community Support

Hi @dhananjaya ,

I did a test on my side for you reference.

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

v-albai-msft_0-1621910270188.png

 

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}
)

v-albai-msft_1-1621910270195.png

 

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)

v-albai-msft_2-1621910270203.png

 

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

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

v-albai-msft_3-1621910270206.png

 

Repeat above step for all other checkboxes.

Best regards,

Allen

View solution in original post

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

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

 

dhananjaya_0-1621972550673.png

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

dhananjaya_1-1621972691350.png

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

 

 

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

CNT_0-1621973628567.png

 

Click in Title

CNT_1-1621973694165.png

 

Change to No

CNT_2-1621973739748.png

 

Refresh the datasource inside the Power App

 

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

 

 

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 ?

 

dhananjaya_0-1622032860958.png

 

dhananjaya_1-1622032901983.png

 

dhananjaya_2-1622032977446.png

 

@dhananjaya 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!

Hi @dhananjaya ,

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

v-albai-msft_0-1622079240740.png

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).

v-albai-msft_1-1622079461911.png

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

View solution in original post

dhananjaya
Helper I
Helper I

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. 🙂

 

@dhananjaya Glad to help!

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,054)