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 2
Administration 144
Administration and Deployment 801
Advanced theming using CSS 1
AI Builder 36
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 65
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 81
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,152
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 137
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 619
data source 6
data sources 1
Data table 5
data validation 1
database 1
datacard 1
Dataflows 73
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
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
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 4
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 18
github 1
Governance 3
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
Intuit 1
Intuition 1
Invoice 1
iOS 3
Issue 2
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 14
MakerX - Power Apps Canvas 119
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 Teams 2
migrate 1
Missing Fields 1
Mixed Reality 11
mobile 1
Mobile App 1
Mobile Apps 2
Mobile experience 1
Mobility 295
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 36
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 721
popups 1
Portals 304
positioning 1
Power Apps Build Tools 341
Power Apps component framework 46
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 32
Productivity 1
Programming 140
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 3
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 121
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
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 145
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 240
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 3
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

Choose to open front or back camera

Ability to select multiple tables in AI Builder - ...

Add OnPinSelect to dynamic maps

Self reference named operator for controls

Parent & Me - please add reference to the control ...