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!!!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
194 | |
68 | |
48 | |
42 | |
20 |
User | Count |
---|---|
253 | |
122 | |
83 | |
76 | |
69 |