如何使用Azure Logic App中的文本值填充Dynamics 365查找? [英] How to populate Dynamics 365 lookups with text value from Azure Logic App?

问题描述

我正在创建一个Azure Logic应用，该应用从外部来源获取数据并填充Dynamics365.

I am creating an Azure Logic app which takes data from an external source and populates Dynamics 365.

在Dynamics 365实体中，我需要填充4个查找字段.但是从外部来源，我正在以文本格式获取数据，这意味着我需要通过文本而不是Guid来搜索查找字段的值.

In the Dynamics 365 entity, I have 4 lookup fields which I need to populate. But from the external source, I am getting data in text format, which means I need to search value for lookup fields by text instead of Guid.

我正在通过创建Azure函数来执行此操作，但想知道是否有可能在没有代码自定义的情况下实现此功能?外部数据源只能发送文本，因为Dynamics 365 guid不与源同步.

I am doing this by creating an Azure function but want to know if there is any possibility to achieve this with no code customisation? External data source can only send text as Dynamics 365 guids are not synced with source.

谢谢

推荐答案

您可以直接使用逻辑应用本身进行搜索.CDS连接器的步骤为获取记录"，您可以在其中过滤查询并根据您的文本条件将其匹配.

You can directly search using your logic app itself. There is an CDS connector step as "get Records", wherein you can filter query and match it based on your text criteria.

可能是您可能获得了1条以上的记录，例如:帐户名:ABC公司在您的客户关系管理中可能会翻倍.

It can be you might get more than 1 record, ex: Account name: ABC company can be double in your crm.

您可能希望缩小范围以获取所需的结果.

you might want to narrow it down to fetch the desired result.

获得记录后，您就可以使用记录了，它会填充您的查阅字段.

Once you get your Record you can use record and it's guid to fill your Lookup Field.

此处是最新的Microsoft Doc，用于在逻辑应用中提取记录

这篇关于如何使用Azure Logic App中的文本值填充Dynamics 365查找?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！