Search for a Dataverse ID

Like (0) Share

Report

Posted on 19 Dec 2022 14:49:32 by darren_whb

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

All responses (1)

Answers (1)

Verified answer

Pstork1 66,462 Most Valuable Professional on 19 Dec 2022 at 15:32:46

Like (1)

Report

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.