You’re offline. This is a read only version of the page.
Announcements
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
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.
Share
Report
All responses (
Answers (
