Thank you for visiting my site!

Home / PowerApps - Forms / Tips – Forms

Tips – Forms

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”)


Set a Global var next to App

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.
DateValueTimeValue, 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 Multi-line textbox ends up with <DIV> text in it
In the default property add: PlainText(Parent.Default)


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

[code]

<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


onIcon Visible

[code] !’scrname’.Printing // is false if is printing
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’
)
)

[/code]

 

 

ADD YOUR COMMENT