Skip to main content

Notifications

Community site session details

Community site session details

Session Id : r7pVK2kpqSBL5aEKCl+z1s
Power Automate - Building Flows
Answered

Search for a Dataverse ID

Like (0) ShareShare
ReportReport
Posted on 19 Dec 2022 14:49:32 by 6

Hi, I wonder if someone can help.

 

I'm in the middle of finishing a flow and I'm a but stuck.  Once a Planner task is completed I need to get it to update the related row in Dataverse.

 

The title of the planner task has the Request ID in it e.g. HTL-1010 (which is also the autonumber I have generated in Dataverse against each row).

 

So when the task is complete I need to search the Dataverse table in the Request ID column so that I can get the row ID to then update the Dataverse row with information e.g. write "Complete" in the status column.

 

I've tried searching on here and elsewhere online but I'm drawing a blank at the moment.  Hopefully someone can help

 

Many Thanks,

Darren

  • Verified answer
    Pstork1 Profile Picture
    66,462 Most Valuable Professional on 19 Dec 2022 at 15:32:46
    Re: Search for a Dataverse ID

    You should be able to use either the Search Rows or List Rows actions to do that.  For List Rows you would add an Odata filter where you filter on the Request ID column and the value from the planner Title. When you do that you'll end up with one record in an array.  So you can then use First(ListRowsArray)?['rowed'] to access the row id of the first matching record.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 288 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 245 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 212

Overall leaderboard
Loading started