Need to add a filter inside current formula on column chart of 3 dropdowns

[AslamAsu]

Facing one issue that is, i made my 3 dropdowns working over column chart from sharepoint list , the matter is using share point list two drop downs filtering are in one screen and perfectly wrking (ie: userstory & engineer) and rest formula for first dropdown is on another screen so i need two add that formula over this one can anyone  help,

*down below is the filter i need to add on top so the filtered months can be filtered firstly then after that the dropdown of userstory comes and below it is engineer dropdown,

Filter(AddColumns(PowerApps_Efforts,"DATES",Date,"MONTHS",Text(Date,"mmmm")),MONTHS=DrpDwnMonth_2.Selected.Name)

*down below is my full formula without errors,

AddColumns(
GroupBy(
AddColumns(
If(
Dropdown1_2.Selected.Value = "Stories" And DropdownEngineer_2.Selected.Value = "All Engineer",
PowerApps_Efforts,

If(
Dropdown1_2.Selected.Value <> "Stories" And DropdownEngineer_2.Selected.Value = "All Engineer",
Filter(
PowerApps_Efforts,User_Story.Value = Dropdown1_2.Selected.Value
),
If(
Dropdown1_2.Selected.Value = "Stories" And DropdownEngineer_2.Selected.Value <> "All Engineer",
Filter(
PowerApps_Efforts,
Engineer.Value = DropdownEngineer_2.Selected.Value
),
If(
Dropdown1_2.Selected.Value <> "Stories" And DropdownEngineer_2.Selected.Value <> "All Engineer",
Filter(
PowerApps_Efforts,
Engineer.Value = DropdownEngineer_2.Selected.Value And User_Story.Value = Dropdown1_2.Selected.Value
)
)
)
)
),
"Dates",Date,"months",Months
),
"Dates","groupdate"
),
"Hours",Sum(groupdate,Effort_Hours))

[AslamAsu]

Screen shot  is mentioned  below , in the below chart all are working without errors except for the first dropdown months ,

i have made the formula for dropdown months in another screen to eliminate complication And now i need to combine that filtering here currently i am facing issue over that the formula of filtering dropdown months is mentioned below

Filter(AddColumns(PowerApps_Efforts,"DATES",Date,"MONTHS",Text(Date,"mmmm")),MONTHS=DrpDwnMonth_1.Selected.Name)

@RezaDorrani @v-qiaqi-msft @WarrenBelz @zohaibukhan @Mira_Ghaly @Captain_Magpie @janson @Tiksha 

[WarrenBelz]

Hi @AslamAsu ,

This structure should be close

AddColumns(
   GroupBy(
      AddColumns(
         Filter(
            PowerApps_Efforts,
            (
               Dropdown1_2.Selected.Value = "Stories" ||
               User_Story.Value = Dropdown1_2.Selected.Value
            ) &&
            (
               DropdownEngineer_2.Selected.Value = "All Engineer" ||
               Engineer.Value = DropdownEngineer_2.Selected.Value
            ) &&
            MONTHS=DrpDwnMonth_2.Selected.Name
         ),
         "Dates",
         Date,
         "Months",
         Text(Date,"mmmm")
      ),
      "Dates",
      "groupdate"
   ),
   "Hours",
   Sum(
      groupdate,
      Effort_Hours
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[AslamAsu]

Showing me error on 13th line MONTHS  ,

Shows like name isn't valid MONTHG isn't recognized,Incompatible types these types cannot be compared

[WarrenBelz]

Hi @AslamAsu ,

I am using your values posted, assuming they were valid - that was from your first formula

MONTHS=DrpDwnMonth_2.Selected.Name

What exactly is MONTHS ?

[AslamAsu]

MONTHS are created to store 12 months in a year also i have created a collection OnStart as MonthList of 12 months on name and their ID in it

[AslamAsu]

I think that the MONTHS inside filter showing error just because the column is created outside filter

[WarrenBelz]

@AslamAsu ,

This was in your original post request to combine with the other filter and I cannot see the value MONTHS in your collection code. I simply did what you asked and combined the two pieces of code. For the code to work, MONTHS needs to be a field in the List PowerApps_Efforts, so your original post may be based on invalid data. Also what is the Items of DrpDwnMonth_2

[AslamAsu]

Thanks Warren ,

In that month dropdown a collection made on months is called which consists of 12 months in words having ID from 1 to 12,

Collect(MonthList, {ID:"1", Name:"January"},{ID:"2", Name:"February"},{ID:"3", Name:"March"},{ID:"4", Name:"April"},{ID:"5", Name:"May"},{ID:"6", Name:"June"},{ID:"7", Name:"July"},{ID:"8", Name:"August"},{ID:"9", Name:"September"},{ID:"10", Name:"October"},{ID:"11", Name:"November"},{ID:"12", Name:"December"})

[WarrenBelz]

@AslamAsu ,

A bit messy, but you need it at the bottom - note this is structure guidance only

Filter(
   AddColumns(
      GroupBy(
         AddColumns(
            Filter(
               PowerApps_Efforts,
               (
                  Dropdown1_2.Selected.Value = "Stories" ||
               ) &&
               (
                  DropdownEngineer_2.Selected.Value = "All Engineer" ||
                  Engineer.Value = DropdownEngineer_2.Selected.Value
               ) 
            ),
            "Dates",
            Date,
            "Months",
            Text(Date,"mmmm")
         ),
         "Dates",
         "groupdate"
      ),
      "Hours",
      Sum(
         groupdate,
         Effort_Hours
      )
   ),
   Months = DrpDwnMonth_2.Selected.Name   
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps