Lookup Data Selection Not Being Displayed In PowerApps Before Saving

[y2kardell]

Maybe someone can help me out so I can finally solve this problem. I have two lookup columns - Send to Office Location and Office Address being used in another sharepoint list called Tickets. When I select the location (Atlanta, Charlotte, Columbia..etc) the Office Address is chosen based on the selection. When I save the form - the location and office address shows up in the sharepoint columns labeled Send to Office Location and Office Address just as I want. What I want to happen is for the Office Address to display in the outlined area next to Office Address and I have tried everything I know of but I cant get it to display the address upon selection. The reason I have (Not Visible) is because of this although it is showing in the columns as mentioned in the sharepoint list. I know that its set for view but regardless of what I choose (edit, disabled) nothing happens. Does anyone know what would be preventing it from showing up and can finally help me figure this out? Thanks in advance.

[WarrenBelz]

Hi @y2kardell ,

Please post the code (in Text) you have tried, where you have used it and the result (no data/error details) and also the list and field names of both lists.

[y2kardell]

Hi @WarrenBelz and thanks for your help, this is what the Items function for DataCardValue18 highlighted in the screenshot is set as:

Items = fx Choices([@'Ship Ticket Request Form'].'Office Address (Not Visible)')

Again this is the DataCardValue18 that is associated with the Office Address Lookup column in the PowerApps form shown. The lookup value address is shown when I select the Send to Office Location, when I save it in Sharepoint, I am just trying to get it to display the address in PowerApps onscreen before I save so that the address is visible to the user. If that makes sense.  The SharePoint list that contains the lookup columns being used is called SGH Office Locations List and the two lookup columns are Title and Office Address. The SharePoint Form that they are being used in is called Ship Ticket Request Form.  Please let me know if more information is needed.

Kardell

[WarrenBelz]

Hi @y2kardell ,

I think you need this

LookUp(
   'SGH Office Locations',
   Title = DataCardValue18.Selected.Value
).'Office Address'

but you also need to ask yourself why you are using Lookup columns as they are generally not needed (this blog of mine may be of interest to you) as they will cause you more unwanted and unnecessary grief than this.

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[y2kardell]

Hi @WarrenBelz what column would I need to enter this function? I am using a lookup because based on the resources at my disposal, this is the only option I have due to my employer being skimpy with their budget.

Thanks again,

y2kardell

[WarrenBelz]

Hi @y2kardell ,

It is the Default for the Office Location text box

[y2kardell]

Hi- It doesn't seem to like the .Value portion of the function as it give me a red X for the DataCardValue18.

[WarrenBelz]

@y2kardell ,

But you posted the Items as

 Choices([@'Ship Ticket Request Form'].'Office Address)

so if this is true, the output would be .Value

[y2kardell]

Sorry I made a mistake and posted it in the Items Fx box.

Now that I have posted it in the Default FX box, it doesnt seem to like the 'Office Address' portion of the function.

What I entered was: 

LookUp(

   'SGH Office Locations',

   Title = DataCardValue18.Selected.Value

).'Office Address'

Thanks.

[WarrenBelz]

@y2kardell ,

You just need the name of the column in 'SGH Office Locations' containing the office address - I assumed that was the name from your post.