Get first row or single record column values from a List Row action without Loop in Power Automate using Dataverse
Problem Statement
When you retrieve a record from Dataverse or any data source by using filter condition using List Rows, it returns the matching records from the table which you can use loop for further action steps in Power Automate.
But sometimes when you have no primary key value with you and you want to read a record using other filters, you use List Rows which only contain one record. But as because its a List Rows Step, its because of its nature, creates a loop when you are using any value from the list row record.
So unnecessarily, an Apply to each step automatically added to your flow as given in below screenshot.
In the below example we are retrieving a contact record where mobile number is 12345678. So we are expecting a single record in the List Row result as mobile number is unique for each contact row. if you want to read email id from the record returned from the List Result it creates a Apply to each loop as given below.
So for this scenario, no need to use Loop. To avoid Loop use below solution.
Solution
Use Expression given below inside compose.
first(outputs(‘List_rows’)?[‘body/value’])?[’emailaddress1′]
Now if you run you will get the value but with out loop. Logic is we are getting first row from the list row result and then reading column value using expression.
The result is given below.
Hope it helps
Don’t miss the chance to participate in the upcoming Internship Program which will be done using Microsoft Dot Net Web Development Full Stack Technology. The new batch will be starting from May 20, 2024. We will have most experienced trainers for you to successfully complete the internship with live project experience.
Why to choose Our Internship Program?
Industry-Relevant Projects
Tailored Assignments: We offer projects that align with your academic background and career aspirations.
Real-World Challenges: Tackle industry-specific problems and contribute to meaningful projects that make a difference.
Professional Mentorship
Guidance from Experts: Benefit from one-on-one mentorship from seasoned professionals in your field.
Career Development Workshops: Participate in workshops that focus on resume building, interview skills, and career planning.
Networking Opportunities
Connect with Industry Leaders: Build relationships with professionals and expand your professional network.
Peer Interaction: Collaborate with fellow interns and exchange ideas, fostering a supportive and collaborative environment.
Skill Enhancement
Hands-On Experience: Gain practical skills and learn new technologies through project-based learning.
Soft Skills Development: Enhance communication, teamwork, and problem-solving skills essential for career success.
Free Demo Class Available
