cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vaishalivyas1
Level: Powered On

New Lookup support mention in spring update is not working

Hi,

 

I am trying to add Lookup field (account) on contact form. I know that previously this was not supported but now it is mention in spring update that it can be done.

If It can be done, how can I use this?

 

 Screenshot of where it is mention:

lookup support.png

 

 

 

5 REPLIES 5
Super User
Super User

Re: New Lookup support mention in spring update is not working

Hi @vaishalivyas1

 

The spring update provides support for SQL Views. In your case, this would enable you to build a SQL Server view that joins your Contact and Account tables. The benefit of this is that it allows you to display Contact and account details in a gallery (or other list control) without the performance overhead of carrying out the account detail lookup for each record from within PowerApps.

For data entry purposes, it's possible to build screens with lookup fields. For instance, if you want to add a drop down control to a contract entry screen that enables a user to select an account, the answer in my post here might help you.

https://powerusers.microsoft.com/t5/Creating-Apps/Drop-Down-Box-Lookup/m-p/82049#M827

vaishalivyas1
Level: Powered On

Re: New Lookup support mention in spring update is not working

Hi @timl

 

Can you provide Screenshorts,or any Example or document related to this or how can I use this new feature.

Super User
Super User

Re: New Lookup support mention in spring update is not working

This article on the PowerApps blog describes how to use this feature.

 

https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/

vaishalivyas1
Level: Powered On

Re: New Lookup support mention in spring update is not working

Hi @timl

 

we don't have access to the SQL Server. I am trying to create an app with CDS Connection.and same scenario for Dynamics 365 connection.

 

 

Super User
Super User

Re: New Lookup support mention in spring update is not working

Can you explain what exactly doesn't work?

 

There is now a new version of CDS which might be the cause of the problem, but the CDS has always supported lookups.

 

The following link describes...

>> If you create an app automatically from an entity that contains a lookup field, it appears as a Drop down control that contains data from the Primary name field of the entity.

 

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-entity-lookup

 

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,296)