cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
FacundoGorla
Level 8

Filter Dropdown that takes choices from a SP column to only show values that exist in any of the elements of the list

Don't know if I expressed myself enough. Seems pretty simple but can't make it work.

 

I have a choice column in "Tipo de tarea" wich has 10 options.

Want to create a dropdown that ONLY shows the options that are already selected in any of the items.

 

The idea is to create a filter and i don't want to show ALL the choices, only the ones that are present in any element of the list.

 

In the future the idea es to also filter those options by specific user.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
FacundoGorla
Level 8

Re: Filter Dropdown that takes choices from a SP column to only show values that exist in any of the elements of the list

Solve it but I got the warning that it won't work when the list gets bigger...

 

What it does is filter a Choice column to only show the choices filtered by the values of another column and filtered by what user is using the app

 

Here's the code: 

Filter(
    Choices('Registro diario de tareas'.'Tipo de tarea');
    Value in Concat(
        Filter(
            'Registro diario de tareas';
            'Usuario Texto' = UsuariosdeOffice365.MyProfile().DisplayName
        ).'Tipo de tarea';
        'Tipo de tarea'.Value;
        "; "
    )
)

View solution in original post

3 REPLIES 3
FacundoGorla
Level 8

Re: Filter Dropdown that takes choices from a SP column to only show values that exist in any of the elements of the list

Solve it but I got the warning that it won't work when the list gets bigger...

 

What it does is filter a Choice column to only show the choices filtered by the values of another column and filtered by what user is using the app

 

Here's the code: 

Filter(
    Choices('Registro diario de tareas'.'Tipo de tarea');
    Value in Concat(
        Filter(
            'Registro diario de tareas';
            'Usuario Texto' = UsuariosdeOffice365.MyProfile().DisplayName
        ).'Tipo de tarea';
        'Tipo de tarea'.Value;
        "; "
    )
)

View solution in original post

Community Support Team
Community Support Team

Re: Filter Dropdown that takes choices from a SP column to only show values that exist in any of the elements of the list

Hi @FacundoGorla ,

Did you get delegation warning?

The reason why you met this problem is that you use non-delegateable functions.

Delegation warning is PowerApps itself limit.

If your data source is too large, PowerApps can not deal it all in local.

In this situation, you need to use delegateable functions to solve this problem. Or else, your app will perform not so good.

Could you tell me how many records do you have?

If you have less than 2000 records, you just need to change non-delegateable limit to 2000.

Even if you have this warning, your app will perform good.

delegation.jpg

 If your record number is more than 2000, you need to modify your formulas and only use delegateable functions.

Here's a doc about all delegateable functions of sharepoint list , please refer this to modify your formulas:

https://docs.microsoft.com/en-us/connectors/sharepointonline/

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
FacundoGorla
Level 8

Re: Filter Dropdown that takes choices from a SP column to only show values that exist in any of the elements of the list

Hi, thanks for the answer. 

 

It was a delegation problem in the formula indeed, I was using a 365 user function in the filter.

I replace it using the function in the OnStart of the app and saving results on a variable to use later in the filter and is woking perfectly.

 

Just have to solve the date delegation problem wich I saw it being solved by storing the date as a Int (concatenating it) and using that to compare and filter.

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,658)