Forum Discussion
Get Max date from a group of items in a sharepoint list and store it in another calculated column
Hello! I have a SharePoint list that contains multiple Employee Names in one column and various due dates in another column and I need to get the MAX date for each unique Employee Name and add this to a new column in the same SharePoint list. I've added my data set below and also the desired output. I'm not able to figure out the formula for this! Any help greatly appreciated!
Current State:
| Name | End Date |
| Bob Smith | 11/29/2022 |
| Bob Smith | 2/11/2023 |
| Jack Ryan | 3/4/2023 |
| Jane Doe | 12/17/2022 |
| Jack Ryan | 1/28/2023 |
| Shane Smith | 1/11/2023 |
End Result:
| Name | End Date | Next Available Date |
| Bob Smith | 11/29/2022 | 2/11/2023 |
| Bob Smith | 2/11/2023 | 2/11/2023 |
| Jack Ryan | 3/4/2023 | 3/4/2023 |
| Jane Doe | 12/17/2022 | 12/17/2022 |
| Jack Ryan | 1/28/2023 | 3/4/2023 |
| Shane Smith | 1/11/2023 | 1/11/2023 |
1 Reply
Jairacha you can't do this with a formula in a calculated column because it can't look at other items. You'd need to build something in a flow in Power Automate.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
