cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tu22
Helper I
Helper I

Update a row on another table only based on the row in another table

I have two tables:

 

Tb1

BatchMeterDatestatus
Batch 1Meter 131/10/22 
Batch 1Meter 231/10/22 

 

Tb2 

 

BatchMeterDatestatus
Batch 1Meter 131/10/22loading
Batch 1Meter 231/10/22In 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

1 ACCEPTED SOLUTION

Accepted Solutions
tu22
Helper I
Helper I

I solved this, anyone who needs the solution can leave a comment

View solution in original post

4 REPLIES 4
tu22
Helper I
Helper I

@Reza please could you help with this?

tu22
Helper I
Helper I

@RandyHayes please could you help

tu22
Helper I
Helper I

@mdevaney please help with this

tu22
Helper I
Helper I

I solved this, anyone who needs the solution can leave a comment

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,918)