Setting Dropdown input field Default Value to Logged User Name

(0) Share

Report

Posted on by pperrot1

Hello,
I have a couple of dropdown inputs that serve as inputs to a gallery based on a Sharepoint list (Projects List). Once selected, the ˜project details˜ Edit Form opens for editing on a side gallery.

The project list has a ˜Responsible Person˜ column filled with a user assigned to each project.

One of my filtering dropdowns is based on that ˜Responsible Person˜ column. The Items formula to the dropdown is: Sort(Distinct(Projects List,'Responsible Person'.DisplayName),Result,Ascending)

I want that dropdown input to default to the logged User's name on start (so that the user can go straight to his assigned projects), but I also want them to be able to select other team members' names and be able to edit their projects in case they are on vacation, etc. How do I set that default value? Also.. .DisplayName doesn't seem to be a function that the Dropdown input understands.
Please help!

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
In the dropdown box's Default property, you can use this formula, assuming the display name in your source is their O365 username.
Office365Users.MyProfileV2().mailNickname
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
Verified answer

pperrot1 81 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, it worked!
I just had to tweak the formula to:

Office365Users.MyProfileV2().displayName

Thank you very much!!!