Forum Discussion

Rowell2022's avatar
Rowell2022
Copper Contributor
Jul 16, 2024

Add days to Calculated Columns base on Number of Months

Hi, Please help me with this calculated formula. I am currently creating a sharepoint list for payment monitoring. I have columns: Months to Pay (number), First Payment(date), Second Payment(d...
SharePoint Online
Rowell2022's avatar
Rowell2022
Copper Contributor
Jul 19, 2024
You've helped me a lot, Thank you, Expicornovus!
  • Rowell2022's avatar
    Rowell2022
    Copper Contributor
    Jul 22, 2024
    Hi Expiscornovus,

    Will you be able to turn this formula to power automate? My problem is that CALCULATED COLUMNS cannot be call in power automate.
    =IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+60)," ")

    Big thank you.
    • Expiscornovus's avatar
      Expiscornovus
      Iron Contributor
      Jul 22, 2024

      Rowell2022 yes, sure.

       

      That would be something like:

      if(greaterOrEquals(item()['MonthstoPay'], 3), addDays(item()['FirstPayment'], 60), '')

Resources