Answered

How to auto-populate additional Lookup column in Power Apps custom form

(1) Share

Report

Posted on by CU26051711-0

I have a Microsoft List ("Test List") with a Lookup column ("Test Lookup: Business Unit Code") pointing to another list ("RegistryforLists").

The additional lookup column ("Test Lookup: Business Unit") does not appear in the New/Edit form. I want it to auto-populate instantly when selecting a Business Unit Code.

Main List: Test List
Reference List: RegistryforLists
Lookup column: TestLookup
Additional lookup column: Test_x0020_Lookup_x003a__x0020_B
RegistryforLists columns: Title (BU Code), 'Business Unit' (BU Name)
DataCardValue5 = Combo Box for Business Unit Code
Items property: Choices([@'Test List'].'TestLookup')

How can I make the Business Unit auto-populate dynamically when the user selects a Business Unit Code?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CU26051711-0,

In a customized Power Apps form, the additional lookup column will not usually appear as an editable field because it is a derived SharePoint lookup value.
To show the Business Unit instantly when the user selects a Business Unit Code, add RegistryforLists as a data source and use a Label or disabled Text Input with this Text property:

If( IsBlank(DataCardValue5.Selected), Blank(), LookUp( RegistryforLists, Title = DataCardValue5.Selected.Value, 'Business Unit' ) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
SpongYe Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my blog [@S pongYe] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU26051711-0,

Firstly @SpongYe may be correct although I am possibly seeing a different question on your post.

You refer to a "second" Lookup column Test_x0020_Lookup_x003a__x0020_B (actually 'Test Lookup; B') which I assume is pointing at the Title field (renamed to 'Business Code' - not a good practice) in RegistryforLists with the additional field of 'Business Unit', also in 'Business Code'.

You have given the Items of the Combo Box as Choices([@'Test List'].'TestLookup'), which refers to the first Lookup column, but nothing about how this is related to Test Lookup; B' - or am I not interpreting this correctly ?

So if you can post a screenshot of the field settings of both lookup columns, this should be easily resolved (if not already).

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
CU26051711-0 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your kind and prompt responses!

The solution works in Power Apps, however I cannot incorporate it into Microsoft Lists, since it is not supported by Microsoft Lists.

Again, thank you for your kind and prompt responses!

Was this reply helpful? Yes No