Need help to auto populate a text field based on value in a lookup drop down field

(0) Share

Report

Posted on by vastestuser

Hi Friends,

I need help with something I am struggling with. Please find the images below

Screenshot 1 (Primary SP list that PowerApps Submits value to):
------------------------------------------------------------------------
This screeshot 1 shows that there is a PowerApps Form field named "IAT1-HiPort(PortfolioFrom)". This submits the value to the main list named "Cash Instructions Request Internal Transfer"

This field however, is a drop down field that is actually looking up another column titled "Name" from a secondary SP list called "CashTransfer-PortfolioMaster"

Screenshot 2 :
-------------------

The below screenshot (the highlighted column) is the "Name" field that the IAT1 field is looking up to.

The requirement here, is have another powerapp field (Which is a text field) to auto populate with the value in the second column from screenshot 2, based on whatever value has been selected in the highlighted column in screenshot2.

Any suggestions please?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

developerAJ 4,763 on at

Like
a
(1)

Report
Copy link

Link copied!

@vastestuser

use the lookup

LookUp(CashTransfer-PortfolioMaster,HiPortCode=yourdropdown.selected.value).acc_attr

Please click Accept as solution and Thumbs Up. if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Shaheer Ahmad 2,194 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
To auto-populate a text field based on the value selected in a lookup dropdown field in Power Apps, you can use a combination of formulas and properties. Here's a step-by-step guide:
In Power Apps Studio, open the screen containing your form.
Select the text field where you want to auto-populate the value.
Locate the "Default" property of the text field in the right-hand pane.
Set the "Default" property to the following formula:

LookUp('CashTransfer-PortfolioMaster', Name = Dropdown1.Selected.Value).TextValue

In this formula, replace 'CashTransfer-PortfolioMaster' with the name of your secondary SharePoint list. Replace Name with the column name in the secondary list that corresponds to the lookup dropdown values. Replace Dropdown1 with the name of your lookup dropdown control. Replace TextValue with the column name in the secondary list that you want to auto-populate in the text field.
Save your form and test it out. When you select a value from the lookup dropdown field, the text field should automatically populate with the corresponding value from the secondary SharePoint list.
Make sure to adjust the formula and property names based on your specific column names and control names in your application.

Was this reply helpful? Yes No
vastestuser 25 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Shaheer,

You are a genius That worked perfectly. Big fan of your way of explaining things clearly and detailed steps. Thanks so much 🙂 God bless

Was this reply helpful? Yes No
vastestuser 25 on at

Like
a
(1)

Report
Copy link

Link copied!

thanks a ton mate. That helped

Was this reply helpful? Yes No
Shaheer Ahmad 2,194 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

My pleasure

Was this reply helpful? Yes No