Answered

Intake Form Lookup Column not showing

(0) Share

Report

Posted on by gogoinggone

Hello,

I have created a simple Intake Form for Data entry and storing the data into a dataverse table Called "Intake Request". The issue is I have to use 2 lookup columns 1) Request Category and 2) Request Sub Category. They both are lookup columns coming from a different Dataverse table. The Request Sub Category will populate based on the Request Category which I was able to achieve.

The issue

1) whenever I try to view the form from the gallery after submitting it. The Request Sub Category field does not populate It is showing as a blank field. PLUS in the back end. Both Request Category and SubCategory Columns are stored as ID instead of the name.

2) When I am trying to create a gallery both my Request Category and Sub Category columns are not showing any information which is very important.

Does anyone know why?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

AhmedSalih 6,680 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@gogoinggone , The reason that they are showing numbers, is your Lookup Columns link to a Dataverse Table where you have your Primary Name Column as a number. Lookup Columns in Dataverse Table Editor will show the Primary Name Column VALUE of the table that they are relating to.

Check this Example:

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

Was this reply helpful? Yes No
Verified answer

AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@gogoinggone
For this Issue:

'Request Category' is a lookup column to another table : You should write the formula this way:
ThisItem.'Request Category'.CategoryName
NOTE: Change (CategoryName) with whatever column you want to show from the Parent table

Regards,
Ahmed
If my reply helped you, please give a 👍. And if it has solved your issue, please consider Accepting it as the Solution to help other members of the community find it more.

Was this reply helpful? Yes No
gogoinggone 19 on at

Like
a
(0)

Report
Copy link

Link copied!

@AhmedSalih So I tried using the ThisItem.'Oss_Cat'.Request Category but its still not working.
Oss_Cat is where I getting my Categories
Req_Categories is where I am getting my sub Categories related to Categories.
All this information is getting submitted to the 'Oss_Intake Requests' using a form.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@gogoinggone, I don't think you are using the correct table: You should use the lookup column name, not the table, the lookup column in Intake Request table

ThisItem.TheLookupColumn.Request Category

Was this reply helpful? Yes No
gogoinggone 19 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked. Thank you!

Was this reply helpful? Yes No