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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Update value in column...
Power Apps
Answered

Update value in column by calculation from another table

(0) ShareShare
ReportReport
Posted on by MP-13011217-0 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:
Building Power Apps
I have the same question (0)
  • Verified answer
    v-hanytian-msft Profile Picture
    v-hanytian-msft Microsoft Employee on at

    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

News and Announcements

Welcome to the Power Platform Communities

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,033

#2
Valantis Profile Picture

Valantis 632

#3
11manish Profile Picture

11manish 607

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans