Skip to main content

Notifications

Community site session details

Community site session details

Session Id : D+7HfFWNTg5rA+KvUErXXn
Power Automate - Building Flows
Answered

Update record on dataverse table based on another table

Like (1) ShareShare
ReportReport
Posted on 15 Nov 2022 14:26:53 by 84

Scenario

 

Two Dataverse table in a solution

 

1. Table with all employee that has worked in department. Every employee has a unique employee ID number

2. Table is a table that is reported Monthly with the employees that are active in the department. They have also employee ID number that should match in table 1.


Goal is to update Table 1 based on table 2.
IF employee ID exist update column with new information, IF employee do not exist in table 1 create a new row.

I have started with this tutorial https://www.youtube.com/watch?v=SFlj1ykpvgM from @abm which compare two arrays.
I new to Power automate and have just used to send email based on condition.
I am surprised that something like this scenario is so difficualt to create.
Here is my flow: this is only takes the employee ID number from the two Table and create integer variable. Skjermbilde 2022-11-17 kl. 14.19.22.png

Skjermbilde 2022-11-17 kl. 14.21.19.png


I have now two variables: Employee ID active and Employee ID All.
Is it supposed to be that hard? and what is my next step?

 

  • FelipePanza Profile Picture
    84 on 24 Nov 2022 at 11:11:52
    Re: Update record on dataverse table based on another table

    @abm how can I update the record in Master list that are not in Monthly report list?

  • FelipePanza Profile Picture
    84 on 18 Nov 2022 at 14:41:39
    Re: Update record on dataverse table based on another table

    @Venkata-Golla Thank you for the tip.

  • FelipePanza Profile Picture
    84 on 18 Nov 2022 at 14:40:37
    Re: Update record on dataverse table based on another table

    Hi, this is more than expected. Thank you very much.
    I had a lot of trouble to recreate this because of a date problem. The monthly report table is a big table with many months, so I filter row in the action List rows with a Trigger Input. The trigger contains a date 01.11.2022. The flow return date as UTC with 31.10.2022. I had to change settings in the table. The Solution was given by @Prakash4691 in https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-time-zone-change/td-p/1372843

    My next challenge is to update choice column in Employee Master Table when creating or update row. This have to contain if statement/expression.

    Example: Add new row

    Field/Column: Level
    Choices: Level 1, Level 2, Level 3
    If Monthly report field "Position" = "Engineer" Set choice in Master Table to "Level 1".

    Any tips on how to achieve this?

  • Venkata Golla Profile Picture
    78 on 17 Nov 2022 at 22:58:05
    Re: Update record on dataverse table based on another table

    Try setting the timeout duration for the action inside the Apply to each control.
    The default timeout is 10 mins.
    Click ... on the Action

    Click on Settings, set the timeout to P1D to run for a max of 1 Day.

    VenkataGolla_0-1668725758500.png

     

  • Verified answer
    abm abm Profile Picture
    32,464 Most Valuable Professional on 17 Nov 2022 at 22:50:21
    Re: Update record on dataverse table based on another table

    Hi @FelipePanza 

     

    I have made a tutorial video based on this.

     

    https://youtu.be/KBXoLco1O7Y

     

    Thanks

  • FelipePanza Profile Picture
    84 on 17 Nov 2022 at 20:18:59
    Re: Update record on dataverse table based on another table

    It is right that when I use Select it create Object?

  • Matt_Dahdouh Profile Picture
    106 on 17 Nov 2022 at 19:47:23
    Re: Update record on dataverse table based on another table

    I have noticed that if a flow times out, it still is running in the background. If you go back and look at your run history, you can see if it is still running or not.

  • FelipePanza Profile Picture
    84 on 17 Nov 2022 at 19:45:37
    Re: Update record on dataverse table based on another table

    Have tried some sort of what you are suggestion. My experience with Apply to each is that it takes a lot of time and often result in timeout (after 10 minutes)

  • Matt_Dahdouh Profile Picture
    106 on 17 Nov 2022 at 19:35:19
    Re: Update record on dataverse table based on another table

    Inside of a Apply to Each, list rows from the table you want it to go to, then use a update row action to update the table you are wanting.

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 17 Nov 2022 at 18:05:38
    Re: Update record on dataverse table based on another table

    Hi @FelipePanza 

     

    Let me have a look at this and get back to you.

     

    Thanks

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Churchy Profile Picture

Churchy 6

#2
Chriddle Profile Picture

Chriddle 4 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 4

Overall leaderboard