Power Apps and Dataverse

(1) Share

Report

Posted on by CU05102352-0

Hello All,

I'm very new to Power Platform and Database management.

I have these two tables above.

This data will be filled out by 2 users. First from HR who will fill out everything under Employees table and the effective date on Staff Movements table. Post this a notification should go out to the contact person updated in the Employees table by HR to fill out another form to complete the record which has the Effective Date filled out by HR in the Staff Movements table.

I'm able to update the Employee Table but the corresponding value Effective Date, etc does not get updated correctly in the Staff Movements table.

Please help and provide suggestions, recommendations, fixes, etc.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Welcome!!!

Now I appreciate you shared the data that is great, but you have to share the app too, with a little more clear detail so we can help

Cheers'

Was this reply helpful? Yes No
Verified answer

ankit_singhal 624 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

As per my understanding , HR can update his table but some value is not updated from HR table to emp table. So you can write power automate flow which can pick value from one table and update on another table. You event can be record create or update. You can select as per your need

NOTE: Please mark verified, if it is useful for you

Was this reply helpful? Yes No
CU05102352-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

HR will submit the Employee tables details and also a few fields such as Effective Date, Staff Movement type, etc. I want this to be updated correctly on both tables so that the EmployeeID is correctly updated/appended on both tables.

Only the Contact Person updated in the Employee Table should be able to view the partially filled record for them and fill out the remaining fields in the table using the form.

Apologies, as I'm new to Power Platform and Database management.

Hope this gives more clarity.

Was this reply helpful? Yes No