Answered

Auto-Populate fields based on other field value entered

(0) Share

Report

Posted on by Jean_9681

135

Auto-Populate fields based on other field value entered - I have a field called Requestor (its a people group column)
and i am trying auto populate the Department based on the Requestor field value.

I tried this fx - Office365Users.UserProfile(DataCardValue12.Selected.DisplayName).Department
and it does not look good, i see a Red x next to Department.

DataCardValue12 is from the Requestor field

Help me with the correct fx/formula to get this working.

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Hi @Jean_9681 ,

The input parameter is wrong.

User principal name= User Id ≠DisplayName

Please try this formula:

Office365Users.UserProfile(DataCardValue12.Selected.Email).Department

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
Hi @Jean_9681 ,

Try

First(Office365Users.SearchUser({searchTerm:DataCardValue12.Selected.DisplayName})).Department

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Jean_9681 135 on at

Like (0)

Report

Thank you so much for taking the time to help me, the formula you suggested did not work however it did remove the red x but the autofill did not work.

Was this reply helpful? Yes No
Jean_9681 135 on at

Like (0)

Report

@WarrenBelz Thank you it worked as expected.
First(Office365Users.SearchUser({searchTerm:DataCardValue12.Selected.DisplayName})).Department

Was this reply helpful? Yes No