Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Formula not working with calculated columns from sharepoint list

(0) ShareShare
ReportReport
Posted on by 48
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!
  • Suggested answer
    mmbr1606 Profile Picture
    mmbr1606 10,429 on at
    Formula not working with calculated columns from sharepoint list
    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
  • Suggested answer
    SwatiSTW Profile Picture
    SwatiSTW 301 on at
    Formula not working with calculated columns from sharepoint list
    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()
    )
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard