Auto Populate fields based on Employee Name Selection

(0) Share

Report

Posted on by Prem4253

291

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:

Using Apps Using Formulas

All responses (5)

Answers (0)

the_dude 361 Super User 2024 Season 1 on at

Like (0)

Report

Re: Auto Populate fields based on Employee Name Selection

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.
Prem4253 291 on at

Like (0)

Report

Re: Auto Populate fields based on Employee Name Selection

@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
the_dude 361 Super User 2024 Season 1 on at

Like (0)

Report

Re: Auto Populate fields based on Employee Name Selection

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. ?
Prem4253 291 on at

Like (0)

Report

Re: Auto Populate fields based on Employee Name Selection

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.
the_dude 361 Super User 2024 Season 1 on at

Like (0)

Report

Re: Auto Populate fields based on Employee Name Selection

Hi Prem,

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