Update/Patch multiple fields in a gallery

[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?

[ThatAPIGuy]

@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]

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]

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]

@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]

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]

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]

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]

can you take a screenshot of the the error message?

[bucciface]

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