How to update/set lookup fields using Power Automate Flow

-

 By using Trigger outputs

if(

    empty(triggerOutputs()?['body/_apy_lookuprid_value']),

    '',

    concat(

        'apy_lookupfieldname(',

        triggerOutputs()?['body/_apy_lookupid_value'],

        ')'

    )

)


By Using Loop/ApplyToEach 

if(

    empty(items('Apply_to_each')?['_apy_lookupid_value']),

    '',

    concat(

        'apy_lookupfieldname(',

        items('Apply_to_each')?['_apy_lookupid_value'],

        ')'

    )

)

Comments

Post a Comment

Popular posts from this blog

Basic Plugin Code in D365 using C#

-
 using System; using Microsoft.Xrm.Sdk; using Microsoft.Xrm.Sdk.Query; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.Xrm.Sdk.Messages; using Microsoft.Xrm.Sdk.Metadata; namespace  apy.CWA.Arcese.Security {     public class PostOperationCreateQuote : IPlugin     {         public void Execute(IServiceProvider serviceProvider)         {             ITracingService tracingService = (ITracingService)serviceProvider.GetService(typeof(ITracingService));             IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));             IOrganizationServiceFactory serviceFactory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));             IOrganizationService service = serviceFactory.CreateOrganizationService(context.UserId);             Entity entity = null;             try             {                 if (context.I
Read more

CURD (Create, Update, Retrieve and Delete) Operation in D365 using Power Shell Script

-
Connect D365 using below details: Install-Module Microsoft.Xrm.Data.PowerShell -Scope CurrentUser Set-ExecutionPolicy –ExecutionPolicy RemoteSigned –Scope CurrentUser [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls12 $Username ="APY***@Trailcrm.com" $Password ="apy****" $pwd = ConvertTo-SecureString $Password -AsPlainText -Force  $credentials = New-Object System.Management.Automation.PSCredential($Username, $pwd) $conn = Connect-CrmOnline -Credential $credentials -ServerUrl "https://apytrailcrm****.crm.dynamics.com/" -ForceOAuth Create a record using powershell Syntax:     New-CrmRecord [-conn <CrmServiceClient>] [-EntityLogicalName] <String> [-Fields] <Hashtable> [<CommonParameters>] Ex:      $parentId = New-CrmRecord account @{"name"="parent account name"}     $parentReference = New-CrmEntityReference -EntityLogicalName account -Id $parentId     New-CrmRecord -conn
Read more

Meta Data Using WebApiRequest

-
////////////////Query Entity Metadata along with all attributes///////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/EntityDefinitions(LogicalName='contact')/Attributes", false); /////////////////Entity Object Type code///////////////////////  req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.0/EntityDefinitions?$filter=LogicalName eq '" + entityLogicalName + "'&$select=ObjectTypeCode", false); ////////////////////////////////////Querying single Field Metadata///////////////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/EntityDefinitions(LogicalName='contact')/Attributes(LogicalName='firstname')", false); /////////////////Querying Relationships/////////////////// var url = req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/RelationshipDefinitions(SchemaName
Read more