I have two tables:
|Batch 1||Meter 1||31/10/22|
|Batch 1||Meter 2||31/10/22|
|Batch 1||Meter 1||31/10/22||loading|
|Batch 1||Meter 2||31/10/22||In progress|
I want to update Tb1 status with Tb2 status where Tb1.Batch = Tb2.Batch & Tb1.Meter = Tb2.Meter
so Tb1 becomes row 1
Batch 1 Meter 1 31/10/22 loading.
I created a custom form that patches data to Tb2 but based on the status update from Tb2, I want to update the status column of a specific row on Tb1 where the batch, meter and date on Tb1 match
how do i achieve this using the patch function
Solved! Go to Solution.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!