cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sam_646
Frequent Visitor

Table LookUp Using URL Param Not Displaying Name

OnStart of my app I have:

 

 

Set(varRecordToView, Value(Param("ShiftLogID")))

 

 

 

I have a label that displays varRecordToView -

Text code is:

 

 

varRecordToView

 

 

 

And I have another label that performs a LookUp on a table to display the CreatorName -

Text code is:

 

 

LookUp('OCH Shift Log - Forms Data', FormReference=varRecordToView, CreatorName)

 

 

 

Screenshot of the table:

sam_646_0-1660643206410.png

 

Screenshot of the app while editing:

sam_646_2-1660643258817.png

 

 

All works well in this view, but when I email the link to "play" the app (passing in &ShiftLogID=1 at the end of the URL) I get this:

sam_646_3-1660643350585.png

 

 

The label at the top correctly displays 1 which is the param that is passed in the URL, but the name box is blank.

 

In edit mode it displays the name correctly using the LookUp but when clicking on the link it only correctly displays the number in the top field but not the name which should be "Test Name"

1 ACCEPTED SOLUTION

Accepted Solutions
sam_646
Frequent Visitor

Issue solved, user never had permission to the enviroment

View solution in original post

1 REPLY 1
sam_646
Frequent Visitor

Issue solved, user never had permission to the enviroment

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,098)