Most Frequently used formulas in Power Apps

First we need to create a SharePoint list.

Open a Make.powerapps.com

Click on Create. Strat from blank app Create a blank “Canvas App”

Next Click on skip

Take a data from shown in the below screenshot

We need to add Data Source i add my SharePoint list to Canvas app as shown in the below

After that i have write code as below.

DefaultSelectedItems:-Current User

Displaymode:-Disabled

U need to add this formula in the main screen of “Form”

ResetForm(Form1);Set(

CurrentUser, {

‘@odata.type’: “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser”,

Claims: “i:0#.f|membership|” & Lower(User().Email),

Department: “”,

DisplayName: User().FullName,

Email: User().Email,

JobTitle: “.”,

Picture: “.”

}

)

To save the form i have a written a code in save button

Set(ImageBinaryRaw, JSON(UploadedImage1.Image , IncludeBinaryData));

Set(ImageBinary,Mid(ImageBinaryRaw, Find(“,”, ImageBinaryRaw)+1, Len(ImageBinaryRaw)-Find(“,”, ImageBinaryRaw)-1));

If(!IsBlank(DataCardValue1.Text),Patch(‘Sales List’,Defaults(‘Sales List’),{Title:DataCardValue1.Text,’Quantity Required’:DataCardValue5.Text,Bookmark:DataCardValue4.Selected,Condition:DataCardValue6.Selected,Manufacturer:DataCardValue7.Text,Owner:DataCardValue2.Selected,’Photo (Photo0)’:Substitute(JSON(UploadedImage1.Image,JSONFormat.IncludeBinaryData),””””,””)});

If(SubmitForm(Form1),Navigate(scrveiwlististing,ScreenTransition.Fade)),Notify(“Please enter requried fields”,NotificationType.Error))

i have add a new screen to the app to add gallery to get the data from “SharePoint” list we add to the form in the “Canvas App”

i have add the text label and icons to the gallery.

i will provide u step by step formula.

select icons and update formulas.

Icons->Bookmark(filled)

Onselect-> if(ThisItem.Bookmark.Value=”No”,Patch(‘Sales List’,ThisItem,{Bookmark:{Value:”Yes”}}),Patch(‘Sales List’,ThisItem,{Bookmark:{Value:”No”}}))

Icon->If(ThisItem.Bookmark.Value=”Yes”,Icon.BookmarkFilled,Icon.Bookmark)

Icon->Checkbox

oncheck-> Collect(ColSale,ThisItem);Set(selectedCount,selectedCount+1)

onuncheck->Remove(ColSale,ThisItem);Set(selectedCount,selectedCount-1)

Display Mode ->If(Self.Value ||(Value(selectedCount)=3) ||(Value(selectedCount)=2) ||(Value(selectedCount)=1)|| (Value(selectedCount)=0),Edit,Disabled)

we need to take new screen and add a gallery in data source

We can test in the View list my selecting the two check list in the Screen .we can click compare button.

Compare button:- Navigate(scrcomparescreen,ScreenTransition.Fade)

When we click compare button we can see the data on next screen on Compare screen.

Next i add a new Screen to check the details on the gallery create indusial persons detailsin another screen.

Open the view list screen select the “Tittle” and given this formula in Action

Html Text-> “”&ThisItem.Title&””

onselect-> Set(Selecteditem,ThisItem);Navigate(ScrViewdeatils,ScreenTransition.Fade)

Onvisible->Set(
CurrentUser, {
‘@odata.type’: “#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser”,
Claims: “i:0#.f|membership|” & Lower(User().Email),
Department: “”,
DisplayName: User().FullName,
Email: User().Email,
JobTitle: “.”,
Picture: “.”
}
)

Requested by->Patch(‘Sales List’,Selecteditem,{‘Quantity Required’:Value(DataCardValue13.Text)-Value(txyrequriedquantity.Text),’Required Quantity’:Value(DataCardValue8.Text)+Value(txyrequriedquantity.Text)});

Patch(‘Approve Request’,Defaults(‘Approve Request’),{‘Quantity Requried’:txyrequriedquantity.Text,’Requested By’:CurrentUser,NewitemID:Text(Selecteditem.ID),Title:Selecteditem.Title,Approver:Selecteditem.Owner,’Approve Status’:”Waiting for Approval”});Navigate(scrveiwlististing,ScreenTransition.Fade)

When i Required quality 10 and Request quantity will update 15 Quantity required 25