Get Data from a SQL database and save on another SQL database

[viniandrade]

Hi guys.

I'm new on the PoweAapps (not to say noob) and am having trouble getting what I need.

Here's the point:

I have two different databases (database A ;; database B), with different columns (a1, a2, a3 ;; b1, b2, b3).

I need my app to get the information from database A, column a1 and save this information to database B, column b1.

I already have both databases connected through the gateway.

I was able to select information from database A, column a1 through the ComboBox. Now I need the selected information to be saved to database B, column b1

I don't know if I was clear, but if you can help me I was very grateful!

Translated by GoogleTranslate PT_BR > EN

[Jeff_Thorpe]

Here is an example of how you could use a button to patch the data to database b.

Patch('Database B', Defaults('Database B'), {b1:Combobox.Selected.Value})

*You'll need to update names to reflect what is being used in your app

*This creates a new record in Database B

[v-siky-msft · Accepted solution]

Hi @viniandrade ,

There are several functions you can use to save data, such as Patch(), Collect(), Update(), etc.

To create new records, you can refer to the following formulas:

Patch('Database B', Defaults('Database B'), {b1: Combobox.Selected.a1})

Collect('Database B',  {b1: Combobox.Selected.a1})

To modify records, you can refer to the following formulas:

Patch('Database B', BaseRecord, {b1: Combobox.Selected.a1})

Update('Database B', OldRecord, {b1: Combobox.Selected.a1})   /* this will replace the record, not modify values*/

Best regards,

Sik

[viniandrade]

Tankyou guys.

This realy helps me and the data was submited to my other SQL Database.

Realy Thanks!!!