Forum Discussion
Automatically grab previous year value from another row within same Sharepoint List
Hi, What I want to do is, within the same Sharepoint List, have each row show the value from the previous year, if available, if not available then to leave the cell blank. This is how my dat...
Craig1S yes this can be done with a flow. In my SharePoint list the Year column is a number column.
Get the last year with a compose using the expression add(outputs('Get_item')?['body/Year'],-1)
Add a filter query to the SharePoint get items usinf Title eq '{Title}' and Year eq '{Outputs of the LastYear compose}'
The get items will only bring back 1 item but you still need the apply to each and for the new row you've just created, update it with value selected from the get items section of the dynamic content box.
Rob
Los Gallardos
Microsoft Power Automate Community Super User