Power App Samples

-

Articles:

Understanding Power Apss

https://tejasadventure.blogspot.com/2020/05/power-apps-understanding.html

Field Controls

https://tejasadventure.blogspot.com/2019/11/power-apps-field-controls.html

Cascading dropdown - Power Apps - How to implement

Connect to Office 365 Outlook

https://tejasadventure.blogspot.com/2019/11/connect-to-office-365-outlook-from.html

Expense Tracker App: Steps for implementation

https://tejasadventure.blogspot.com/2020/05/monthly-expenses-tracker-canvas-app-in.html

Project Management App: Steps for implementation

https://tejasadventure.blogspot.com/2020/06/project-management-app.html


Power App using Excel data

https://tejasadventure.blogspot.com/2019/11/power-app-using-excel-data.html

Applying patch method to save


Patch('Project Details',LookUp('Project Details',ID = Gallery1.Selected.ID),{PMAssignedStatus:TextInput1.Text});Navigate(ViewProjects)

TemplateFill:

If (ThisItem.IsSelected=true, Orange, White)

All items view:


With Search filter
Items: 
SortByColumns(Filter('Project Details', StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

I have a list of items and wanted to show "Order as string and value of the label."
"Order "&ThisItem.Customer.Company
or
"Order "&ThisItem.Company :- Incase we are fetching from the current scope.

Refresh Icon:

Refresh('Project Details')

Sort: Desc or Asc

UpdateContext({SortDescending1: !SortDescending1})

Add Icon:

NewForm(EditForm1); Navigate(UpdateDetails, ScreenTransition.None)

Back Icon:

Navigate(SelectTask, Fade)

Switch

Switch method usage:
In a list gallery, I have status field "Invoiced", "Shipped", "Closed". Now I want to show each one in one color.

Switch(ThisItem.'Order Status',  'Order Status'.Closed, Green, 'Order Status'.Invoiced, Red);

Comments

Post a Comment

Popular posts from this blog

Powerapps overcome 2000 item limit from any datasource

-
First go through delegation concept https://tejasadventure.blogspot.com/2020/05/power-apps-understanding.html In powerapps, we observe by default 500 item limit has set with in the app level for any data source. In order to overcome, we have option to set the limit of 2000 item limit maximum in the app. Now using code, MaximoFacility is my data source name contains 3000 items. ColFacilityDropdown is the collection storing the count of items from data source. We expect to see more than 2000 items. Based on StartWith function filtering the data with respective to the charectors and numbers as mentioned below. Code: Place the below code in a button on select property. Add label with code CountRows(ColFacilityDropdown) ClearCollect(ColFacilityDropdown,Filter(Filter(MaximoFacility, Status = "ACTIVE"), StartsWith( Title, "A" ))); Collect(ColFacilityDropdown,Filter(Filter(MaximoFacility, Status = "ACTIVE"), StartsWith( Title, "B" ))); Collect(ColFacilit...
Read more

PowerApps multiselect cascading dropdown and save an item to SharePoint List

-
Image
 I have one scenario as below List 1: Division List has title field List 2: District List has Title and Division Field(LookUp from Division List) List 3: Facility List has Title, District Field(LookUp field from District List) List 4: County List has Title, Facility Field(LookUp field from Facility List) Main List: Spill Report is the main list  Division Field( Look up from Division List) District Field(Look up field from District List) Facility Field(Look up field from Facility List) County Field(Look up field from County List) List Screenshots provided below can be refered for clarification. ----------------------------------------------------------------------------------------------------- PowerApps Canvas Apps In Power Apps Canvas App, We need to first design the app with the 4 respective fields Since those fields are multiselect, then it is to combo box. Generally power apps are not supported for multiselect cascasding dropdown. Refere microsoft documentation, Know Limit...
Read more

Multi select cascading dropdown in Power Apps

-
Image
  Left(Concat(ColDivisionSelectedValues, Title & ";"),Len(Concat(ColDivisionSelectedValues, Title & ";")) -1) Plus icon Set(_popup,true); Set(DivisionGalleryViewing,true); Set(DropdownName,"Division"); Gallery Division: SortByColumns(ColDivisionDropdown, "Title") Check box OnCheck: Collect(ColDivisionSelectedValues, ThisItem) OnUnCheck: Remove(ColDivisionSelectedValues,ThisItem); Remove(     ColDistrictSelectedValues,     Filter(         ColDistrictSelectedValues,         Division.Value = ChkBoxDivision_1.Text     ) );
Read more