cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jan_mac
Helper II
Helper II

How to show Sharepoint list Column

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. 

jan_mac_0-1626934312016.png

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? 

5 REPLIES 5
KvB1
Solution Specialist
Solution Specialist

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

v-qiaqi-msft
Community Support
Community Support

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.

vqiaqimsft_0-1626940034774.png

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.

vqiaqimsft_1-1626940986727.png

 

Best Regards,
Qi

I use filter on the gallery

Filter(MyLearning,Resource = Label1.Text)

Label1 contains the users email

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.

 

KvB1
Solution Specialist
Solution Specialist

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

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,646)