@Ganesh31_K you will need to make sure that you have a column in your table in Excel that has a unique value. So add a column called Row ID, select all the data and format as a table.
Then the flow looks like this:
In the List rows present in a table open the advanced options and make sure you select ISO 8601 as the datetime format. The reason for that is that Excel doesn't store dates as a date but as an integer so we need to make sure the flow considers the DueDate as an actual date.
Add an apply to each and select value from the dynamic content box. Then add 2 Compose actions. For the first one select DueDate from the dynamic content box. For the second one we want to add 1 year to it and format it in the dd MMMM yyyy format you have in your spreadsheet. To do this click inside the Inputs field and in the dynamic content box click the Expression tab and paste in the following expression:
formatDateTime(addToTime(outputs('ComposeDueDate'),1,'Year'),'dd MMMM yyyy')
Finally add an update a row action, again make sure that you click the advanced options link and select ISO 8601 as the date time format. For the Key Column select RowID from the dropdown. For the Key Value select Row ID from the dynamic content box. Leave the Department field empty as you are not changing the data for that. For the DueDate column select the outputs of the Compose above(ComposeAdd1Year).
When the flow runs it will update each row with 1 year added to the DueDate date.
Hope that helps.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
