Edit calculated columns with Power FX, freeze problem

(0) Share

Report

Posted on by Gonzalobmc

I have two columns calculated. Calculated Start Date and Calculated end date with formula Power FX.

Four other not calculated columns:

Previus Job: yes/no

Start Date: Date

Time from previus job: (numbers)

Estimated Duration (days): Numbers

One Column is lookup: Previus job.

. So

Calculated End Date:

If(Not('Previus Job?'), 'Start Date (Forecast)',DateAdd('Previus Job'.'Calculated End Date','Time from previus Job (days)'))

Calculated End Date:

DateAdd(Calculated Star Date','Estimated Duration (days)')

As you see, I need to edit one calculated colums. The problem is when I try to edit the formula, always is saving, and never finished. Just show saving, but never finish.

Please help me.

Thanks in advance

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Gonzalobmc,

Looking at your formulas, it's normal (by design) why it never loads because there's no end condition. The calculation is always based on a calculated field of related lookup where that related lookup's calculated field is dependent on a calculated field of a related lookup and so on. Plus, if a Previous Job down the chain has a lookup to a same job (up the chain), you'll have an infinite loop. Hope this makes some sense... The formula can reference lookups and other calculated columns but it cannot be the same calculated columns. You need to physical store the end date (perhaps with a business rule at the entity level) and then reference stored end date when using the Previous Job.
Hope this helps!

Was this reply helpful? Yes No
Gonzalobmc 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you @Eric, the problem with the Business Rule is when It just change in line line, not al dependent nexts Jobs. What I want to create Is something like project. You have Task 1, task 2 and task 3, we just put the start date from the firs one, and the duration for task2 and task3. Is the logic. I have try with bussines rule and workflow, but just adjust the same task I Edit. I need to use calculated column in order to automatic adjust all dependant start date.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Gonzalobmc,

The best and simplest way IMO is with a Power Automate flow. It will not be achievable with calculated, business rules and workflows. Have a flow that triggers when a new task is created, edited (start and end date) or deleted. Then retrieve all the active tasks related to the project of the task that caused the trigger and calculate the duration. Save that calculated duration on the project record.

Hope this helps!

Was this reply helpful? Yes No