Update/Patch multiple fields in a gallery

(0) Share

Report

Posted on by bucciface

Hi all...

Not sure how to change multiple fields in a gallery. I'm confused about using patch vs updateif vs collect.

Basically...I have a dashboard page which displays appointments and details about each appt. I want the user to be able to hit the edit icon and be taken to a page where they can change these details if needed. Not sure how to make it happen. Any suggestions?

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

ThatAPIGuy 925 on at

Like
a
(0)

Report
Copy link

Link copied!

@bucciface

You could use Patch for this -

Patch(Collection1, Filter(Collection1,Appointment=Dropdown1.Selected.Value&&Patient=Patient.Text),{Appointment:Dropdown1_1.Selected.Value,Patient:Name_1.Text,etc.})

Also, I am curious to know what's your Datasource where you are saving all the data. If it's on a Sharepoint list, you can simply click on Create powerapp and it will automatically create the app with the view gallery, display a record/form and edit a record/ form and everything will be connected and linked.
bucciface 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the data on an excel sheet. If others will be using the app...is it best to have the data on a sharepoint list?
bucciface 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the data on an excel sheet. If others will be using the app...is it best to have the data on a sharepoint list?
ThatAPIGuy 925 on at

Like
a
(0)

Report
Copy link

Link copied!

@bucciface

If the data is in an excel sheet which is in OneDrive folder that is share with others, it should be fine as well.

My personal preference would be a sharepoint list, as it has more customizing options compared to excel sheet.

In both the cases, you can make the app automatically by following these steps -

However, as you have some dropdown fields , I am not sure how that would work from excel. In Sharepoint List, you can define those as choice fields.

Anyways, if you don't want to take this route, let me know if the patch function worked for you.
leyburn19 2,157 on at

Like
a
(1)

Report
Copy link

Link copied!

I have found patch() and updateIF() unreliable for updaing records, not sure if it me or the system. You need to also not they are not deleagable (now up to 2000 records on client side)

I use Flow to do this. Very simply with sharepoint. When it needs to be more than one record, I embed the Flow in PowerApps in a Forall()
bucciface 14 on at

Like
a
(0)

Report
Copy link

Link copied!

I wasn't able to get it working. I took a screenshot. The filter has invalid arguments.

I must have something wrong in the filter argument. Thanks
leyburn19 2,157 on at

Like
a
(1)

Report
Copy link

Link copied!

Why are you trying to patch a collection. Wouldn't it be simpler to have a Gallery that shows patients on the date (or between dates) then have a an edit form based on the Gallery. When you select the patient it sends you to teh form, which you edit and submit

It also would be easier if you are doing this on a sharepoint list
ThatAPIGuy 925 on at

Like
a
(0)

Report
Copy link

Link copied!

can you take a screenshot of the the error message?
bucciface 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure. Here it is. There may be more than just 1 error.
Verified answer

ThatAPIGuy 925 on at

Like
a
(1)

Report
Copy link

Link copied!
@bucciface

I see there was a mistake in my previous code. You need to patch to a record and the Filter statement produces a table instead of a record.

so change it to

Patch(Collection1, First(Filter(Collection1,Appointment=Dropdown1.Selected.Value&&Patient=Patient.Text)),{Appointmentropdown1_1.Selected.Value,Patient:Name_1.Text,etc.})