how to auto pick the title and dept when input the person name??

(0) Share

Report

Posted on by bbsin

1,994

How to set to auto pick the user title and department when the name box is enter??

Designation and department are both singletext line

Thanks

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

@zmansuri

Hi Can I check the name is not working.. it's a Person Group field
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Concat(ThisItem.AssignTo.DisplayName,DisplayName)
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri

There's error, what is wrong on my end? THx
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin，

Do you want to display the corresponding JobTitle and Department to the person name?

Could you please share a bit more about the scenario?

Actually, the PersonName is a Person column, so you should refer to PersonName if you want to display the corresponding JobTitle and Department.

Set the Text property of the Label corresponding to the Designation and Department column as below:

ThisItem.PersonName.JobTitle
ThisItem.PersonName.Department
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

Yes I have a persongroup for Name1 but why is the form item for title a choices when I add the datacard from SP?

Do I put inside the Items -as Thisitem.Datacard1.JobTitle? it has error
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbsin,

Could you please clarify more clearly that you have a Form rather than a Gallery?

In addition, could you please check our official doc to learn more about the form generated based on the SharePoint list, then you should know that a Combo Box will be automatically generated based on a Choice or Person.

Why you change your column type, I could not afford to provide different solutions every time you changed your column type.

Please do keep your Text type for Designation and Department column, and keep the Person type for your person name column. And then create a form based on the SP list, you could get a form with a Combo Box for the Person Name and two TextInputs for the Designation and Department.

Just set the Default property pf the TextInput as below:

ComboBox1.Selected.JobTitle ComboBox1.Selected.Department

Note that Combo Box represents the control within your form, replace it with yours.
bbsin 1,994 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

Thank you, sorry I changed the field as I am not sure which will work. 🙂