Answered

Calculated Field not updating in Dataverse table

(0) Share

Report

Posted on by Community Power Pla... 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.

Regards,

Mayank Gupta

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@dpoggemann

Thanks for your response.

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

Can you please help, if i missed something here.

Thanks!
Mayank Gupta

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@dpoggemann

Thank you so much!

You really saved my day 😊

It is working as expected now.

Regards,
Mayank Gupta

Was this reply helpful? Yes No