cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Update 2 tables from the same field

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Continued Contributor
Continued Contributor

Re: Update 2 tables from the same field

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.

View solution in original post

1 REPLY 1
Highlighted
Continued Contributor
Continued Contributor

Re: Update 2 tables from the same field

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.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

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

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

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!

Top Solution Authors
Top Kudoed Authors
Users online (7,114)