Share your ideas and vote for future features

Suggest an idea

Hot Ideas
Top Ideas
New Ideas

Currently, we don't have any direct way to calculate week number of the particular Date. It would be better to have a function which displays the weeknumber for example: WeekNum("26-10-2017") = 43 to avoid usage of other source for this information and then retrieving back to Powerapps application.

Status:

Updating status and adding @GregLi

Hi, I am preparing a dashboard whereby I can view my records based on week. It seems like there is no formula that allows me to match by Week. Similar to Excel we can filter by This Week, Next Week.. etc. So will be good to have these formula added. Thank You Boon Yar

Status:

Labels

4 tier 1
500 limit 1
AAD 1
Access 5
Access Web Apps 1
Accounts 2
adfs 1
admin 1
Admin Center 15
Admin Tooling 8
Administration 190
Administration and Deployment 801
Advanced theming using CSS 1
AI Builder 43
Aligment 1
ALM 1
Alternate row color 1
analytics 3
anchor tags 1
android 1
Animation 1
anonymous 1
api 3
API Tips 1
app 1
App Launcher 1
app lock 1
app settings 1
App usage report 1
Application 2
Application Close 1
Approach 1
Approvals 2
Apps Management 1
AppSource 70
Archive 1
asana 1
Attachements 1
Attachment 5
attachment control 1
attachments 3
Attachments cannot download in IE 1
Attendee checklist 1
Audit 2
auto 1
AutoHeight 1
Autorefresh app list 1
Azure AD 2
Azure Table Storage 1
back 1
Back Buttons on Mobile Device 1
background colour 1
background Task 1
backup 1
Barcode 6
Beacon 1
benchmark 1
Blob Connector 1
Blob Storage 2
Bluetooth 2
bookings 1
Bot 1
Bottom Menu 1
Bug 5
bug bounties 1
bug bounty 1
Build Forms Faster 1
Built-in Function 1
business process 1
button 2
Buttons 6
cache 1
Calendar 4
Camera Roll 1
Canvas 175
Canvas apps 4
Cascading Controls 1
Catalogue 1
CDS 1
Charts 4
chat 1
China 1
choice 1
Choice Fields 2
Clear 1
Client-Side Programming 1,150
Clock 1
closing browser 1
Cloud native connection to PostgreSQL and MySQL 1
code 2
Coding 2
Collection 1
Collections 4
column 1
columns 3
Combine apps 1
ComboBox 4
Common Data Service 189
Common Data Service for Apps 139
community 1
Company Branding 1
Connect to data 2
Connecting to Data 10
connection 3
Connector 12
Connector selection 1
connectors 6
connectror 1
Control 4
Controls 13
convert 1
copy 3
Core Platform - Data Services 43
Core Platform - Solutioning 13
Core Platform - Solutions 23
Core Platform - SSS 11
create 1
create form based on json data 1
Creating Apps 5
CRM 2
Currency Format 1
custom 2
Custom API 2
Custom app categories 1
Custom app labels 1
Custom Connector 3
Custom procedures and functions 1
custom view 1
customApiEndpoints 1
Customization and Solutions 2,186
customize chart 1
Customize Forms 2
Cut 1
data 4
Data Cards 2
Data connection 3
Data Integration 1
data label 1
data label in chart 1
Data Management 643
data source 6
data sources 1
Data table 5
data validation 1
database 1
datacard 1
Dataflows 85
datasource 1
DataSourceInfo SharePoint Permissions 1
datatable 4
Date 5
Date and Time 2
date type in sort order 1
DatePicker 6
DatePicker Optimalisation 2
dates 1
debugging 2
decode 1
default 2
Default Environment 2
delegation 4
delete 2
deployment 1
Deprecating Features 2
design 2
Design patterns 1
designer 3
Dev Tooling 13
Developer Story 1
development 5
Device 1
Device orientation 1
Discussion Board 1
distribution lists 1
DLP 1
documentation 3
Documents 1
dropdown 1
Dropdown control 2
DYN365 1
dynamic column names 1
dynamic content 1
Dynamic Filtering. 1
Dynamics 1
Dynamics 365 1
Dynamics 365 Home Page 1
Dynamics 365 Operations 1
Ease of use 1
Easy 1
Edit changes 1
Edit Form 1
Editing 3
Editor 1
Education 1
Employee idea app in Teams 2
Encryption 1
enterprise 2
Enterprise Branding 1
Entities 2
Environment 2
environments 1
ERROR 6
Error code 1
ERROR handling 2
error message 1
errors 1
Event 1
Events 1
Evironment 1
example 1
Excel 1
Export 3
Expression 1
Extension Attributes 1
external users 1
Features 1
field 1
File System 1
Filter 4
Filter() function optimalisation 1
Filtering 1
flow 5
Flow Action 1
Flow Bug 1
Flow Button Control 1
Flow Error 1
flow management 1
flow run history 1
Flows 10
Focus 3
folders 1
fonts 1
Form 3
Form Data 1
format 1
Format Currency Field 1
Formatting 3
Forms 10
Forms Control For CAnvas 1
Formula 6
Formula Bar 1
Formulas and controls 1
forum posts 1
Freeze 1
Function 2
Functionality 3
functions 8
Gallary 1
Galleries 2
Galleries and forms 1
gallery 5
Gallery Template 1
gateway 2
General Questions 2
Geospatial 21
github 1
Governance 14
Government Tenants need PowerApps 1
GPS 1
grids 1
Group Access 1
groups 2
guidance 1
hamburger menu 1
Handling 1
HintText 1
history 1
horizontal 1
hover 1
html 2
Hyperlink 1
I want to display all the functions in the application 1
Icons 4
Idea 2
ideas 1
identity management 1
Image 3
Images 1
Images not showing 1
immobilize data table 1
Import 2
in a list. 1
index 1
InfoPath 1
Input Fields 2
insert 1
insert screens 1
Inspection app in Teams 4
Intuit 1
Intuition 1
Invoice 1
iOS 3
Issue 2
Issue reporting app in Teams 1
issue tracker 1
JSON 3
keyboard 1
Keyboard Focus 1
keypress 1
kiosk mode 1
Label 5
labels 1
Layout 1
Learn 1
Library 2
Licensing 1
line chart 1
line space 1
links 1
list 2
List of Fields 1
Listbox 1
lists 1
load 1
LoadData 1
localization 1
localstorage 1
Location Services 1
Lock 1
logging 1
Login 1
lookup 2
Lookup Column 1
Lookup Columns 1
Lookup field 1
Mac 1
MakerX - Power Apps 29
MakerX - Power Apps Canvas 118
MakerX - XRM Design & Customizations 11
Managed Metadata 1
Management 1
markdown 1
Markers 1
master details app 1
Media 1
Menu 2
message 2
metadata 1
Microsoft Dataverse 3
Microsoft Teams 2
migrate 1
Missing Fields 1
Mixed Reality 14
mobile 1
Mobile App 1
Mobile Apps 2
Mobile experience 1
Mobility 303
Model Driven Filter 1
model-driven 1
Monetize 1
Monthly Communications 1
Ms Flow 1
multichoice 1
multiple 2
Multiple Flow Authors 1
multiple login 1
Multiple selection 1
multiple users 1
multiple values 1
MySQL 3
name 1
navigate 2
Navigation 3
Nearby sharing 1
nesting 1
New Idea 2
next 1
NFC 1
No items to display 1
Non-printable Guidelines 1
notifications 3
Notify 2
Number 1
number sequence 1
O365 connection 1
oauth2 1
object 1
ODATA 1
ODBC 1
office365user 1
Office365Users 1
offline 3
On-Premise 2
OnChange 1
OneDriive 2
onedrive 1
OneNote 1
OnExit 1
Online 1
ONNX 1
OnStart 1
open 1
Open API 2
openapi 1
opening 1
order 1
Organization 2
Organization Insights 39
Orientation 1
Outlook 3
owner 1
Package 1
Parameter 1
Paste 3
pbix 1
PDF 7
pdfs 1
PenInput 1
performance 2
Permission 1
permissions 2
person field 1
person selection 1
Philosophy 1
Photograph 1
Pivot 1
Planner - Comments 1
Plug-ins & Workflow and Web Services 727
popups 1
Portals 322
positioning 1
Power Apps Build Tools 451
Power Apps component framework 95
Power Apps in Teams 9
powerapp 1
PowerApp Alert 1
Powerapp For Dynamics 365 CRM 1
PowerApps 56
PowerApps API 1
PowerApps App 1
PowerApps Build Tools 135
PowerApps Component framework 147
PowerApps Component Framework (PCF) 18
PowerApps for iOS 1
PowerApps Form 2
PowerApps Fuction 2
PowerApps Push Notification 1
PowerApps SharePoint 2
PowerApps Studio 7
PowerApps Usage 4
PowerAppsFlow 1
PowerAppsManagement 1
PowerBI 2
PowerPoint 1
Powershell 3
Press 1
previous versions 1
printing 1
priting 1
Product Documentation 36
Productivity 1
Programming 172
property 1
Push notification 1
QnA 1
QuickBooks 1
Radius 1
Rank Function 1
rating 1
read sharepoint hosting page query string 1
record variable 1
Recycle Bin 1
refresh 2
Refresh icon 1
Regular Expressions 1
Relationships 2
Release Notes 1
reorder 2
reordering 1
repeat 2
Report 1
Request 1
reset 1
Reset Button 1
response 1
responsive design 1
REST 2
Restrictions 3
resume 1
RichText 2
RichTextEditor 3
Right Click 1
RoadMap 1
RTF 2
rules 1
Sales 1
Sample Apps 1
Sandbox 1
sap 1
SAS 2
SaveData 1
Scanning 1
Screen 1
Screen Capture 1
screen control 2
screen sizing 3
Scrollable Canvas 2
Scrolling 3
SDK 6
search 128
search icons 1
Search property 1
SearchUser 1
Security 383
select 1
Separations 1
Set character type for data 1
share 5
Share and Embed 1
Share SharePoint Connection 1
shared resources 1
SharePoint 19
SharePoint Connection 2
SharePoint Connector 2
Sharepoint Customized Forms 4
SharePoint Document Library 2
Sharepoint Files 2
sharepoint form 1
SharePoint group membership 1
Sharepoint groups in power apps 1
sharepoint item security 1
SharePoint List 12
SharePoint List Form 1
SharePoint List Item 1
SharePoint List Item Fields 1
SharePoint list view by group-by functionality 1
SharePoint Lookup 1
Sharepoint online 4
SharePoint Online List 1
SharePoint PowerApp 2
Sharing Connections 1
sharing powerapps 2
shifting data cards one by one 1
side menu 1
Signals 2
Signup & Trials and Subscription 4
Signup and Subscription 46
single user 1
sktech 1
slack 1
Solutions 141
Sorting 1
space 1
Speed 1
SQL 3
SQL Connector Issue 1
SQL Join 1
SQL Server 2
SQL Server trigger 1
sqlupdate 1
storage 1
Strategy 1
Stream 1
style 1
Suggestion 3
Sum 1
swagger 2
switching 1
Sync 1
Tab Bar 1
Tab order 1
tabbed form implementation 1
Tables 4
Tally 1
Task Content Type 1
Task List 2
Team Services 1
Teams Integration 3
Telemetry 1
Template 4
Templates 1
TermStore 1
text 1
TextInput properties 1
The "Book A Room" template becomes an error and can not be used. 1
throttle 1
tickets 1
ties 1
Time Control 2
timesavers 1
TLS SSL mutual authentication support 1
toggle 1
Toggle off the App Checker 1
Training and Readiness 7
Transfer 1
tree list 1
Tree view 1
Trello 1
trigger 1
Triggers 1
UI 6
Unified Interface 177
Unique 1
unique id 1
update 1
UpdateContext 2
UpdateIf 1
Updates 2
upload 1
url 2
user 2
User Choses Theme 1
User Experience 238
User function 2
UserX - UCI Web 11
UX 1
v3 1
validation 2
Variable 2
variables 1
Version 2
version 3 1
Version Control 3
Version management 3
versioning 2
vertical 1
Video 2
videos 1
view 2
visibility 1
Visual Studio 3
VSTS Integration 1
We need some functionality to prevent some users from using Azure AD. 1
Web App 1
Webinars 1
webpart 2
Website 1
Week 2
White label 1
Windows 10 1
Word 1
wrapcount 1
write 1
XML 1
Yammer 1
YouTube 1
✅ Completed 4

Share your ideas and vote for future features

Addition of Week Number function in Powerapps

Enhance on the Date Filters

Helpful resources

Form processing - combine multiple AI models

AI Builder - Form Processesing - Size Limitation

Selecting fields from multiple documents

Delete Saved Versions - Revert to Live

Embed Stream videos in PowerApps