Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Is there a way to use a lookup to retrieve not only text data?


Please, help me with the following:

There are 2 tables: Risk Table and Plan Table.


Risk Table has Risk Name (text data type) column and Risk Level column (I am struggling to come up with a solution for this column because basically it must be either text in red, yellow and green colours or an icon in the same set of colours).

and then....

Plan Table must let a user to choose Risk Name (as a lookup to Risk table), while Risk Level appears based on their connection in a Risk Table. How can it be done?


Thank you a lot in advance!

Super User
Super User

Hello @ArisTale 


You can show the difference in Views. Please find my video for your reference.


Please mark as Answer if it is helpful and provide Kudos



Blog :

Super User
Super User

Hi @ArisTale ,


Please see below article to show custom icon dynamically based on field value.


Also, to auto populate Risk level from Risk table in Plan table you can use javascript CRM.webapi client api.




Hi Bipin,


I am not familiar with Javascript. Can you elaborate on "javascript CRM.webapi client api", please?!




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (2,882)