#microsoft365 #powerapp #sharepointonline #sharepoint #sql #webservice
On premise env. structure
Infopath form-Webservice-SQL database
SharePoint online Env.
PowerApp-SQL Database
Using patch function submitting in both SharePoint online list as well as SQL database. Premium SQL connection
//////////////////////////
Patch(secondtable,
Defaults(secondtable),
{ Name:DataCardValue4.Text, DueDate: DataCardValue5.SelectedDate, Area:DataCardValue6.Selected.Value }
);
Patch(SQL,
Defaults(SQL),
{ Title:DataCardValue4.Text, DueDate: DataCardValue5.SelectedDate,Area:DataCardValue6.Selected }
);
Notify(
"Operation Successful",
NotificationType.Success,
5000
);
Navigate(
BrowseScreen1,
ScreenTransition.Fade
)
/////////////////