Answered

Updating a Collection after a Patch

(0) Share

Report

Posted on by BrendonBrooksP1

329

Good evening. So far for my inventory app, I've been able to speed up performance dramatically by caching reference data that come from tables in my Azure SQL Database. A great tutorial for this is on @Meneghino page (i think its him) and it really helped.

I used this formula to create my Collection in the OnStart property:

ClearCollect(CollectionName, '[dbo].[TableName]')

But what if I wanted to update a Collection after I Patch a record? How would I go about doing that? Would the following work

1. User clicks "Update Button"

2. Update Button does this:

Patch('[dbo].[TableName]', First(Filter('[dbo].[TableName]', Id = Value(InspectId.Text))), {Base: DataCardValue12.Selected.Value, Location: DataCardValue44.Selected.Value, Unit: DataCardValue15.Selected.Value, Status: DataCardValue43.Selected.Value}); SubmitForm(EditItemForm) ClearCollection(CollectionName, '[dbo].[TableName]')

Does that significantly increase the amount of time the app has to save a record, update collection, load screen, display screen?

Brendon

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Meneghino 6,949 on at

Like
a
(1)

Report
Copy link

Link copied!
This is a start for iprovmement, and yes it is me...
Please note particularly how to refer to a record to update in the second argument of the Patch: you only need the primary key value(s) to identify a record uniquely... It saves at least one read operation

Patch( '[dbo].[TableName]', {Id: Value(InspectId.Text)}, { Base: DataCardValue12.Selected.Value, Location: DataCardValue44.Selected.Value, Unit: DataCardValue15.Selected.Value, Status: DataCardValue43.Selected.Value } ); ClearCollect(CollectionName, '[dbo].[TableName]')

Was this reply helpful? Yes No
BrendonBrooksP1 329 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. That worked magically.

Was this reply helpful? Yes No