Patch to 2 Dfferent Data Sources

[BrendonBrooksP1]

Is it possible to Patch to two different SQL tables? For example:

Patch('[dbo].[Test]', Defaults('[dbo].[Test]'),'[dbo].[Test2]', Defaults('[dbo].[Test2]'), {Testdata: TextInput_1.Text, Testdata2: Option1.Selected.Value, Testdata3: Option2.Selected.Value}) 

[mr-dang · Accepted solution]

Hi,

This is possible. Any time that you want to perform more than one action with a Button (or any object with the OnSelect property), use a semicolon to separate actions:

Patch('[dbo].[Test]', Defaults('[dbo].[Test]'),
	{Testdata: TextInput_1.Text, 
		Testdata2: Option1.Selected.Value, 
		Testdata3: Option2.Selected.Value
	}
);

Patch('[dbo].[Test2]', Defaults('[dbo].[Test2]'), 
	{Testdata: TextInput_1.Text, 
		Testdata2: Option1.Selected.Value, 
		Testdata3: Option2.Selected.Value
	}
)

This formula means, "Patch the data to [dbo].[Test], then patch the same data to [dbo].[Test2]." There's no limit to the number of actions you can chain.

[BrendonBrooksP1]

Thank you! I'll give that a try this morning.

[BrendonBrooksP1]

That worked! Now comes the fun part of writing a formula that writes to 8 different tables. Thanks again @mr-dang

[BraneyBI]

Mr-dang,

Truly appreciate all of your posts!  They seem to always be here just when I need them!

[tianaranjo]

I posted in another thread, but after coming across this thread, wanted to pose my question here also.  The data for my app is a SharePoint list.  I have a choice column with 1. Report an Issue 2. Make a Suggestion 3. Ask a Question.  If the user selects 1 or 2, I would like the new item to go to the original data source.  However, if they select 3, I would like to patch the data to a SharePoint discussion board.  

First, is this possible?

Second, if so, how would I write the formula to patch to the DB?

Thank you.

[BraneyBI]

You are going to want to wrap the patch in an IF statement to check for your selection.  In this case, if 1 or 2 is selected, then the first patch will run, else the second.  Note:  There is now a Comma between the patches (not a semicolon) as it is now separating the clauses of the IF statement. 

If( 
(MyChoice.Selected.Value = 1 or MyChoice.Selected.Value = 3)

Patch('[dbo].[Test]', Defaults('[dbo].[Test]'),
	{Testdata: TextInput_1.Text, 
		Testdata2: Option1.Selected.Value, 
		Testdata3: Option2.Selected.Value
	}
),

Patch('[dbo].[Test2]', Defaults('[dbo].[Test2]'), 
	{Testdata: TextInput_1.Text, 
		Testdata2: Option1.Selected.Value, 
		Testdata3: Option2.Selected.Value
	}
)
)