Auto populate field inside the form

(0) Share

Report

Posted on by ar87

353

Hi,

I am trying to auto-populate a field based on the value user selects in another field inside the same form. I am using two data sources, both SharePoint lists.

First SP list contains information about employees and has a lookup field to the other SP list which contains information about managers.

Manager is the lookup field in the Employees list.

Employees SP list:

Managers SP list:

So, what I am trying to accomplish is to auto populate Service Line field inside the form when a user selects a manager from the dropdown list. Both fields are inside the form.

Btw, I am able to achieve this when using independet fields outside the form, but struggling how to do that when everything has to be done inside the same form.

Ty.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @sdedic ,

Did you already tried adding the formula you used in the Default property of Manager Service Line ?

Was this reply helpful? Yes No
ar87 353 on at

Like (0)

Report

Hi @PriyankaGeethik,

yes, and unfortunatelly it doesn't work. As you can see from the screenshot below it allows me only to select Manager's ID or Value, and not Service Line as it was the case outside the form.

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (1)

Report
Hi @sdedic ,

If not tried already could you please try lookup to get the service line value. Please try the below formula its not prefect for copy paste but you have update the values according to your form values.

Lookup(ManagersSPList, Manager=YourcomoboBox.Selected.Value).ServiceLine

Was this reply helpful? Yes No
ar87 353 on at

Like (1)

Report
Hi @PriyankaGeethik,

I've tried with the LookUp already, in the same maner you explained, but also with no success. It reports 'Expected Record value' error.

Let me know if any other info could help in realizing this.
Thanks!

EDIT:
Hm, not sure why, but when I integrated the LookUp part into If statement, the formula worked!
If(IsBlank(cmbSelectManager.Selected), " ", LookUp(Managers, Manager = cmbSelectManager.Selected.Value).'Service Line')

Thank you once again @PriyankaGeethik!

Was this reply helpful? Yes No
shivasai 2 on at

Like (0)

Report

Hii @sdedic
I tried with if condition also but not working

Was this reply helpful? Yes No