Newbie trying to patch a rown in a gallery and change its status from active to inactive

(0) Share

Report

Posted on by F.Mogheth

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@FaroukM - given a Gallery selection can also return a record, there is no need to use a LookUp function.

For example you can use:

Patch( 'My Bookings', gallery_myCurrentBooking.Selected, {Status: 'Status (My Bookings)'.Active} )

Was this reply helpful? Yes No
F.Mogheth 48 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot >}{

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@FaroukM - please remember to accept the solution so that others with a similar question can quickly find the solution.

Was this reply helpful? Yes No