Answered

1. Showing total number of reservations when choosing date in the powerapps calendar; 2 table sorting doesn't work; 3 group data table per date?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello, Im building a powerapp used for attendance registration at my office. I've used a powerapp for the form and a sharepoint site to store the registrations in a list. This is my first powerapp so I'm quite new at this. I have 3 problems that I need help with:

1. I want to be able to show the total number of registrations when selecting a date in the powerapps calendar, is this possible?

2. The sharepoint list is viewed in the app as a datatable, but the table won't sort after latest date, is it possible to set as default?

- I am using a button with the following code: SortByColumns(Närvarostatus; "Datums";Ascending) where Närvarostatus = list name, Datums=name of column

3. Is it possible to group the data table per date (displaying total number of registrations per day) as in the sharepoint site? I have attached a screenshot of the sharepoint view.

Thank you very much for your help! All the best / Axel

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

If you want the numbers per date

Sort( AddColumns( GroupBy( Närvarostatus; "Datums"; "OtherData" ); "DateCount"; CountRows(OtherData) ); Datums )

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!

@WarrenBelz Thank you for your reply,

When adding this code to the OnSelect field of a button, it does nothing? Should I apply the code elsewhere? Thanks

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

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous ,

The code should be the Items of a gallery - you asked how to display these.

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!

@WarrenBelz Update: How can I write the OnSelect code of each individual object, if I want to navigate to another screen with a data table with a filter so that it only shows the bookings made on the particular date?

Something like this?
Navigate(Screen1;ScreenTransition.Cover;Filter(Närvarostatus; ThisItem.Datums=Today(Datum)))

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

The Filter needs to be on the second gallery (you just need to navigate to it) and would be something like

Filter( Närvarostatus; Text(Datums,ShortDate)= Text(FirstGalleryName.Selected.Datums,ShortDate) )

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!

Thank you for all of your help! I'll mark your answer as the accepted solution. Best regards / Axel

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

Like
a
(0)

Report
Copy link

Link copied!

I'll ask one more question if you want to: is it possible to set default filtering on a gallery - showing only the items created by the user? Best regards / Axel

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

Like
a
(0)

Report
Copy link

Link copied!
Thanks @Anonymous ,

Yes, but the property 'Created by' is not Delegable and will have issues on large data sets. The syntax would be

Filter( Närvarostatus; Text(Datums,ShortDate)= Text(FirstGalleryName.Selected.Datums,ShortDate) && 'Created by' = User().FullName )

Was this reply helpful? Yes No