Answered

Populate a Text Field Based on User Login

(0) Share

Report

Posted on by seljm1

Hi all,

I am new to Power Apps and am building a canvas app to collect metrics from users using a SharePoint list to store the data. I am trying to auto-populate a text field (titled "Program") based on the user that is logged into the app/Officer365. For example: When the program manager for Program A loads the form, the "Program" text field auto-populates and displays the name of that manager's program.

In a second SharePoint list I have all my programs listed (Program A, Program B, Program C, and Program D) in a text column titled "Programs" and the manager in another person/group column titled "managers" that I am using to reference the program manager for each program.

Any help would be appreciated. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

ali_ruman 20 on at

Like
a
(1)

Report
Copy link

Link copied!

as i understood these programs must have different managers assigned ,
so u can use Lookup to populate your text field based on the current user of the application just use formula
LookUp(ProgramTable,managers.DisplayName=User().FullName).Programs
in your text field

Was this reply helpful? Yes No
seljm1 7 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @ali_ruman!

The formula you provided got me on the right track and helped remove the errors I was receiving. The formula however was not populating the text field. I made one small change and ended up with the following:

LookUp(ProgramTable,'managers'.DisplayName=Officer365Users.MyProfile().DisplayName).Programs

Thanks again for the help.

Was this reply helpful? Yes No