cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Filter on Depented Drop Down

Dear All,

 

I have an app in where i am using dependent dropdowns. For this apps i am using different SP list. My issue is as following:

 

1. Plant SAP Code: It is a look up field linked to user profile.

2. Based on SAP code i want to filter "transport mode"

 

For intence user who have MA11 SAP code should only see Road-FTL & Road-LTL on transport mode choice.

 

Which formula should i use of it? I tried to check it on the solutions but outcome was negative.

 

If you support me on this i will be glad.

2020-05-15 08_41_12-Transport Order Creation Tool - Saved (Unpublished) - Power Apps.png2020-05-15 08_42_30-Transport Order Creation Tool - Saving ... - Power Apps.png2020-05-15 08_44_32-EMEA Central Logistics - TON_TransportMode_Carrier - All Items.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Filter on Depented Drop Down

Hi @Ogun_ustun ,

Could you please share a bit more about the "Transport Mode" field in your "TON_TransportMode_Carrier" SP List? Is it a Choice type column?

 

If the "Transport Mode" field in your "TON_TransportMode_Carrier" SP List is a Text type column, please modify your formula as below:

Filter(
       Distinct(TON_TransportMode_Carrier, 'Transport Mode'),
       Result in Concat(Filter(TON_TransportMode_Carrier, 'Plant SAP Code' = DataCardValue2_1.Text), 'Transport Mode' & ";")
)

or

Filter(
       Distinct(TON_TransportMode_Carrier, 'Transport Mode'),
       Result in Filter(TON_TransportMode_Carrier, 'Plant SAP Code' = DataCardValue2_1.Text).'Transport Mode'
)

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Highlighted
Super User
Super User

Re: Filter on Depented Drop Down

First thing - Plant SAP Code is getting a delegation warning.  This may impact on any work you do if the List is more that 2000 records

 

Are Plant SAP codes finite - Eg: would the actual list of codes be less that 2000?  If so I would a separate list  and then make a collection on start up.  Use that for Reference (Knowing SAP this may not be the case)

 

 

Highlighted
Helper III
Helper III

Re: Filter on Depented Drop Down

Plant SAP code is coming to a list of which rows will be max 30.. In total, my company has 30 plants.

 

But for my main list linked to the application there will be more than 2000 records. Would it be still problem?

 

On this other hand how can we solve my first question?

 

Thanks

 

Highlighted
Super User
Super User

Re: Filter on Depented Drop Down

In your first LookUP.  User().Fullname is not delegable.   You are also using two filters that I do not believe can work

 

When a user opens the App have it set a global variable like Set(UserFN,User().Fullname)  now reference that in your formaula

 

Rplace User().FullName with the variable

 

You might also need to do something like:

First(Filter(Source,User=UserFN And PLantSapCode=DataCardValue)).PlantSAPCode

Highlighted
Helper III
Helper III

Re: Filter on Depented Drop Down

OK i sort the delegation problem out thank for the support.

 

Regarding my original request what kind filter formula that i should you because it is distinct formula.

 

2020-05-15 09_59_25-Transport Order Creation Tool - Saved (Unpublished) - Power Apps.png

 

2020-05-15 10_00_49-Transport Order Creation Tool - Saved (Unpublished) - Power Apps.png

Highlighted
Community Support
Community Support

Re: Filter on Depented Drop Down

Hi @Ogun_ustun ,

Do you want to filter your "Transport Mode" Dropdown box options based on the "Plant SAP Code" value?

 

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the "Transport Mode" Dropdown box to following:

Filter(
       Distinct(TON_TransportMode_Carrier, 'Transport Mode'),
       Result in Concat(Filter(TON_TransportMode_Carrier, 'Plant SAP Code' = DataCardValue2_1.Text), 'Transport Mode'.Value & ";")
)

 

Or you could type the following formula within the Items property of the "Transport Mode" Dropdown box directly:

Split(
      Concat(Filter(TON_TransportMode_Carrier, 'Plant SAP Code' = DataCardValue2_1.Text), 'Transport Mode'.Value & ";"),
      ";"
)

 

Please take a try with above solution, then check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Filter on Depented Drop Down

@v-xida-msft

 

I am getting error on ".Value". May i ask you to review it again? When out "." value is not coming automatically as a choice.

 

2020-05-15 13_06_58-Transport Order Creation Tool - Saved (Unpublished) - Power Apps.png

Highlighted
Community Support
Community Support

Re: Filter on Depented Drop Down

Hi @Ogun_ustun ,

Could you please share a bit more about the "Transport Mode" field in your "TON_TransportMode_Carrier" SP List? Is it a Choice type column?

 

If the "Transport Mode" field in your "TON_TransportMode_Carrier" SP List is a Text type column, please modify your formula as below:

Filter(
       Distinct(TON_TransportMode_Carrier, 'Transport Mode'),
       Result in Concat(Filter(TON_TransportMode_Carrier, 'Plant SAP Code' = DataCardValue2_1.Text), 'Transport Mode' & ";")
)

or

Filter(
       Distinct(TON_TransportMode_Carrier, 'Transport Mode'),
       Result in Filter(TON_TransportMode_Carrier, 'Plant SAP Code' = DataCardValue2_1.Text).'Transport Mode'
)

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Helper III
Helper III

Re: Filter on Depented Drop Down

@v-xida-msftreally appreciated for your quick reply ! It is now resolved.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,279)