Creating a DropDown in Power Pages

[omi18]

Hello, 

New to Power Pages. I'm trying to create a dropdown. I tried to create using a list, but it did not work. 

Is there any way we can have the dropdown on the Pawer Pages site? 

Thanks,

Omi

[eugenevanstaden]

Can you confirm that you have table permissions set for this second entity?

[banjokazooie]

i have the same issue where my lookup field works fine with the default of having the magnifying glass and search, however, when i change the metadata to render as dropdown my dropdown shows no values. I've set all permissions to full on both tables.

Any ideas on what else could be causing the blank values in dropdown?

[eugenevanstaden]

just out of interest is this portal using the new or the old data model? 

In terms of table permissions, can you set the lookup entity to global - just to see what loads, if any?

[JasperCA1]

I have one portal using the standard data model. The the ‘render lookup as dropdown’ works fine. But when creating a portal (power page) using the Enhanced data model, the dropdowns now show zero values. 

So unfortunately this is a bug that needs to be addressed asap.

[HaseebAhmed]

Hi, you need to provide append to and append privilege permission in the table permission. 
then it will show the data in the dropdown.

[aishwarya31]

if we Made this changes there it will show only primary column name

[aishwarya31]

how to display other field values instead of primary column

[HaseebAhmed]

Hi @aishwarya31 

I haven't done this before, but as per my understanding, you need to modify your lookup according to your needs. It will then display your desired fields in that lookup. If this doesn't work, you can achieve this functionality by using FetchXML or Liquid templates.

If anything works from the above options, please share the details with all of us.

Please let me know if you need further clarification.

[jyotiatharv]

@shivani91 You might be missing necessary read privilege on table permissions for the lookup table for your webrole... that's why your dropdown is showing null. Check for the table permission.

[abhibihani]

@shivani91 Just check whether you have added Table Permissions for that entity in associated Web role . Read, Append , Append To Global level.