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?
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.
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.
Click Active to make sure it will worked.
Back to the EndDay, we need to set Column like this.
Click “Edit”.
Click “Save and Close”.
Back to the DataVerse.
It will work.
Hope this will help you.
Best Regards,
Tina