Here's the situation:
I have a single form in PowerApps that is linked to an Excel table, the goal is to also upload another Excel table from the same field. Can anyone help me do this ? I'm used to variables manipulations.
TL;DR: The goal is to update 2 different Excel tables from the same field.
Solved! Go to Solution.
Hi @Anonymous
You could use Patch for this. I suppose you have a button to push data into the excel?
In that case, you could do next:
Button: OnSelect =
Patch ( ExcelTable1, Defaults( ExcelTable1), { columnName1: DataCardValue1.Text, columnName2: DataCardVakueé.Text, ... } ); Patch ( ExcelTable2, Defaults( ExcelTable2), { columnName1: DataCardValue1.Text, columnName2: DataCardVakueé.Text, ... } );
You just push the data twice with a Patch to different tables on one trigger. Using a SubmitForm here does not work since it will only push the data to its datascource and only one can be connected to a Form.
I hope this helps.
Hi @Anonymous
You could use Patch for this. I suppose you have a button to push data into the excel?
In that case, you could do next:
Button: OnSelect =
Patch ( ExcelTable1, Defaults( ExcelTable1), { columnName1: DataCardValue1.Text, columnName2: DataCardVakueé.Text, ... } ); Patch ( ExcelTable2, Defaults( ExcelTable2), { columnName1: DataCardValue1.Text, columnName2: DataCardVakueé.Text, ... } );
You just push the data twice with a Patch to different tables on one trigger. Using a SubmitForm here does not work since it will only push the data to its datascource and only one can be connected to a Form.
I hope this helps.
User | Count |
---|---|
261 | |
110 | |
90 | |
54 | |
44 |