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.
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?
Solved! Go to Solution.
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)
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.
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.
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
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?