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
Solved! Go to 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,
yes, you can achieve this with a nested gallery/sub gallery. Here is a video tutorial https://youtu.be/ZzQ1t2sQvj8
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,
User | Count |
---|---|
253 | |
106 | |
92 | |
47 | |
37 |