I am trying to add a calculated field to a list that takes another field (which allows multi values) and picks up the next date.

See Below - Meeting ID is a lookup from another list and is populated via Power Automate. I would like to populate the Next Meeting column with the next date (equal to or after today) so row 1 it would be Feb 24, for row 2 it would be Nov 23.

enter image description here

Any ideas of a formula that would handle this?

1 Answer 1


Unfortunately, this is not possible using SharePoint calculated column formulas.

SharePoint calculated column formulas does not support fetching values from:

  • Lookup column - single selection
  • Lookup column - multiple selection
  • Choice column - multiple selection
  • Person or Group column, etc.

So, you may need to do your calculations in Power automate flow and update column values when you populate Meeting ID from another list via Power Automate.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.