cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

ADD record to a table of another table in powerapps

Can anyone help me on how can I add few field records of one table to another in powerapps?.

I am updating a table "A" with data using gallery .Now I want to add some field records to another table "B" from table "A"

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: ADD record to a table of another table in powerapps

Hi @PriyaShetty 

The way to do this is to call the Patch function to add your records to Table B.

@eka24's  code here gives a good example.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Need-to-copy-records-from-one-table-to-anoth... 

Here's a link to online documentation for Patch.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-patch 

View solution in original post

Highlighted
Super User
Super User

Re: ADD record to a table of another table in powerapps

Hi @PriyaShetty 

You're welcome!

You can use the GroupBy and Sum functions to do this.

Here's the help page.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-groupby 

Your formula would approximately look like this. This will return a table with the columns Pid and SumOfRating.

AddColumns( 
 GroupBy(TableA, "Pid", "GroupedItems"),
 "SumOfRating",
 Sum(GroupedItems, Rating)
)

 

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: ADD record to a table of another table in powerapps

Hi @PriyaShetty 

The way to do this is to call the Patch function to add your records to Table B.

@eka24's  code here gives a good example.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Need-to-copy-records-from-one-table-to-anoth... 

Here's a link to online documentation for Patch.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-patch 

View solution in original post

Highlighted
Frequent Visitor

Re: ADD record to a table of another table in powerapps

@timl Thank You.This solution worked  for me.As I have one more query on how can sum all the field values .

Below is the table

Pid      Rating

201      2

201      3

201      1

301      2 

301      1

 

 

so i should get sum of rating for all pid 201 as 6 and for 301 as 3

Highlighted
Super User
Super User

Re: ADD record to a table of another table in powerapps

Hi @PriyaShetty 

You're welcome!

You can use the GroupBy and Sum functions to do this.

Here's the help page.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-groupby 

Your formula would approximately look like this. This will return a table with the columns Pid and SumOfRating.

AddColumns( 
 GroupBy(TableA, "Pid", "GroupedItems"),
 "SumOfRating",
 Sum(GroupedItems, Rating)
)

 

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (12,937)