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?
Solved! Go to Solution.
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
You could use Patch for this -
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.
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.
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()
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