1, Formula
1. Displays a record in which the start date of the Events table is the date selected in the calendar
copyFilter(Events,Text(start time,DateTimeFormat.ShortDate)=Text(_dateSelected,DateTimeFormat.ShortDate))
2. Jump to the page and pass the value
Navigate(Screen2,ScreenTransition.Cover,{thisdoctor:ThisItem})
3. Displays data with a start date of today
copyFilter(Events,Text(start time,DateTimeFormat.ShortDate)=Text(Today(),DateTimeFormat.ShortDate))
4. Cancel record
copyResetForm(Frm_ProjectDetailEdit);Back()
5. Keep records
copySubmitForm(Frm_ProjDetailEdit);Back()
6. Edit record
copyEditForm(Frm_ProjDetailEdit);Navigate(ProjectDetailEdit,ScreenTransition.Fade)
7. New record
copyNewForm(Frm_ProjDetailEdit);Navigate(ProjectDetailEdit,ScreenTransition.Fade)
8. Delete record
copyRemove(Project,LookUp(Project,title=GalleryProjectList.Selected.title));Back()
9. Calculate quantity
copyCountRows(Filter(HomeProjectList,Type.Value="newly build"))
10. Realize search function
copySortByColumns(Search(HomeProjectList,TextInput1.Text,"Title","ProjectName"),"Title",Ascending)
11. A Label displays the sentence, "n records, sorted by the latest update"
copyText(CountRows(Filter(Eļ¼vents,Text(start time,DateTimeFormat.ShortDate)<>Text(Today(),DateTimeFormat.ShortDate))),"[$-en-US]#Records, sorted by recent updates ")
12. When setting the text type, multiple fields can be spliced in this way
copyThisItem.'First Name' & " " & ThisItem.'Last Name'
2, Small skills
The canvas application jumps from the details of a main record page and displays all sub records of a record
1. When the first page jumps, onSelect passes this parameter_ event_ Attendees is a sub list of this record
Navigate(attendee ,ScreenTransition.Cover,{this_event_attendees:thisevent.event_attendees.event_attendee})
2. Add filter conditions to the item data of the gallery on the second page, as shown in the following figure
copyFilter(event_attendees,event_attendee exactin this_event_attendees)
The drop-down list of power apps canvas realizes linkage filtering
1. Properties of the first drop-down box (1) The data source of items is the parent table (2) The value of value is the name field of the parent table
2. Properties of the second drop-down box (1) There is a lookup field in the Doctors table associated with the Hospital parent table (2) Filter the Doctors sub table if the value of its lookup field associated table is equal to the corresponding value selected in the first drop-down box (3) The fields of filtered records to be displayed in the second drop-down box are written out at the end of the formula
copyFilter(Doctors,Text(Affiliated organization.hospital)=Text(Dropdown1.Selected.hospital)).Name of doctor
Jump operation value transfer
1. Using the Navigate formula, the value passed is defined as thislocator
Navigate(Screen2,ScreenTransition.Cover,{thisdoctor:ThisItem})
2. Another page receives this locator and displays some fields
Save recent browsing records
1. Add record to recent browsing collection (1) Add the following formula to the jump Icon (2) The first parameter of collect is the name of the newly defined collection
copyCollect(recently_doctor,ThisItem)
2. Show your browsing collection (1) In another recent browsing record interface, add a Gallery control and select the collection name from Data source
3. Clear recent browsing records (2)Recently_ Docs is the collection name defined above
copyClear(Recently_doctors)
4. power apps canvas to view the content of recent browsing records Open powerapps studio, click the file and select Collections button, and you can see it
3, Reference
Microsoft official document: reference formula of Power Apps https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
4, Summary
The above are some formulas and tips summarized when developing power apps canvas. They are relatively simple and you can refer to them