web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Form field autopopulat...

Power Apps

Answered

Form field autopopulated when value from DropDown changes

(0) Share

Report

Report

Posted on by LTEVA

27

Hello community,

Your expertise here as I’m facing wall.

Case:

I have an SP list (SP1 for simplicity) which is reflected as form in my app.
This SP1 has a lookup column on another SP2 list and what I lookup in SP1 list is Col1 from SP2 list
In the power app Form , Col1 is a dropdown and what I need is when I change a value in the DD to automatically populate Col2 and Col3 on related form fields (which are reflected as simple text fields in my SP1 list)

I did many attempts but with no result (I’m missing the correct Lookup syntax I guess).

Many thanks in advance to all.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

rikdekoning 281 on at

Like
a
(0)

Report
Copy link

Link copied!
The correct syntax for a Lookup field is:
{ '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: <ID>, Value: <VALUE> }
Where ID is the list item ID of your lookup item, which is an integer format and VALUE is the name of the lookup item (mostly the Title field, except if you configured another field), which is a string format and needs to be wrapped around quotes.

You can set the Default property of the Col2 and Col3 fields to match something selected in the Col1 field

Join the conversation