Power Apps Useful Link

PowerApps Community

https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

PowerApps Docs

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference

https://powerapps.microsoft.com/zh-cn/tutorials/getting-started/

https://docs.microsoft.com/en-us/powerapps/getting-started

UpdateIf

https://docs.microsoft.com/en-us/powerapps/functions/function-update-updateif

Update Choice field

https://powerusers.microsoft.com/t5/PowerApps-Forum/How-to-Save-Choice-field-value-using-UpdateIf-Patch-functions/m-p/28545#M12054

UpdateIf(PowerAppsForm, ID=DataTable1.Selected.ID,{Form_x0020_Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
   Id:1,
  Value:"Approved"}
})

PowerApps Submit form trigger Flow

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Update User Field

UpdateIf(PowerAppsForm, ID=DataTable1.Selected.ID,{Owner:{ 
  '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", 
  Claims:"i:0#.f|membership|" & Lower(User().Email), 
  Department:"", DisplayName:User().FullName, 
  Email:User().Email, 
  JobTitle:".", 
  Picture:"."}
})

http://www.codeovereasy.com/2017/07/powerapps-set-sharepoint-person-field-to-current-user/

https://community.powerapps.com/t5/PowerApps-Forum/Update-SharePoint-Person-type-column-using-SubmitForm-function/td-p/66040

https://powerusers.microsoft.com/t5/PowerApps-Forum/SharePoint-List-Update-Person-Field/td-p/6980

Patch

https://docs.microsoft.com/en-us/powerapps/functions/function-patch

Patching Sharepoint list from checkbox

https://community.powerapps.com/t5/General-Discussion/Patching-Sharepoint-list-from-checkbox/m-p/89145#M33728

https://powerusers.microsoft.com/t5/General-Discussion/Checkbox-Value-needs-to-Patch-or-UpdateIf-to-SharePoint-List/m-p/89147#M33730

Calling Microsoft Flow from your application

https://flow.microsoft.com/en-us/blog/call-flow-restapi/

Return data to PowerApps from a flow

https://flow.microsoft.com/en-us/blog/return-data-to-powerapps/

Return Array from Flow to PowerApps

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

Set user field in edit form

https://www.c-sharpcorner.com/article/set-default-value-to-person-or-group-field-in-powerapps/ "Default" & "DefaultSelectedItems" Property

{  
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",  
 DisplayName:User().FullName,  
 Claims:"i:0#.f|membership|" & Lower(User().Email),  
 Department:"",  
 Email:User().Email,  
 JobTitle:"",  
 Picture:""  
}

{  
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",  
DisplayName:LookUp(ApplicationInventory,'Application Name'= DataCardValue2.Selected.Value,ApplicationOwner.DisplayName),  
Claims:"i:0#.f|membership|" & Lower(LookUp(ApplicationInventory,'Application Name'= DataCardValue2.Selected.Value,ApplicationOwner.Email)),  
Department:"",  
Email:LookUp(ApplicationInventory,'Application Name'= DataCardValue2.Selected.Value,ApplicationOwner.Email),  
JobTitle:"",  
Picture:""  
}

New Model

If(Text(Form1.Mode)="1",{
  '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
   Claims:Concatenate("i:0#.f|membership|",User().Email),
   DisplayName:User().FullName,
   Email:User().Email
    }, 
ThisItem.PersonGroup)

Connect DB2

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-installhttps://powerusers.microsoft.com/t5/Building-Power-Apps/Help-connecting-IBM-DB2-database-to-powerapps/td-p/39975https://powerusers.microsoft.com/t5/Building-Power-Apps/Need-to-connect-to-a-DB2-database-How-to/td-p/331308/page/2

Server: XXXXX.YY.COMPANY.COM:446 Database: this should only be the server name ( i think the localname of the machine)