web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculated filed Power...
Power Apps
Unanswered

Calculated filed PowerApps

(0) ShareShare
ReportReport
Posted on by

Hello Power Community,

It's my first application with PowerApps and SharePoint and i need some help.

So i create a SharePoint List and a PowerApps application connected to this list, in the list i have a calculated filed [=DATEDIF(Du;Au;"d")].

In PowerApps the column is calcultaed when only i submit the form but i need to calculte it when i chage Dates value.

 

Thank you

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,024 Most Valuable Professional on at

    Calculated fields in SharePoint are set AFTER the record has been saved.  So if you need the value to update while you are making changes inside the PowerApp then you'll need to have the PowerApp make and save the change, instead of relying on a calculated field.

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @ihebc ,

    Could you please share a bit more about your scenario?

    Do you want to calculate the calculated field within your app when you change the Dates value?

     

    If you want to calculate the calculated field within your app when you change the Dates value, I afraid that there is no way to achieve your needs in PowerApps.

    Currently, the Calculated field in SP List would be rendered as Read-Only field in PowerApps app. We could not specify/assign any value for this Calculated field in PowerAps app. The Calculated field would be calculated by SP System after you add a new record or edit an existing record.

     

    As an alternative solution, I think it is not necessary to add a Calculated field in your SP list to store the date value difference, instead, you could consider add a Number value within your SP List, then do the date value difference calculation (using DateDiff function) within your app, then save the result back to the Number field in your SP list.

    On your side, please consider add a Number field, called "DateDifference". Then re-generate a new app based on your SP list. Within the Edit form, set the Default property of the Text Input box within the DateDifference data card to following:

    DateDiff(DuDatePicker.SelectedDate, AuDatePicker.SelectedDate, Days) /* <-- I assume that the Du represents the Start date, Au represents the End date */

    or

    Value(DateDiff(DuDatePicker.SelectedDate, AuDatePicker.SelectedDate, Days))

    Please consider take a try with above alternative solution, then check if the issue is solved.

     

    Best regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard