ViewForm Lookup Fields not showing values when Form's Item property is a variable or LookUp()

(0) Share

Report

Posted on by aorphan

160

Hello,

This bug should be very easy for your team to reproduce. When I click on an item in my gallery, I want to set a variable (gblMyItem = ThisItem), navigate to a new screen and display a form in View mode. However, the lookup field values are always blank. It will work when the form's Item property is set to Gallery.Selected, but I cannot use Gallery.Selected because I need other functionality on these screens which will only work with a variable. I have tried with the Form's Item property as both a variable or a LookUp() function call, and neither seems to work consistently. Note sometimes in the PowerApps editor, you will force the lookup fields to load and then it will appear to work, but if you publish the app and play it, you will notice that the lookup fields won't load.

Any advice? Lookups are a huge pain, this is just another chapter of the same story.

EDIT: I am using CDS as my data source.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @aorphan ,

I also have this issue when working with Accounts entity after my test. “Create by” field can’t load. However my custom entity work well, it is really confused.
I would post this issue to my product team. If this issue is solved, I would reply here.

Best regards,
Sik

Was this reply helpful? Yes No
Oscar_Sanchez 4 on at

Like (1)

Report
Copy link

Link copied!

Hi!!! @aorphan
You have to tried with this.
First of all you need to enter to your gallery and you should insert a label, in the property text you will put
ThisItem.(Entity).(Field that you want show)
Later you can hide this label, this control helps you showing the values in the fields of the forms .

I think this is a bug of Microsoft but now this is the best way to fix it.
Best regards
OASG

Was this reply helpful? Yes No
Verified answer

aorphan 160 on at

Like (0)

Report
Copy link

Link copied!
Hi @Oscar_Sanchez ,
Yes, I know what you are talking about. However, it does not work when the form is in View mode, i.e. when I do ViewForm(myForm) (not EditForm(myForm)). The lookup form fields are still unfortunately blank.
EDIT: Thanks for the suggestion! I was able to work around the issue by doing something similar. On the same screen as my form, I created a new Group control and set the Visible property to false. I added the same lookups as labels to the group with the Text property set like so:
gblMyVariable.LookUpEntity.Field
and it forces the lookup form fields to load. Thanks!!

Was this reply helpful? Yes No