Look Up Value Based on User Department

(0) Share

Report

Posted on by batvan276

206

Hello All,

I have a SharePoint List called "ListData".

I am trying to create a drop down that will allow a user to select from a column called "Title" - but only the items that belong to their department and the status (Status column) is not equal to Complete will appear.

Once they make the selection it will auto fill the rest of the text inputs. They should then have the ability to edit.

I spent a few hours researching but cant get the Look Up formula leveraging office 365 users connection working.

Here are my columns;

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

batvan276 206 on at

Like
a
(0)

Report
Copy link

Link copied!
I was able to do it with this;

With({userEmail:User().Email}, Filter(ListData, 'Created By'.Email = userEmail && Status.Value = "Completed" ) )

Can someone please point me in the right direction to get it to auto populate the data from SharePoint to the text input?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @batvan276 ,

I made a sample for you.

Filter(LIST281,Status.Value<>"Completed"&&'Department Name'=Office365Users.MyProfileV2().department)

LookUp(LIST281,ID=ComboBox1.Selected.ID)

Best Regards,

Wearsky

Was this reply helpful? Yes No
batvan276 206 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much. I used an = expression SelectedText.value to achieve but this seems much simpler.

Was this reply helpful? Yes No