DropDown - Is NOT displaying the Default Value.

(0) Share

Report

Posted on by campk

Hello All,

Thank you, for taking the time to read this post. I am struggling with the creation of an inventory for my group.

The tool that I created uses a Gallery(list) and a Edit Form, to display my data. This is all working fine. Using Shane Young's (PowerApp) Videos I have the data updating correctly and the form for the most part functional. My issue is that either in a dropdown or label control. That I have set up to reference another table. The default value is getting lost.

Connector (SQL Server)

TBL1 - Assets

TBL2 - Locations

Common Column between the two tables is LocationID.

My LookUp Statement that I have tried to use under Default for the DropDownMenu is:

LookUp('[dbo].[tblLocations]', LocationId=LocationId, FullName) -This formula is only returning the data from the first row in the Locations Table. It is NOT referencing the DataCards LocationID for the Asset that is being selected.

I have been using the references to troubleshoot this issue:

https://www.youtube.com/watch?v=jmh8eeQVAIc - SQL LookUp, this is where I got my formulas for LookUp.
https://www.youtube.com/watch?v=fqH1U0_TanI - Multiple Data Source Video, This is where I got my formulas for setting up the dropdown correctly. Please keep in mind that the update is working as it shows in this video. However, it is the setting of the Default Value that is NOT working.
Formula's - https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Saw an article about(Choices) - https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-choices

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue is that you aren't referencing the control in the datacard on the form. Is the location Id on the form in a text field or drop down field?

Test Example: LookUp('[dbo].[tblLocations]', DataCardValue.Text =LocationId, FullName)

Drop Down Example: LookUp('[dbo].[tblLocations]', DataCardValue.Selected.Value =LocationId, FullName)
campk 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I tried the formulas you provided and they are still not working. To answer your question though. Yes, LocationID is the name on the Forum and it is pointing to the assets table locationid column. What I am trying to do is reference the locationid table back to the asset table so it shows the human readable format of the location id. So far all of my attempts have failed to do this.

Kim
campk 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is a picture of my IF statement, that I am using to pull up the default LocationID for the Asset.
Verified answer

campk 13 on at

Like
a
(0)

Report
Copy link

Link copied!

So I solved this yesterday for the app that I am creating. Basically this all came down to gaining a better understanding of the LookUp formula. I am going to post this as a reference for others, just in case some one has the same issue I did.

My Answer:
If(Form1.Mode = FormMode.Edit, LookUp('[dbo].[tblLocations]', LocationId=ThisItem.LocationId,FullName))

The videos, I linked when I posted were correct. However, the thing I struggled with which did not come across in Shane Youngs videos is the comprehession of the LookUp Formula. Here is my understanding now.

LookUp(Ref.Table, Ref.Column=SelectedColumnData, DisplayAs) = Once I figured out this was how I needed to phrase my argument things worked as they were supposed to.

Hope that this might help others that are learning PowerApps. This is a really great tool!
lcrubberfab 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm having the same issue as discussed in this dialogue from September. I too reference Shane Young's videos many times and they have been extremely helpful. Where I'm running into an issue is when The PowerApp form submits the selected data back to the SharePoint List, the lookup values that were populated in PowerApp do not transfer to the SP list. The Powerapp is working great with the lookup value, but it's the transfer of that data that doesn't show. What formulas/area do I have to focus in on to change the look?