how to route record to be added to multiple SharePoint List

(0) Share

Report

Posted on by MTNK

819 Moderator

Good Morning Team,

I build Power app for Production Issue Tracking(before only SharePoint site 1 was added to the app, later SharePoint site 2 is being added to the app so that records can be added to

Our business requirement is - to add record to two Sharepoint list based on Location selection.

For example -

Location A - record should be added to SharePoint 1

Location B - record should be added to SharePoint 2

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Pstork1 69,556 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Assuming that this is a Canvas app and there is code behind the green check icon in hte upper right to commit the record using either a submitForm() or a Patch(). If that is the case just change the code in the OnSelect for the green check to add an if() based on condition that Patches the correct list. There won't be a way to do it with Submit form, because a form is bound to a single data source (list).

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

Mahesh Birudu 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is the step by step process

Srep1: Button select property:

Switch(

location_Datacard.Selected.Value,

"India",

Patch(

Location2,

Defaults(Location2),

{

Title: DataCardValue1.Text

}

),

"USA",

Patch(

Location1,

Defaults(Location1),

{

Title: DataCardValue1.Text,

Location: { Value: location_Datacard.Selected.Value },

Lists: { Value: "Site1_Location1" }

}

),

"UK",

Patch(

Location2,

Defaults(Location2),

{

Title: DataCardValue1.Text

}

)

)

Step2:

In the Lists control DefaultSelectedItems property, you can use the following logic:

Switch(DataCardValue2.Selected.Value,"India",{Value:"Site2_Location2"},"USA",{Value:"Site1_Location1"})

Note: The Lists dropdown is used solely for routing the form. Its value is automatically determined based on the selected location. Therefore, it should be configured to map accurately according to your business requirements.

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @MTNK,

SubmitForm won’t work in this scenario because it is tied to a single data source. Instead, you can use the Patch() function. Using Patch, you can dynamically choose the data source depending on the selected Location and create the record accordingly.

Approach 1

Example:

In this example, we’re just switching the SharePoint list based on the selected Location. The Patch() function code remain the same, we’re only changing the data source.

If(ComboBox2.Selected.Value = "Location A", //ComboBox2 - Replace with your combobox name Set(g_SharePointList,Test3);, //Test3 - Site 1 List Name Set(g_SharePointList,Test3_1) //Test3_1 - Site 2 List Name ); Patch(g_SharePointList, Defaults(g_SharePointList), { DueDate:Today() //Column names and value - Make sure to use internal column naming conversation. } );

Note: This assuming both SharePoint lists have the same column naming conversations.

Approach 2

Example:

If SharePoint column naming conversation are different in both sites then use below approach:

Switch(ComboBox2.Selected.Value, "Location A", Patch(g_SharePointList, Defaults(g_SharePointList), { DueDate:Today() } );, "Location B", Patch(g_SharePointList, Defaults(g_SharePointList), { DueDate:Today() } ); );

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No