Summary upcoming booking

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Another question 😉 I want to create a summary page of upcoming booking (all bookings I have).

What I already do:

A SP list with Booking date (Date de réservation) and Created by

What I need:

A summary page to show to users all the upcoming bookings they have + cancel button

BUT I can't create my gallery function... I've done something like that but...

SortByColumns(Filter([@'Reservation parking AIX']; 'Réserver par'.Email = _CurrentUser.email && Date de 'Date de réservation'>=Today());"Date de réservation";Ascending

For cancel button, I don't already have chance to try haha, but I think that I will ad icon on gallery, and add this function:

Remove( [@'Reservation parking AIX']; thisitem )

Many many thanks for your help 😉

Cheers,

Bastien

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Firstly, I would set a Variable for the user's email in App OnStart

Set(varUserMail,User().Email)

then your filter

SortByColumns( Filter( [@'Reservation parking AIX']; 'Réserver par'.Email = varUserMail && DateDiff( Today(); 'Date de réservation'; Days )>=0 ); "Date de réservation"; Ascending )

then on the Remove icon (in the gallery)

RemoveIf( [@'Reservation parking AIX']; ID=ThisItem.ID )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks for your reply @WarrenBelz , but I have an issue... 😞

I've created the variable (on attach)

After that, back to my Gallery - Adding the filter (on attach) but I have a yellow warning icon.
"Issue , Delegation warning. The "filter" part of this formumla might not work correctly on large data sets"

Last thing, on my Gallery, I added a text part with
ThisItem."Date de reservation"
To have all my futures reservation dates, but I have a new issue 😞

So I don't test yet the Remove icon haha 😉

I thanks you all for your help on my first Power apps journey haha

Cheers,
Bastien

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Last thing, I always have this message when I adde the "ThisItem" : "The formula uses scope, which is not presently supported for evaluation"

Again: Thanks a lot 😉

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You received the delegation warning because the DateDiff function is not delegable to SharePoint, so you can set Items for Gallery as following:
SortByColumns( Filter( [@'Reservation parking AIX']; 'Réserver par'.Email = varUserMail && Today()>='Date de réservation' )>=0; "Date de réservation"; Ascending )

Can you show me also the text error when you insert the label ?

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bastienO
Covering your questions:-
You only need to do this at App OnStart to save an unnecessary data query

Set(_CurrentUser,User())

You then have _CurrentUser.FullName and _CurrentUser.Email available for use.
Next, the Delegation warning is because Date queries are not Delegable and also I suspect 'Réserver par'.Email being a complex field type. There are a number of workarounds for this depending on your needs. I will start with a fairly easy one that will work if all the items you are looking for are in the newest 2,000 records (or whatever your delegation limit is set to)
Using the User syntax above

With( { wParking: Sort( AddColumns( 'Reservation parking AIX'; "ResEmail"; 'Réserver par'.Email ); ID; Descending ) }, SortByColumns( Filter( wParking; ResEmail = _CurrentUser.Email && DateDiff( Today(); 'Date de réservation'; Days )>=0 ); "Date de réservation"; Ascending ) )

On your last question, where are you using this (Is the delete button in the gallery or out side it). If outside it, you can use

RemoveIf( [@'Reservation parking AIX']; ID=YourGalleryName.Selected.ID )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No