Unanswered

Set default to current user for people picker on power apps (Dataverse is underlying table)

(1) Share

Report

Posted on by ChuckWells

I am building an app built on Dataverse tables. When navigating to a new form, I would like to set the default for a people picker field (entitled 'Associate') to the current user. I have attempted to use the formula that works with SharePoint as a data source, but it does not work here, so I assume that there is different language used with Dataverse as a data source.

The function that I used is as follows (screen shot also attached):

If(Parent.Mode= FormMode.New,{
 Claims: Concatenate(
 "i:0#.f|membership|",
 User().Email // Person email
 ),
 Department: "",
 DisplayName: User().FullName,
 Email: User().Email, // Person email
 JobTitle: "",
 Picture: ""
},ThisItem.Associate

Categories:

Building Power Apps

TimeEntryForm.jpg

Screenshot of Ini...

I have the same question (0)

All responses (5)

Answers (0)

Community Power Pla... on at

Like (1)

Report
Hi @ChuckWells ,

Here you go -
In my case, it is combobox, so on its 'DefaulSelectedItems' property, I've used this formula and it worked as expected 🙂
If( Form1.Mode = FormMode.New, { Claims: "i:0#.f|membership|" & User().Email, DisplayName: User().FullName }, Parent.Default )

Let me know if this helps and of it is, then accept this as a solution.
Thanks 😀

Was this reply helpful? Yes No
ChuckWells 4 on at

Like (1)

Report

@Anonymous Thank you very much at your attempt to help!
I attempted your code in both the DefaultSelectedItems property of the DataCardValue (attempt one) and the Default Property of the DataCard (attempt two). Neither attempt worked.

Attempt one: (DefaultSelectedItems property of the DataCardValue)
if(
frmTimeTracker.Mode = FormMode.New,
{
Claims: "i:0#.f|membership|" & User().Email,
DisplayName: User().FullName
},
Parent.Default
)

Attempt two: (Default Property of the DataCard)
if(
frmTimeTracker.Mode = FormMode.New,
{
Claims: "i:0#.f|membership|" & User().Email,
DisplayName: User().FullName
},
ThisItem.Associate
)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @ChuckWells

1. What is the items property of that combobox/dropdown?
2. Are you using office365 connector to display all users from Azure AD.

Try to put Office365User.SearchUser() in items property and I guess it should work 🙂
Let me know.
Thanks 😀

Was this reply helpful? Yes No
RobBallantyne 17 on at

Like (1)

Report

Did you ever figure out a solution to this issue? I'm losing my mind here. I'm about to just add a checkbox to have the option to edit user and then create a flow that writes 'created_by' to the 'user' field if user is left blank. But that seems like a silly work around.

Was this reply helpful? Yes No
Suggested answer

RobBallantyne 17 on at

Like (2)

Report

I just figured it out... Use the canvas LookUp() and User() functions to figure out the dataverse user object.

Here is my implementation:

If(Form1.Mode = FormMode.New, LookUp(Users, User().Email = 'Primary Email'), ThisItem.User)

I used this formula in the DefaultSelectedItems property on the data card value. Users is the dataverse table I am looking up.

Was this reply helpful? Yes No