My datasource base on SP list. Can powerapps extract the corresponding information from the list and show in screen.

[Dennis_Qiang]

My SP list roughly as follows：

I will create a screen for filter "WEEK" and "Product". If i choose Product as "AAA" and choose "WEEK" as "WW25", then click the bottom, will navigate to another screen and this screen will show the extract information from the list and show the format like below.

Can powerapps achieve this function?

Thank You!

Dennis

[jlindstrom]

yes, you can achieve this with a nested gallery/sub gallery. Here is a video tutorial https://youtu.be/ZzQ1t2sQvj8

[v-yutliu-msft · Accepted solution]

Hi @Dennis_Qiang ,

Could you tell me the fields' data type in your sharepoint list?

I assume that all of the fields that you listed are text type.

If so , you could set like this:

insert two drop downs to choose Product and choose WEEK

set drop down1's Items:

Distinct(listname,Product)

set drop down2's Items:

Distinct(listname,WEEK)

 Insert a label to display the selected product(AAA)

insert gallery1 to display the second level items(Apple-Moon)

insert gallery2 inside gallery1 to display the third level items(moonlight)

set label1's Text:

dropdown1.Selected.Result

set gallery1's Items:

GroupBy(
AddColumns(
Filter(listname,Product=dropdown1.Selected.Result,
                WEEK=dropdown2.Selected.Result
       ),
"project--subobject",
Concatenate(Project,"--",Subobject)
             ),
"Product",
"WEEK",
"project--subobject",
"highlights"
)

set one label's Text inside gallery1:

ThisItem.project--subobject

set gallery2's Items:

ThisItem.highlights

 

Best regards,