cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft camel
Microsoft

Re: Help populating text box based on value of drop down

So, PowerApps doesn't understand that your Record has Columns. I think you need to change the LookUp formula because it is not retrieving the correct Record

tbrantley
Level: Powered On

Re: Help populating text box based on value of drop down

Can you give me any advice on what to do there?

tbrantley
Level: Powered On

Re: Help populating text box based on value of drop down

@camel

 

I'm getting an error in the look up function...

 

UpdateContext({Info : LookUp('Driver Info',nameDropDown.Selected exactin Name)})

 

It says that name is an invalid argument type. Cannont use text values in this context.

Microsoft camel
Microsoft

Re: Help populating text box based on value of drop down

@tbrantley

nameDropDown.Selected brings an entire Record to you, not just a Text. You need to compare Text with Text. So you need to inspect this Record and identify the Column that you need. It will probably be:

nameDropDown.Selected.Value
tbrantley
Level: Powered On

Re: Help populating text box based on value of drop down

@camel

 

Thanks!

 

I'm still getting invalid name when setting the default value of address and clock.

capture1.PNG

 

Do I need to add a filter to the lookup function so that it will retreive the correct record?

Microsoft camel
Microsoft

Re: Help populating text box based on value of drop down

@tbrantley

I am not sure what are you retrieving from the Selected value from Dropdown. What would I do in this case? I would debug it. Just add on the OnChange property of the Dropdown:

 

UpdateContext({Debug : Dropdown.Selected})

After that, go to the variables of the application (my application is in Portuguese, but the order should be the same). Look for you screen there and then look for the Debug record. Open it and check the columns. Check which one has the value that you want. This value should be compared in the LookUp formula.

Screenshot_3.png

 

tbrantley
Level: Powered On

Re: Help populating text box based on value of drop down

@camel

 

It returns the correct value of the drop down but still nothing from the look up function

 

Capture2.PNG

 

Capture3.PNG

 

 

Microsoft camel
Microsoft

Re: Help populating text box based on value of drop down

'Driver Info' has the Name column?

tbrantley
Level: Powered On

Re: Help populating text box based on value of drop down

@camel

 

Yes

Microsoft camel
Microsoft

Re: Help populating text box based on value of drop down

Is it a Text field or LookUp field?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,770)