Alex Joh's Blog

Introduction I tried show data from Filter, but having hard time to display this data to text or label box. This will show you how to do it. Error: Property expected Text values, but this rule produces incompatible Table values The return result from Lookup, Filter or Search is table type and this can't be diplayed directly to the text or label box. To show this you will need to specify the record which you want to display. First/FirstN/Last/LastN function The First function returns the first record of a table. The FirstN function returns the first set of records of a table; the second argument specifies the number of records to return. The Last function returns the last record of a table. The LastN function returns the last set of records of a table; the second argument specifies the number of records to return. First and Last return a single record. FirstN and LastN return a table, even if you specify only a single record. Defining data using ClearCollect ClearCo...

Introduciton To show the list of dropdown, the data should be defined in advance by static or from somewhere such as DB or rest. Collect, Clear, and ClearCollect function There are three functions in Powerapp related to defining and clearing data Collect: This will add list to existing data whenever it is called. Clear: Reset data ClearCollect: This is combination of Clear and Collect. This will reset existing data and will add new value Defining data for dropdown Add dropdown to the canvas Click advanced from properties Define list of data at "OnSelect" function ClearCollect(ItemDropdownList, "Item1", "Item2", "Item3") Link the List to dropdown list from "Items" Textbox ItemDropdownList Dropdown result Summary This is most simple way to show dropdown list and if you use UpdateContext or other functions, you can poplulate data from REST API.