I am building a Power App that will fetch data from a SharePoint list.
Columns in SharePoint list
Project Name - Lookup Column
Year - Choice column
Month - Choice column
Billable hours - Single line of text (only numbers used)
I would like to filter the gallery and show the following values
Year | Project Name | This Month | Last 3 months | Last 6 months |
2022 | ABC | 02.00 | 31.05 | 62 .05 |
Ex:
Sep - 10.00 hrs
Oct - 11.00 hrs
Nov - 10.05 hrs
Dec - 02:00 hrs
---
I am not sure if this is doable with the current column setup. I need some suggestions on this.
Thank you,
Hi @Jean_9681 ,
Take a one dropdown and in item property of dropdown code - Choices[@d_sourcename].Year)
and apply below code in item property of gallery
SortbycolumnFilter(D_Sourcename,Startwith(Year,dropdown.selected.value)),'ID',Descending)
If you share some screen short that will be better if code not run
Thanks,
Chitrakant27
User | Count |
---|---|
251 | |
125 | |
106 | |
50 | |
49 |