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
Solved! Go to 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
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
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
Tankyou guys.
This realy helps me and the data was submited to my other SQL Database.
Realy Thanks!!!
User | Count |
---|---|
150 | |
100 | |
89 | |
78 | |
57 |
User | Count |
---|---|
194 | |
186 | |
106 | |
99 | |
91 |