Unanswered

Power Apps list box multiple columns

(0) Share

Report

Posted on by HM-22080408-0

Hi Members,

I have a requirement in Power Apps where I want to add the Column names to a Power Apps list box and filter the gallery based on the selected value of the List box.

Scenario:

I have a SharePoint list as 'Power Platform Training' as shown below:

List box error.jpg

On my Power Apps screen, I have added a List box control and displayed the column names from a SharePoint list

List box error1.jpg

Now, I added a Gallery control -> Set its Items property to:

Filter('Power Platform Training',ListBox1.Selected.Value)

List box error2.jpg

However, the gallery is filtering the column values randomly.

List box error3.jpg

But, I need to filter the gallery; when the user selects a Column name as Course, the gallery should give the values only from a course like "Power Apps," "Power Automate"..., etc

Can anyone please suggest how I can resolve this? Thanks in advance!

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Hemashree ,

Do you want to show specific column of SP list according to ListBox1.Selected.Value?
Please try this on Items of gallery:
Switch(ListBox1.Selected.Value, "User ID", ShowColumns('Power Platform Training',"User ID"), "User Name", ShowColumns('Power Platform Training',"User Name"), "Course", ShowColumns('Power Platform Training',"Course") )

Best regards,
Rimmon
HM-22080408-0 67 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank You @v-mengmli-msft

Now, my gallery is displaying only boolean values, as shown below:

Please help me recover this @v-mengmli-msft. Thanks in advance!
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Hemashree ,

Oh! I didn't notice that you want to show value of specific column in gallery.
There is a simpler way for your reference:
Items of Gallery:
'Power Platform Training'
Text of control in gallery:
Switch(ListBox1.Selected.Value, "User ID", ThisItem.'User ID', "User Name", ThisItem.'User Name', "Course", ThisItem.Course.Value)

Best regards,
Rimmon
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Hemashree ,

How is the situation now?
If my answer helps you solve the problem, please accept it as a solution.

Thanks in advance.
Rimmon
simsek-serhat 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello
Power apps to add the Training column I've opened on my SharePoint page
how i would like to group and send for approval. thank you