Answered

Bind values from entity list column into a dropdown select in Power Apps Portals

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Experts!

I have a requirement where I need to get the values from an entity list column inside a dropdown select. I need to fetch the values of an entity list column dynamically and display it in dropdown select. I am not able to use the Render lookup as dropdown as I do not want to use entity form. I need to render the dropdown which fetches values from the entity list column using the web template.

Could anyone please suggest me how to achieve this?

Your help is greatly appreciated!

Thank you in advance.

Categories:

Power Apps portals

All responses (3)

Answers (1)

Sort by

Verified answer

oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, you can retrieve data via oData or FetchXML, you can choose the column and render your dropdown your way
there are several articles on how to retrieve data
http://dyn365apps.com/2017/09/14/dynamics-365-portals-liquid-templates-part-3-retrieve-data-using-fetchxml/

give it a try and let us know if you are facing any issues

------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OliverRodrigues ,

Thank you for the reply. As I am from a non coding background could you please help me out how to retrieve a particular column value using odata?
Your help is greatly appreciated!
Thank you
oliver.rodrigues 9,482 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

When using oData, you will be retrieving data generated according to the Entity List configuration
you entity list is always referring to a view in your CDS, so you can add just one attribute there if you want

you can view more info at:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/create-edit-views
https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/entity-lists
https://rajeevpentyala.com/2019/02/17/dynamics-portals-entity-list-integration-using-odata-feed/