
Announcements
I have a gallery in power apps. I have a Add Row button outside my gallery with following formula for Onselect: If(CountRows(colTaskUpdates)>0,Select(SaveButton));
Patch(
Budget_Data,
Defaults(Budget_Data),
{Title: ""}
)
On appstart, i have a property Onstart : ClearCollect(
colTaskUpdates,Defaults(Budget_Data)
);
Clear(colTaskUpdates);
the on change property for each boxes in the gallery is :If(
ThisItem.ID in colTaskUpdates.ID,
Update(
colTaskUpdates,
LookUp(
colTaskUpdates,
ID = ThisItem.ID
),
{
ID: ThisItem.ID,
Title: PeriodComboBox.Selected.Value,
Leads: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & LeadsCombo.Selected.Mail,
Department: "",
DisplayName: LeadsCombo.Selected.DisplayName,
Email: LeadsCombo.Selected.Mail,
JobTitle: "",
Picture: ""
},
'CAS Team': CasteamCombo.Selected,
'Budget Category': BudgetCategoryCombo.Selected,
'Budget Allocated': Value(BudgetAllocatedText.Text)
}
),
Collect(
colTaskUpdates,
{
ID: ThisItem.ID,
Title: PeriodComboBox.Selected.Value,
Leads: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & LeadsCombo.Selected.Mail,
Department: "",
DisplayName: LeadsCombo.Selected.DisplayName,
Email: LeadsCombo.Selected.Mail,
JobTitle: "",
Picture: ""
},
'CAS Team': CasteamCombo.Selected,
'Budget Category': BudgetCategoryCombo.Selected,
'Budget Allocated': Value(BudgetAllocatedText.Text)
}
)
)
and the onselect property of my save button is : If(CountRows(colTaskUpdates)>0,Patch(Budget_Data,colTaskUpdates);Notify("Success",NotificationType.Success));Clear(colTaskUpdates);
Now every time i add a new row or save the data , it always shows me the same error as follows: Network Error while using Patch Function. The requested operation is invalid.
Please help me with this issue as soon as possible.
basically i am making a excel like gallery in power apps. I am storing the data in sharepoint list. the add button adds a new row in the gallery while letting the previously made entries to remain as it is.
Please help me.
Moving this post to Building Power Apps forum where you will get better, faster responses.