Lookup field configuration in Power pages

(1) Share

Report

Posted on by SriHarish

Hi,

I am using a form from a Dataverse table in one of the pages in my site.

The form has a lookup field (a lookup view is used for this field), and I am able to select the value. I can see the primary column value of the selected record in the input box, but I need to show another column value.

Is this possible?

All responses (1)

Answers (0)

Suggested answer

aofosu 101 on at

Like (0)

Report
Lookup field configuration in Power pages

By default, the lookup field will access the default Lookup View of the table you are looking up. This default Lookup View does not allow you to remove the primary column.

To work around this, you can:

Create a public view (e.g., Custom Lookup View) that includes the column you wish to show in the lookup on Power Pages.

In the form configuration, select the Custom Lookup View you created as the view to display for the lookup field.

On Power Pages, if you don't set metadata on the lookup to render it as a dropdown, the Custom Lookup View will be displayed otherwise it will show blank options.

If you just want to show another column beside the primary column in the modal lookup you can simply add the column to the default Lookup View and rearrange the columns as preferred.

This approach allows you to customize the columns shown in the lookup field as needed.

Modal Lookup