In Power automate, while retrieving the related records, sometimes you would like to get only the first record from the result (collection) and hence it gets easier with ‘First’ Expression of power automate. The solution is very simple.
Lets take an example to explain this further . Suppose you are retrieving associated contacts records from an Account and want to only retrieve first record in the array. The quick and easy solution would be to use First expression to get the first record from the collection.
Why Use the first Expression?
The first() function allows you to directly retrieve the first item from an array, reducing complexity and making your power automate flows easier to understand and maintain. Rather than using multiple actions or conditions to access the first element, first() does it efficiently in a single step.
Syntax Overview
The syntax of first expression is shown below:
first(outputs('List_rows')?['body/value'])
Thanks for Reading 🙂
Most Viewed Posts
- How to Integrate Azure Functions with GPT-4 (Azure AI Foundry) for Dynamics 365 Address Cleanup (214)
- Case Study : Automated Token Rotation with Azure Functions and Key Vault, Purging Secrets (98)
- ❌How to Fix the ‘Client Authentication Scheme Anonymous’ Error in Dynamics 365 (74)
- How to Create and Debug Time Trigger Azure Function Locally (51)
- How to Concatenate Account Name Fields in Dynamics 365 with ‘Formula Data Type’ (No Code Needed, No Power Automate, No JS) (47)
Dynamics 365 Senior Consultant with deep expertise in customization, optimization, and integrations. Committed to giving back to the CRM community by breaking down complex concepts, sharing real-world insights, and helping others succeed with Dynamics 365 & Azure.
No responses yet