cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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
Memorable Member
Memorable Member

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)

 

 

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

 

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

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

Community Support
Community Support

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.

@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

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

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

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (60,911)