Disable choice option if there is x number of items with that choice

(0) Share

Report

Posted on by FaerchDK

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)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FaerchDK

Please try this

Filter( Choices([@fdsfsa].Date), Not( Value in ( Filter( AddColumns( GroupBy( AddColumns( [@fdsfsa], "DateValue", Date.Value ), "DateValue", "GroupName" ), "Count", CountRows(GroupName) ), Count > 49 ).DateValue) ) )

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
FaerchDK 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @StalinPonnusamy

I'm not quite sure on how the formula works. But it works as intended.

Was this reply helpful? Yes No
FaerchDK 36 on at

Like
a
(0)

Report
Copy link

Link copied!
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

Regardles of the checkbox 'chkEmptyLocations'. Filter the string based on three comboxes (cboLocationFilter, cboRowFilter & cboPostitionFilter)
Only if the checkbox 'chkEmptyLocations' is true. Filter out choices if there are other items in the list with that Location, except if the column 'More than one blade' is equal to 1
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) ) )

Was this reply helpful? Yes No