1.First & First N :- First formula is used to get a first record in a data table.
First N formula is used to get a specific count of starting records in a data table
These formulas only work on Data table
Here i am connecting a data source “Electronics” to power apps. Electronics list is displayed in a data tables as shown below
![](http://rishandigital.com/wp-content/uploads/2022/11/fi1.jpg)
First function will display first record as shown below
formula:- first(Electronics)
![](http://rishandigital.com/wp-content/uploads/2022/11/fi2.jpg)
first n function will display a specific count of record as shown in image
Formula :- first N(Electronics,5)
![](http://rishandigital.com/wp-content/uploads/2022/11/fi4.jpg)
2.Last & Last N:- Last formula is used to get a Last record in a data table.
Last N formula is used to get a specific count of Last records in a data table
These formulas only work on Data table
Last will display the last item in electronics in which last item is 15th one as shown below
formula :- Last (Electronics)
![](http://rishandigital.com/wp-content/uploads/2022/11/fi3.jpg)
Last N will display the specific records from last of data source. here last 5 records are displaying in data table by using Last N formula as shown below
Formula :-Last N(Electronics,5)
![](http://rishandigital.com/wp-content/uploads/2022/11/fi5.jpg)
We can use first and last functions in different ways as shown below
![](http://rishandigital.com/wp-content/uploads/2022/11/f6.jpg)
![](http://rishandigital.com/wp-content/uploads/2022/11/f7.jpg)
3. Index formula:- Index formula is used to display a specific indexed record.
Here the record which is indexed as 8 will be displayed in below image.
Formula:- Index(Electronics,8)
![](http://rishandigital.com/wp-content/uploads/2022/11/fi7.jpg)
4. Date formulas :- we can hard code a particular date by using this function “Date”
![](http://rishandigital.com/wp-content/uploads/2022/11/fi8.jpg)
when we require to display today date we can use “today” function
![](http://rishandigital.com/wp-content/uploads/2022/11/fi9.jpg)
when we require to display today date and time we can use “Now” function
![](http://rishandigital.com/wp-content/uploads/2022/11/fi10.jpg)
we can display a day of this week by using this function “Day(Today())”
![](http://rishandigital.com/wp-content/uploads/2022/11/fi11.jpg)
Month of this year will display by using this function “Month(Today())”
![](http://rishandigital.com/wp-content/uploads/2022/11/fi12.jpg)
We can display the year by using this function “Year(Today())”
![](http://rishandigital.com/wp-content/uploads/2022/11/fi13.jpg)
Today Date will also be displayed as shown below
![](http://rishandigital.com/wp-content/uploads/2022/11/fi14.jpg)
Week day function will display which day is today in this week
![](http://rishandigital.com/wp-content/uploads/2022/11/fi15.jpg)
We can Hard code a Time function by using this formula.
![](http://rishandigital.com/wp-content/uploads/2022/11/fi16.jpg)
https://youtu.be/fVZSJ2qbY5Y?list=PLdJ-6ssiefOANBnrdDKexSb_jBk88PFeh