web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

LookUp function

(0) ShareShare
ReportReport
Posted on by 84

Hi Everyone

this is a screenshot of part of my customer table. It shows 4 fields - although only three are key.

There are two tables: Customer and Employee. I have added a dropdown control which looks at the Employee table and the Full Name field. . I would like two things to happen.

When a new customer is created, the user will pick a name from the list (highlighted yellow) and then the relevant information will be pulled in to the two other fields (highlighted with a red cross)

However, I can not get over the first hurdle!

When I add a new record, and choose the relevant data from the dropdown, the record does not save and reverts to (I think) the first option!

I have added the following to the Update property:   DropDown1.Selected.'Full Name'

If you can help in any way to solve this issue.

thank you

 

Lilywhite63_1-1644336383023.png

 

 

 

 

 

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Lilywhite63 

    First, check what is actually being stored in your datasource after you submit the record.  Is there a correct value there?

    Second, is this a Combobox or a dropdown control?  If combobox, what is the DefaultSelectedItems property?  If a dropdown, what is the Default property?

    And finally, what is the Items property of that control?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 70

#2
WarrenBelz Profile Picture

WarrenBelz 64 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 36 Super User 2026 Season 1

Last 30 days Overall leaderboard