Fixed the problem!
I inserted the Refresh(DataSource) Function before the final patch.
On "Yes" Button:
UpdateContext({ showLoader: true});
Refresh(LeaveForm); I added this.
Patch(LeaveForm , LeaveDataSourceSelected,
{
LeaveTypeList: NewLeaveTypeList,
Approver: EditRequestItem.Approver,
});
On "Save" Button:
UpdateIf(LeaveRequestSelectedCollect ,LeaveTypeList <> EditLeaveTypeGallery.Selected.type, {LeaveTypeList:EditLeaveTypeGallery.Selected.type});
Instead of using Patch on the "Save Button" I used UpdateIf Function.
After changing the codes. Save and close your application and Open it again.
Cheers
Hello,
I am facing the same issue and i tried refreshing the data source before patch and it is not working:
I am actually doing bulk update:
ForAll(
processedLineItems,
Patch(
'Supplier Invoice Data',
LookUp('Supplier Invoice Data', ID = processedLineItems[@ID]),
{Status:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: "Portal Upload"},DataReadyForUpload:true,Portal_x0020_Reference:Concatenate("Portal Reference _",Text(Now()),"_Submit")}
)
)
ِAlso i am doing Individual Updates on Items in a gallery:
Patch('Supplier Invoice Data',ThisItem,{To:ToDate.SelectedDate})
Hi,
Have you tried using UpdateIf Function?
On the screen property OnVisible,
Set(ProcessedLineItemsID, processedLineItems[@ID]))
ForAll(
processedLineItems,
UpdateIf(
'Supplier Invoice Data', ID = ProcessedLineItemsID,
{Status:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: "Portal Upload"},DataReadyForUpload:true,Portal_x0020_Reference:Concatenate("Portal Reference _",Text(Now()),"_Submit")}
)
Adding the Refresh Button make the app run longer for about 10 seconds 😞 not ideally
I can't get my SharePoint list to update after attempting to fix that ETAG error.
At first I had this on my Screen's OnVisible:
Refresh(SpTable); ForAll(ClTable, Patch(SpTable, LookUp(SpTable, true), {index:index, power1:power1, power2:power2, (…)}))
And I changed it to this:
Refresh(SpTable); ForAll(ClTable, UpdateIf(SpTable, true, {index:index, power1:power1, power2:power2, (…)}))
ClTable is a collection table, SpTable is the SharePoint one. Both have same columns but since PA was complaining about not being able to modify "Modified" column I told it to update only specific columns. It kinda works when I use Patch, but it skips random records, but with UpdateIf nothing gets updated. All records must be updated, hence why I used true as condition.
Any help would be appreciated.
Added the Refresh data source slow the whole thing down significantly,
Is this a Sharepoint issues, ot Powerapps issues ?
User | Count |
---|---|
141 | |
135 | |
77 | |
75 | |
69 |
User | Count |
---|---|
223 | |
190 | |
66 | |
62 | |
55 |