Share
Report
1,512I am trying to recreate something like this in my powerapps
I thought by putting nested galleries I could recreate it
Looks great except I am not sure how to filter it since the months are coming from a separate list in SharePoint, as I could not figure out how to just apply the months to the gallery.
I need to filter the information two ways, one by the user logged in and two by the combobox1_1.
I had uses something similar in another app with this code on the parent gallery
If(
!IsBlank(ComboBox1.Selected.'Customer Name'),
Distinct(
SortByColumns(
Filter (
LoadForecastData_1,
Customer = varCompanyName And Year >= 2019
),
"Year",
Ascending
),
Year
),
Distinct(
SortByColumns(
Filter (
LoadForecastData_1,
Customer = varCompanyName And Year >= 2019
),
"Year",
Ascending
),
Year
))and this code on the Child
SortByColumns(
Filter (
LoadForecastData_1,
Customer = varCompanyName &&
(IsBlank(Dropdown2.Selected.CustID) || CustID = Dropdown2.Selected.CustID) &&
Year = ThisItem.Result
),
"Year",
Ascending,
"i6fq",
Ascending
)I have also tried the groupby option on another app with this code on the parent
GroupBy(Filter(ChairSurvey_1,'Service Year'=2022),
"Survey_x0020_Type",
"Surveytypes"
)and this code on the child
Filter(ThisItem.Surveytypes, ChairPerson.DisplayName=ComboBox2.Selected.Chairperson.DisplayName)I can't get either to work
This is what is showing on the two galleries now
GroupBy(Filter('POWER SYSTEM ELECTRICIAN Work Hours',Year>=2020),"Year","Years")and this on the child
Months
I just cant figure out how to get this to all work.
All responses (
Answers (
