Cascading dropdown based on detected user

(0) Share

Report

Posted on by ocin33

104

Hi guys,

I need to create a dropdown list that will show the data assigned with the user that currently uses the app. I have created a supportive sharepoint list with the assignments:

When the user "Mateusz...@....pl" he should have two options to choose in the dropdown, when "Julita....@....pl" she should see only one option.

In the app - the user is detected "OnStart" and I have put the label with detected mail address in the form. "Firma transportowa" dropdown column should show data basing on the supportive sharepoint list.

Can you help me with this issue?

Regards,

Mateusz

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ocin33,

Do you want to filter the Firma_ComboBox options based on the current user?

Could you please tell me how you set the Items property of the Firma_ComboBox, is it a Text or Choice column?

I made a simple test for you, please check as below.

I set the Firma_ComboBox Items as below:

If(User().Email="Mateusz...@....pl", ["Option1","Option2"], User().Email="Julita....@....pl", ["Option1"] )

If you do not connect Office365Users to your app, please refer to the Label.Text to determine user mail address.

If(Label1.Text="Mateusz...@....pl", ["Option1","Option2"], Label1.Text="Julita....@....pl", ["Option1"] )

Was this reply helpful? Yes No
ocin33 104 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @v-qiaqi-msft

I will try it and it will probably work but it is hard to put all users into this formula. The example contains 3 different emails but I need to put there another ones - c.a. 15 different users. Is it possible to solve this issue some other way round with the usage of supprotive sharepoint list or something?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ocin33,

The answer is No.

If you want to assign different users with different options, it should write if statement to match all the users, there is no direct supportive way to achieve your need.

Was this reply helpful? Yes No
ocin33 104 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @v-qiaqi-msft
OK, thanks. Can you tell me how many conditions I can use in the formula? (how many IFs)?

Regards,
Mateusz

Was this reply helpful? Yes No