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.

Report
All responses (
Answers (