Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Update value in column by calculation from another table

(0) ShareShare
ReportReport
Posted on by 158

Hello,

 

I have an issue where I have two tables in dataverse. One stores information about jobs and length of training and another one is for recording employees. I am trying to solve a problem where it would count training duration added to starting date and update due date on my table ( so these are 3 different columns in my table but need to take training duration from first table). I tried lookup already but it doesn't seem to be working plus it would be good if data would update itself. 

 

Any ideas, please? 

Categories:
  • Verified answer
    Re: Update value in column by calculation from another table

    Hi @Customs,

     

    May I ask what fields are in your table? Let us combine your description to assume that your two tables are shown in the screenshot.

    The employee Table have a column for looking up the Table Employee.

    vhanytianmsft_0-1687945511849.png

     

    vhanytianmsft_1-1687945511851.png

     

     

    We used calculated column in the Employee Table. However, calculated column cannot get the column from different Table, and we need to use workflow.

    Before we  create a new Workflow, we need to create a “StartDay” and “Day” colunn which are same as DateInfo.

    vhanytianmsft_2-1687945511856.png

     

    vhanytianmsft_3-1687945511858.png

     

    Click Active to make sure it will worked.

    vhanytianmsft_4-1687945511861.png

     

     

    Back to the EndDay, we need to set Column like this.

    vhanytianmsft_5-1687945511864.png

     

    Click “Edit”.

    vhanytianmsft_6-1687945511866.png

     

    Click “Save and Close”.

     

    Back to the DataVerse.

    vhanytianmsft_7-1687945511868.png

     

    It will work.

     

    Hope this will help you.

     

    Best Regards,

    Tina

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard