Settings:
List Settings ->Advanced Settings-> List Experience -> New Experience.
List Settings ->Form Settings ( to delete a custom form or use InfoPath).
To use Enhanced Formula Bar -> Settings -> Advanced Settings -> Enhanced formula bar Set to On
To make your Screen Responsive Settings -> Screen size and Orientation -> Scale to fit: off -> Lock aspect ration: off
Add Subheading in your form

Change a field DisplayMode by User:
If(User().Email = “support@tshirtsoho.com”, Edit, View)
Set a color property for a label,
color = ColorValue(“#66CB32”) – set color one time
use it
other Label fill:
fill = ‘L_Kavasaki Green’.Color’ – use it in many places (update only color)
Show selected Item in Gallery:
add a rectangle to item and set to Visible=ThisItem.IsSelected
Labels
-show a dropdown value:
“Status: ” & StatusDropdownValue.Selected.Value
Buttons
add a button outside a form.
Submit Button
onSelect = SubmitForm(Form1)
Cancel Button
Navigate(scrGallery, ScreenTransition.Cover)
or
ResetForm(frmName);
Back()
Reset Button
Reset(Dropdown_Cities); Reset(Dropdown_States);
or
ResetForm(Form1);
Refresh – for testing – Refresh(DataSourcename)
Check If Something Is True Or False
“If(CheckIfSomethingIsTrueOrFalse, TrueDoThis“
“If(CheckIfSomethingIsTrueOrFalse, TrueDoThis, FalseDoThis“)
If(
CheckIfSomethingIsTrue, TrueDoThis1,
CheckIfSomethingElseIsTrue, TrueDoThis2,
FalseDoThis“)
Lower(User().Email) = Lower(“Support@tshirtsoho.com”) Or Lower(“somebody@tshirtsoho.com”)
then use the varname everywhere, do not check on user many times.
visible a button if Lookup value in not blank (true)
!IsBlank(LookUp(SetCurrentUserAdmins, Title = varUserEmail).Title)
!IsBlank(LookUp(SetCurrentUserAdmins,Title=varUserEmail And Department=”Design”).Title)
Formatting Functions
Value() – converts a string of text that contains number characters to a number value.
DateValue, TimeValue, or DateTimeValue – convert date and time values to a number value
Text() = Converts any value and formats a number or date/time value to a string of text
Text(Value(ThisItem.Revenue), “[$-en-US]$ #,###”)
or
If(IsBlank(ThisItem.’Gross Obligations’),”” ,”$”&Text(ThisItem.’Gross Obligations’, “[$-en-US]0.00”))
Format Calculated Values
“$” & Round(Value(Parent.Default), 2)
Date Time functions
Fix given date 2001,12,31
Click the dateValue and change the InputTextPlaceholder property from
If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language))
to
If(IsBlank(Self.SelectedDate), Today())
show list items only the one that the user created
– set the text box visible = false
Navigate to Detail Screen
On Gallery screen
set the DataSource to the List
Set the onSelect = Set(record, ThisItem) or Select(Parent);Navigate(scrDetailEmail, ScreenTransition.Fade)
On Detail screen
set the DataSource to the List
set the Item to Selected Gallery Item
Item = GalleryForEmail.Selected
Check formMode
If(EditForm1.Mode=FormMode.Edit,”Edit Form”, “New Form”)
Fix the
on frmNew isVisible – Set(varNow, Now())
Lable:
& “Now: ” & varNow
& “Today: ” & Today()
“TimeZone Offset in minutes: ” & TimeZoneOffset(Today())
“Now in UTC format: ” & Text(Now(), UTC)
“Text ” & Text(Today(), DateTimeFormat.ShortDate) & ” – ” & Text(Now(), “[$-en-US]dd/mm/yyyy”)
add a link on form,
have a list item that is url, insert an “html text”, build your link
“<a href='” & DataCardValue5.Text & “‘> Link</a>”
Allow Empty Selection for dropdown list in a canvas app
Have the dropdown box selected -> advanced->Data ->AllowEmptySelection = true
Get Values from Input boxes:
Text = DataCardValue.Text
Number from text : Value(DataCardValue.Text)
Date = TimeValue(DataCardValue.Selected.Value)
Date = Text(DataCardValue5.SelectedDate, “[$-en-US]d mmmm yyyy”)
Get Email from People picker field
Concat(
‘by name’.Email,
Email,
“; ”
)
Concat(
AzureAD.GetGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX").value,
mail & ";"
)
Concat(
Office365Groups.ListGroupMembers("167cb604-XXX-44c1-XXX-e484dd766XXX", {'$top': 999}).value, // specify 999 for the '$top' attribute
mail & ";" )
get the https://url/sites/site/_api/Web/SiteGroups/GetByID(13)/users
Format a column to make an edit link out of it.
[code] {"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"txtContent": "@currentField",
"attributes": {
"target": "_blank",
"href": "=’/sites/dev/DocumentsCollectFeedback/Forms/EditForm.aspx?ID=’ + [$ID]"
}
}
[/code] [code] Set(varUser,User());
Set(isUserAdmin00AinList, !IsBlank(LookUp(AllBudget_Admin, Admin.Email=varUser.Email && ORG.Value="SEA 00A")));
Set(varIsUserMemberofBudgetO365group, varUser.Email in Office365Groups.ListGroupMembers("71b8d878-224d-4b31-b195-8d3b8f01180f").value.mail);
[/code]Add an Icon:
1. add the first icon from insert -> Icons.
2.Click on the icon and from the Properties do a search for your icon.
Add a PowerApp to a page:
by Id
or
<iframe width="1024px" height="768px" src="https://apps.high.powerapps.us/play/78ac29e6-eda7-473c-81d0-ad4efc563ab2?tenantId=74cf14f4-38e0-460b-9d96-c0a51cb4a55c"></iframe>
[/code]Print
video: https://www.youtube.com/watch?v=JMhVtII5hQs
or
Not(Parent.Printing)
[/code]
Get the records for a dropdown compare two lists get only items where no matching data found.
[code]Filter(
db_Lookup,
Not(
Title in Filter(
list_db,
‘colname’ = = varGlobsomevalue
).’columnameForDropdown’
)
)