Update multiple records in dataverse

[RyanVH]

Hi everyone

I'm very new to power automate and have a question regarding updating records in dataverse.

I have a Employee table and a EmployeeBudgetHistory table. Not to go in to much detail, but each year a trainee gets an amount to spend and at the end of the year we would like to save how much of the budget was spent.

The EmployeeBudgetHistory table has 2 relevant properties. 

1. Remaining Budget
2. Year

I want to update multiple records in the EmployeeBudgetHistory table.

1. Get all Employees
2. Update records in EmployeeBudgetHistory table that is linked with a Employee and where the Year is the current year

Are there any tutorials out there that do something similar?

Would be much appreciated 🙂

Kind regards
Ryan