Auto Populate fields based on Employee Name Selection

(0) Share

Report

Posted on by Prem4253

652

Hello,

I'm looking to auto populate 5 fields based on Employee Name Selection.

I have Person field created in SharePoint, which is added to PowerApps form

There are multiple fields into the PowerApps form. Whereas I want to Auto populate below fields when an Employee Name is added.

Country

State

City

Pin Code

Emergency Contact No.

So once the user adds name in the Person field, above fields should get auto populate.

I'm assuming we'll have to create one more SharePoint list adding the above fields.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

the_dude 361 Super User 2024 Season 1 on at

Like (0)

Report

Hi Prem,

Could you elaborate. Where would you like to retrieve this data (Country, State, City, Pincode, Emergency Contact) from?

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

Hi,
If PERSON A name is selected
Country - IN
State - MH
City - PU
Pincode - 12
Emergency Contact - 4566

If PERSON B name is selected
Country - AU
State - GV
City - ME
Pincode - 98
Emergency Contact - 6433

SharePoint list is connected to the PowerApp form. Once the form is submitted store to SharePoint.

Was this reply helpful? Yes No
the_dude 361 Super User 2024 Season 1 on at

Like (0)

Report

Hi Prem,

I understand the premise.
However what I wanted to know is where do you plan on getting the information from.

So when you select 'Person A' in your example. What resource can we query to get 'Country: IN, State: MH' etc. ?

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

@the_dude ,

We should get the information from SharePoint list.
Assuming we'll have to create a backend data to SharePoint of below fields;
Country, State, City, Pincode, Emergency Contact

Was this reply helpful? Yes No
the_dude 361 Super User 2024 Season 1 on at

Like (0)

Report

I feel like we're still communicating passed each other.

So you're saying you have a sharepoint list where you want to input the data (which will be populated automatically in the form)
looking like this:

Person name Country State City Pincode Emergency Cnt

And so you select Person A -> Country/State/City/Pincode/Emergency fields get populated automatically because you are getting the data from another list which looks like this:

Person name Country State City Pincode Emergency Cnt
Person A IN MH PU 12 4566
Person B AU GV ME 98 6433

Which seems like an identical list but already filled out.. then what is the purpose of making the second list? this is why I feel like we're not understanding each other -> this can't be what you mean.

Was this reply helpful? Yes No