How to save the selected checkbox to sharepoint list

(0) Share

Report

Posted on by koray1

117

Hello,

How to save the selected Checkboxes values to SharePoint List Column?

Checkbox name: CDD and CDI

Sharepoint Colum name: Type_Of_Position

My send button is as below:

Patch(Personel_Talep_Formu;Defaults(Personel_Talep_Formu);{Title:Talep_Eden.Text ; Position_Name:Pozisyon_ismi.Text ; Section:Departman.Text ; Number_Of_People_To_Recruit:kisi_sayisi.Text ; Reason_Of_Request:sebep.Text})

Regards,

Koray

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Copy link

Link copied!

A couple questions first. Are the checkboxes in a Form or just on the canvas? What type of column is Type_Of_Position? And what value are you trying to save to the column?

Was this reply helpful? Yes No
koray1 117 on at

Like (0)

Report
Copy link

Link copied!

Hi @JR-BejeweledOne

checkboxes are only in powerapps.

The Type_Of_Position column is single-line text in the share point list.

What I want to save in the column is checkbox name I want to save the text in the text field of CDD or CDI whichever is selected.

If selected 1, column should be CDD-1 or if select 2 column sholud be CDD-2
Regards,

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report
Copy link

Link copied!
Here is how I would do it. In the OnCheck property of the checkboxes, set a variable. Set(varTypeOfPosition, "CDD-1") and of course CDD-2 for the other checkbox. You can use the same variable for both.

Then modify your patch statement like this:

Patch(Personel_Talep_Formu; Defaults(Personel_Talep_Formu); {Title:Talep_Eden.Text ; Position_Name:Pozisyon_ismi.Text ; Section:Departman.Text ; Number_Of_People_To_Recruit:kisi_sayisi.Text ; Reason_Of_Request:sebep.Text ; Type_Of_Position: Coalesce(varTypeOfPosition, Blank()) })

Was this reply helpful? Yes No
koray1 117 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much @JR-BejeweledOne

Was this reply helpful? Yes No