Good afternoon,
Here is the context.
I created the following in Dataverse.
TableA have a lookup column called "Program" that is getting the value from the primary field called "Name of program" of TableB.
After this, I created a view in TableA showing all the fields I have in the table, including my Program field. I'm seeing all my records in my view without issues.
I'm now creating a canvas application.
In my screen, I'm creating a gallery that is using the view I created in TableA as a filter.
I'm then adding different labels to show the data of records. Everything is accessible with ThisItem except for my Program field that sends a Scope error.
From there I tried a lot of things I saw online, but nothing is working to show the proper value of my field for the specific item.
The closest I got was with the LookUp function in my label, but I can't properly build it to get the data I need.
Something like LookUp(Table B, 'Name of program" = thisitem.Program, 'Name of program') or some variation give me scope errors, invalid parameters (cant compare text and object) or other errors.
I tried different filters approach like addcolumns, but can't get it to work.
The closest I got had a value in the field, but it was a random Name of program, not the one related to the item
I don't know what to try from there. Help needed.
Thanks in advance.
