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 Field not u...
Power Apps
Answered

Calculated Field not updating in Dataverse table

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Team,

 

I am facing issue while retrieving the data from Parent table via calculated filed, it is coming as blank. don't know how to resolve it.

 

I want to calculate, Hourly Rate = Hours(Timesheet) * Cost (User Details)

 

can anyone please help.

 

Capture.PNG

Capture1.PNG

 

Regards,

Mayank Gupta

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Anonymous ,

     

    Based on your screen shot it looks like the Timesheet record is not connected to the User Details, I see that column is blank.  Please verify the Parent lookup field is populated with the User Detail record and I assume it will work as expected.  


    Hope this helps.  Please accept if answers your question or Like if helps in any way.


    Thanks,

    Drew

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @dpoggemann 

     

    Thanks for your response.

     

    But i have simply created lookup column with Many to one relationship with User Details Table.

     

    Capture.PNG

    Can you please help, if i missed something here.

     

    Thanks!

    Mayank Gupta

  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Anonymous ,

     

    That is step 1, which is great.


    Since you added the relationship and you have the column on your table for the User Details, add this column to the Form under "Forms".  You can then go in and edit the data and you will be able to select the User Detail record for the Timesheet records.  You can't just create the relationship, you need to populate the value of the lookup column with the parent record (which is what the form will allow you to do once you add the field to it).  Doing this, the check around the email matching in your Calculated column should not be needed because you know it is the right record since they are related by filling in the column value on the form.

     

    Hope this helps.


    Please accept if answers your question or Like if helps in any way.

     

    Thanks,


    Drew

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @dpoggemann 

     

    Thank you so much!

     

    You really saved my day 😊

     

    It is working as expected now.

     

    Regards,

    Mayank Gupta

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 101 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
VASANTH KUMAR BALMADI Profile Picture

VASANTH KUMAR BALMADI 70

Last 30 days Overall leaderboard