Answered

Update a row on dataverse based on Planner

(1) Share

Report

Posted on by FGRODRIGUEZ

129

So, in my organization we have a planner with assigned tasks, I have an automation that when ever a task is created it will make a new row on a dataverse table, I want to run a secondary automate that every few hours will scrub the planner and update the rows on dataverse based on the current status of the tasks.

My issue is that the update row function for dataverse requires the GUID of the row, is there a way to have it look up that information based on the task ID (that is also unique) or how would I go about having to update each row with the new information?

All responses (7)

Answers (1)

Vaishakraju 6 on at

Like (0)

Report

Update a row on dataverse based on Planner

i am trying to create a the same flow when- Task is created in Planner a row needs to be added in Dataverse table and vice versa. But i am always getting error when i run the flow.

the next step would be - update of task row in planner when there is modification in Dataverse table and vice versa.
Could you help me on this?
FGRODRIGUEZ 129 on at

Like (1)

Report

Re: Update a row on dataverse based on Planner

Thank you very much for the help! With the guidance I was able to solve it, and It's now working as intended!
Verified answer

abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Update a row on dataverse based on Planner

Hi

You still got the filter query wrong. Please see below

See above I am looking for identifier by searching the text and you can see Account (GUID) displayed under the dynamic content.
FGRODRIGUEZ 129 on at

Like (0)

Report

Re: Update a row on dataverse based on Planner

Hey, again thank you very much for the help, but I must be doing something wrong, I don't get options to use dataverse dynamic content, could you maybe share a screenshot of what the flow would look like to get a better idea? Thank you
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Update a row on dataverse based on Planner

Hi @FGRODRIGUEZ

Apologies there is mistake in my query. You need to set that under Filter Rows. You need to find your column name (TaskId) eq Dynamic Task Id mapping.

eg: TaskId eq 'mapping of TaskId'

To find the GUID you need to look for identifier under the List Rows Dynamic values.

Thanks
FGRODRIGUEZ 129 on at

Like (0)

Report

Re: Update a row on dataverse based on Planner

Hey, first of all, thank you for writing an answer, but I seem to be having a problem when implementing it.

The issue is that when I go to the update row, there's no dynamic content for the Dataverse identifier, the apply each that you see at the beginning was applied automaticly by PowerApps when selecting planner TaskId as a dynamic content.
abm abm 32,506 Most Valuable Professional on at

Like (0)

Report

Re: Update a row on dataverse based on Planner

Hi @FGRODRIGUEZ

Like you mentioned for the update you need the GUID (Row Id). This is what you need to do.

1. When you create the record store the Task Id. Look like you already go that info.

2. Use the List rows filter query using the task id to get the GUID of the record which you want to update.

Above under the Filter query I have hardcoded the value. Here replace the dynamic task id.

Thanks