Unanswered

Formula not working with calculated columns from sharepoint list

(0) Share

Report

Posted on by safiranrd

Good Day!

I am trying to show a SLA date from my sharepoint column "SLA Date" which consist of calculation from my another column "Process Date" (date format) and "SLA days" (number format). I have no problem with showing my process date in my calendar gallery using this formula

Filter('Hiring Process Tracker (Frontliner)','Process Date' = DateAdd(_firstDayInView,ThisItem.Value, TimeUnit.Days), TextInput3.Text=Title,Posisi.Value=Dropdown3.SelectedText.Value||Dropdown3.SelectedText.Value=Blank())
 
But when i want to show the SLA date, the formula is not working and i think it is because the "SLA Date" column is a calculated formula column. Please help what formula should i use for this case, any help is really appreciated thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

SwatiSTW 741 Super User 2025 Season 2 on at

Like (0)

Report

The formula to calculate the SLA date based on the "Process Date" and "SLA days" columns can be written as

Filter(
'Hiring Process Tracker (Frontliner)',
DateAdd('Process Date', 'SLA days', TimeUnit.Days) = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days),
TextInput3.Text = Title,
Posisi.Value = Dropdown3.SelectedText.Value || Dropdown3.SelectedText.Value = Blank()
)

Was this reply helpful? Yes No
Suggested answer

mmbr1606 14,567 Super User 2025 Season 2 on at

Like (0)

Report
hey

calculated columns as well as lookup can be pain in the a... in powerapps and i never use them or suggest to use them.

what u can try is to calculate the date directly in powerapps with something like this:

Filter( 'Hiring Process Tracker (Frontliner)', DateAdd('Process Date', 'SLA days', TimeUnit.Days) = DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days) && TextInput3.Text = Title && (Posisi.Value = Dropdown3.SelectedText.Value || IsBlank(Dropdown3.SelectedText.Value)) )

you might need to tweak it a bit,

if it helped please mark this answer as verified,

thanks

Was this reply helpful? Yes No