SharePoint & Power Apps Learning

 Switch(Param("Mode"), "New", FormMode.New, "Edit", FormMode.Edit, "View", FormMode.View )

  { "$schema" : "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" , "elmType" : "a" , "txtContent" : "View" , "attributes" : { "href" : "@currentField" , "target" : "_blank" } } dynamically bind the item ID to the URL: { "$schema" : "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json" , "elmType" : "a" , "txtContent" : "View" , "attributes" : { "target" : "_blank" , "href" : "='https://apps.powerapps.com/play/3fdd0765-2de4-44aa-a81c-7c424ff54ca5?Mode=Edit&ID=' + [$ID]" } }

  ( function  () {      function   registerRenderer () {          var   ctxForm  = {};          ctxForm . Templates  = {};          ctxForm . Templates  = {              Fields  :  {                  'ShiftTurnOverParentLink' :  {  //------ Change Hyperlink of LinkTitle                      View  :   function  ( ctx ) {                          var   url  =  ctx ....

In power apps SharePointform1 is the default Form created for SP List customization. In items property, If we are having a customization with query string paramenter ID, based on Item ID selected item should appear the list data in view/edit form. Code below items property: From query string param, selected data should appear in edit form. If(     Param("Mode") = "New",     SharePointIntegration.Selected,     If(         IsBlank(Param("ID")),         SharePointIntegration.Selected,         LookUp(             'Golden Hour Reports',             ID = Value(Param("ID"))         )     ) )

Scenario 1: I have a document library, User will upload the document to the document library, then it will trigger the MS flow, for approval. Here the document has to be added as attachment for approval. How to do, Step: In PA, Instant flow Step: "For selected file" Start and wait for approval: Approval type: Approve/Reject-First to respond Title: Invoice approval for <FileName> Assigned To: Koti Attachments Name-1 Select <fileName> Attachment Content-1: In order to get attachment content, Before- Add action name "Get file properties" and Select Site Address, Library Name, Id. This will give all the properties of the file. Next, we need to add "Get file content" action. Pick site address and file identifier: Select Identifier. This will give actual content of the file in base 64 formate. Now in "Start and wait for approval" action, attachment content-1: choose "File Content" Step: Condition: Outcome is equal to Approve Step:...

PowerApps upload multiple files attachment to SharePoint