Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

How to update a row dataverse


I'm building a leave request app: on my LeaveBalance table I have a field for the remaining days the user has left for the current year ([REMAINING_DAYS]). The table also has a field used for recording the days the user did not use when said year ended ([UNUSED_DAYS]). 


Here, I'm trying to build two flows:

1) The first one should update the UNUSED_DAYS field with the REMAINING_DAYS value on the last day of the year.

1) The second one should update the REMAINING_DAYS field, adding a fixed value (22, for example) and the UNUSED_DAYS value set in the previous flow (this flow can be triggered on the first day of the year).

I'm using Power Platform for Teams and Dataverse as a connector. I'm using Recurrence as a trigger, and the next step is Update a Row (Dataverse). Here I already selected the table name and added the row ID. But I don't know how to input the values previously described (and one of them needs a sum operation).

Can anyone help me with the best way to do this? thank you so much


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,558)