{"id":32945,"date":"2022-10-29T17:20:13","date_gmt":"2022-10-29T11:50:13","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=32945"},"modified":"2022-11-02T17:17:09","modified_gmt":"2022-11-02T11:47:09","slug":"how-to-use-firstn-lastn-and-index-functions-in-canvas-apps-power-fx-on-power-platform","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/10\/how-to-use-firstn-lastn-and-index-functions-in-canvas-apps-power-fx-on-power-platform\/","title":{"rendered":"How to use FirstN(), LastN(), and Index() functions In Canvas Apps (Power Fx) on Power Platform"},"content":{"rendered":"

Introduction<\/h2>\n

In today\u2019s blog, we will explore how to implement FirstN(), LastN(), and Index() functions for filtering records of the Data Table in the Canvas App.
\nWe had a client requirement where we needed to find out the top three highest Annual Revenue customers and bottom three lowest Annual Revenue customers for boosting their business.
\nTo achieve the above requirement, we used Canvas App. Please find the below steps that we used to get the desired results:<\/p>\n

Step 1:<\/strong><\/p>\n

We created a default Canvas App and in that, we added a DataTable. After creating the data table, we added the Client custom table in it which contains customer details such as Name, and Annual Revenue. As seen in the below screenshot. Also, we sorted the data in descending order based on annual revenue using the Sort function. Please find the below Power Fx formula that we used to sort the Data Table:<\/p>\n

Sort(Clients, Revenue, Descending)<\/strong><\/p>\n

\"Power<\/p>\n

\"Power<\/p>\n

Step 2:<\/strong>
\nAfter sorting the data table by annual revenue, we performed the below operation:
\n1. FirstN()<\/strong>
\nThe FirstN() function returns the first N set of records of a data table.
\nSyntax:<\/strong>
\nFirstN(TABLE_NAME,NUMBER_OF_RECORDS)<\/strong><\/em>
\nWhere,
\nTABLE_NAME: Table name is specified on which we perform the operation
\nNUMBER_OF_RECORDS: Numeric number which specified how many rows we want to retrieve from the data table.
\nIn our case, we want to retrieve the Top three customers which have the highest annual revenue. So, we create the Power Fx formula as below:
\nFirstN(Clients,3)<\/strong>
\nAfter applying the Power Fx formula, we will get the below result in the data table. You can see the top three customers which have highest annual revenue displayed in the screenshot:<\/p>\n

\"Power<\/p>\n

2. LastN()<\/strong>
\nThe LastN() function returns the last N set of records of a table
\nSyntax-<\/strong>
\nLastN(TABLE_NAME,NUMBER_OF_RECORDS)<\/strong><\/em>
\nIn our case, we want to retrieve the Last three customers which have the lowest Annual revenue. So, we create the Power Fx formula as below:
\nLastN(Clients,3)<\/strong>
\nAfter applying the Power Fx formula, we will get the below result in the data table. You can see the lowest three customers having the lowest annual revenue displayed in the screenshot:<\/p>\n

\"Power<\/p>\n

3. Index()<\/strong>
\nThe Index function returns a single record of a data table based on its ordered position in the table.
\nSyntax:<\/strong>
\nIndex(TABLE_NAME,NUMBER_OF_RECORDS)<\/strong><\/em>
\nExample:
\nIndex(Clients,3)<\/strong>
\nOutput-<\/p>\n

\"Power<\/p>\n

Conclusion<\/h2>\n

In this way, using FirstN(), LastN() ,and Index() function we can easily filter the data table in Canvas App.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction In today\u2019s blog, we will explore how to implement FirstN(), LastN(), and Index() functions for filtering records of the Data Table in the Canvas App. We had a client requirement where we needed to find out the top three highest Annual Revenue customers and bottom three lowest Annual Revenue customers for boosting their business.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2361],"tags":[1988],"class_list":["post-32945","post","type-post","status-publish","format-standard","hentry","category-technical","tag-canvas-apps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=32945"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/32945\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=32945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=32945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=32945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}