Haven´t been on canvas apps and Power fx for ages... I have an app that makes a booking/reservations of seats.
- I have a gallery already filtered showing the rows of active "bookings" . gallery_myCurrentBooking
The formula is
First
(Sort
(Filter(´My Bookings´, Status=´Status (My Bookings)´.Active), ´Created on´, SortOrder.Descending))
Here I want to further filter to show me only "my" bookings based on my user().email
The main issue though is:
- I would like to add a button and "onSelect" to patch or change the selected row and change its status to "inactive". I am trying the
Patch(
´My Bookings´,
LookUp(´My Bookings´, ID = gallery_myCurrentBooking.Selected.ID), {Status: "Inactive"} )
But I do not understand how to get the ID of that particular row or whether there is another way about it. It's a row in Dataverse with the booking name, date from to, user and status.
Grateful for any assistance