Hi,

I hope you guys are not tired solving someone’s problem.

I currently have SP list and manage to use CALCULATED Column with other columns.
This is my formula for that calculated column.
=IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+30),” “)

But my problem is that it wont be called in POWER AUTOMATE Filter Query.
Now I hope you can help turn this into Power Automate.

I have 3 columns, No. of Months will Pay (number), First Payment (date), Second Payment(date)

I tried it using init variable and update items, but it wont work.

How can I able to formulate it? Its like First Payment * No of Months to Pay = Second Payment

Thank you.

​Hi, I hope you guys are not tired solving someone’s problem.I currently have SP list and manage to use CALCULATED Column with other columns.This is my formula for that calculated column.=IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+30),” “) But my problem is that it wont be called in POWER AUTOMATE Filter Query.Now I hope you can help turn this into Power Automate.I have 3 columns, No. of Months will Pay (number), First Payment (date), Second Payment(date) I tried it using init variable and update items, but it wont work. How can I able to formulate it? Its like First Payment * No of Months to Pay = Second Payment Thank you.    Read More

​