cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Satish-Reddy

Using CDS Alternate Keys in Flow

Submitted by Kudo Kingpin on ‎02-16-2020 08:21 PM

1. Common Data Service Connector is not leveraging CDS capabilities for alternate keys.  Apart from GUID, Get Record action should accept alternate keys as well. It's a very convenient and clean way of pulling a record from CDS.

 

2. The key can be used to update the record as well.  

Status: New
See more ideas labeled with:
6 Comments (6 New)
Comments
crmkeeper
Advocate II
Advocate II
‎02-19-2020 12:33 AM

Would save a lot of API calls! 

Satish-Reddy
Kudo Kingpin
Kudo Kingpin
‎02-19-2020 01:03 AM

True. Thanks @crmkeeper  

 

jasonscript
Regular Visitor
‎08-27-2020 06:53 PM

https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/webapi/retrieve-entity-usin...

 

It should be supported

Mglat
Advocate IV
Advocate IV
‎08-12-2021 06:26 AM

Yes please make something like this possible !!!

 

2021-08-12_15-25-07.png

SimonNie
Advocate II
Advocate II
‎01-19-2022 05:16 AM

In addition that should also work for filling in lookup fields.

Usually you would fill a lookup like "accounts(fa55cd2a-341e-4e46-8cf6-30a0faf37f7e)"

 

But also this should work for: "accounts(accountnumber='12345')"

Mglat
Advocate IV
Advocate IV
‎01-19-2022 05:28 AM

Hi @SimonNie,

for lookup fields it is already possible to use an alternate key. So if you create e.g. an opportunity and want to set the lookup to account, you can use "accounts(accountnumber='12345')" as long as accountnumber is declared as an alternative key.

There might be some extra challenge on lookup fields of type 'customer'. These fields can be a lookup to account or contact. 

(From top of head) the syntax would be "customers_account(accountnumber=1234)"