Posts

Showing posts from February, 2017

Expand and Collapse feature in PowerApps

Write the following on APP Start Code:

Clear(colTreeElement);  
 ForAll(
   TreeViewElement,
   Collect(
     colTreeElement,
     {
       ElmntName: Switch(
         'Element Name',
         "India",
         Concatenate(
           "India",
           "                                     ",
           "Score:4"
         ),
         "United States",
         Concatenate(
           "United States",
           "                             ",
           "Score:8"
         ),
         'Element Name'
       ),
       ElmntId: 'Element Id',
       Lv: Level,
       ParentId: 'Parent ID',
       //Add column 'Show' to control Expand/ Collapse
       Show: If(
         Value(Level) = 1,
         true,//only the element with spElmntLv = 1 is displayed in the initial state
         false
       ),
       TreePath: ""//Treepath is defined as
     }
   )
 );
 // …
go to top image