I have a SharePoint list [fdsfsa] with a choice [Date] column.
The choice column has 5 choice options.
In Power Apps I want to disable each choice option which have more than 49 items with that choice option.
I can disable one choice [CW4: 24th – 28th January 2022] with the code below.
But if I need to code all the combinations it's gonna be a very long formula.
Is there an easier way to do this?
If( CountRows( Filter( fdsfsa, Date.Value = "CW4: 24th – 28th January 2022" ) ) > 49, Filter( Choices([@fdsfsa].Date), Value <> "CW4: 24th – 28th January 2022" ), Choices(fdsfsa.Date) )
Solved! Go to Solution.
Hi @StalinPonnusamy can you help again with a similar issue?
I need to filter the choice options from the SharePoint list lookup column 'Location'.
I want to filter based on the following criteria
SharePoint list: 'Blade Status'
Choice column: 'Location'
String column: 'More than one blade'
With the help you gave me for my other issue, I have come up with the code below.
The only thing missing is to keep the choices where the column 'More than one blade' is equal to 1
Can you help?
If( chkEmptyLocations.Value = true, Filter( Choices( [@'Blade Status'].Location, Trim(cboLocationFilter.Selected.Value & " " & cboRowFilter.Selected.Result & " " & cboPositionFilter.Selected.Position) ), Not( Id in (Filter( AddColumns( GroupBy( AddColumns( [@'Blade Status'], "LocationID", Location.Id ), "LocationID", "GroupName" ), "Count", CountRows(GroupName) ), Count > 0 ).LocationValue) ) ), Choices( [@'Blade Status'].Location, Trim(cboLocationFilter.Selected.Value & " " & cboRowFilter.Selected.Result & " " & cboPositionFilter.Selected.Position) ) )
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.