Unanswered

How to show Sharepoint list Column

(0) Share

Report

Posted on by jan_mac

106

I hope you can help me I have a sharepoint list the requirement is to show the sharepoint COLUMN HEADER together with their corresponding value through a checkbox.

As you can see on the sample photo "Agile Foundations Srum Master Training, and Product Owner Training" are sharepoint columns their values are Completed and Not Started which is represented by the Checkboxes on the left. The goal is to make it look like updating multiple rows when in reality it's updating a single row with multiple columns, I tried creating this in a vertical blank gallery and manually adding the columns and check boxes but I am stuck I could not add more columns and check boxes and there are 30 more columns I also need to separate the Completed columns and Not started columns. As you can see I am lost please advice should I use a form instead? Or is this too ambiguous for powerapps?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

KvB1 1,596 on at

Like
a
(0)

Report
Copy link

Link copied!

What value do you use to find the correct record in the list?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jan_mac,

Could you please tell me how you configure your data and your Checkbox?

Do you want to update all the three column with the Checkbox text?

Based on your description, if you want to update each column with different status value, you should insert 6 Checkboxes within a single section of the Gallery. Each column should have two separated Checboxes to select the status value.

I have a simple test for you, please check as below.

1). Insert 6 Checkboxes into the Gallery as below, set the Text of the separeted Checkbox the red lined input.

2). Set the following properties of the Completed Checkbox corresponding to 'Agile Foundations' as below:

OnCheck: Patch(Tab2,ThisItem,{'Agile Foundations':Checkbox3.Text})
OnUncheck Patch(Tab2,ThisItem,{'Agile Foundations':""})
Default: If(ThisItem.'Agile Foundations'=Checkbox3.Text,true,false)

Please repeat this for the following 'Srum Master Training', and 'Product Owner Training' column.

3). Set the following properties of the Not Started Checkbox corresponding to 'Agile Foundations' as below:

OnCheck: Patch(Tab2,ThisItem,{'Agile Foundations':Checkbox4.Text})
OnUncheck: Patch(Tab2,ThisItem,{'Agile Foundations':""})
Default: If(ThisItem.'Agile Foundations'=Checkbox4.Text,true,false)

Please repeat this for the following 'Srum Master Training', and 'Product Owner Training' column.

Was this reply helpful? Yes No
jan_mac 106 on at

Like
a
(0)

Report
Copy link

Link copied!
I use filter on the gallery
Filter(MyLearning,Resource = Label1.Text)
Label1 contains the users email

Was this reply helpful? Yes No
jan_mac 106 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello. For configuration I put a filter so the gallery will only show one record, as for the checkbox I put a condition on the default
If(ThisItem.'Agile Foundations' = "Completed", true, false)
I understand your approach however I can only use one checkbox for each column which means if the checkbox is uncheck it will be seperated from the Completed columns.

Was this reply helpful? Yes No
KvB1 1,596 on at

Like
a
(0)

Report
Copy link

Link copied!
The following code will patch the records in sharepoint that are shows in the gallery. For this to work. the Items property needs to be directly linked to youre sharepoint list, which i believe it is in your case

ForAll(Gallery1.AllItems, Patch( MyLearning, ThisRecord, { AgileFoundations: If(Checkbox1.Value=true,"Completed",If(Checkbox1.Value=false,"Not Started")); ScrumMasterTraining: If(Checkbox2.Value=true,"Completed",If(Checkbox2.Value=false,"Not Started")); ProductOwnerTraining: If(Checkbox3.Value=true,"Completed",If(Checkbox3.Value=false,"Not Started")) } ) )

Was this reply helpful? Yes No