Upload Files From Power Apps To SharePoint Document Library Using Power Automate Flow

Click on attach the file on the attachment control and attach a file ex: Doc File and click on the button.

As displayed in the above picture it is converted, but we need to remove the extra text from the converted JSON Binary data, till Base64 and the inverted commas at the end.

OnSelect property of the button,

Set(VarAttachmentControl,JSON(Image1.Image,IncludeBinaryData));
Set(VarBase64Only, Mid(VarAttachmentControl,Find(",",VarAttachmentControl)+1, Len(VarAttachmentControl)-Find(",",VarAttachmentControl)-1));

Step 2

The next step is to create a Power Automate Flow with a trigger from Power App and attach the file in the SharePoint Document Library. For this open Power Automate Flow

Open My flows and we will create a new flow.

Select Instant cloud flow, it will trigger the following screen.

Name the flow as attach file in the Flow name box and click on Create,

Add new step and search for Create File,

Click on the Select folder.

Add the path for Shared Documents.

File Name- Create File Name

File Content- File Content - base64ToBinary(triggerBody()['Createfile_FileContent'])

To create a file, you need to enter the file name and file content in Power Apps.

For file content wrap the ask from Power App variable in base64tobinary expression i.e. base64ToBinary(triggerBody()[‘Createfile_FileContent’])

Add another button on the same screen in Power Apps and click on Action>> Power Automate >> Select the Flow to add. I will add the “Attach File” Flow in Power Apps.

Copy the same code in the previous button and add the below code to add the attachment.

On the Select property of the button, the code is as follows.

Set(varAttachmentcontrol, JSON(Image1.Image, JSONFormat.IncludeBinaryData));
Set(varBase64Only, Mid(varAttachmentcontrol, Find(",", varAttachmentcontrol) + 1, Len(varAttachmentcontrol) - Find(",", varAttachmentcontrol) - 1));
Attachfile.Run(Last(Attachmentcontrol.Attachments).Name, varBase64Only)

The code in OnSelect of the button, we can add on On Add property of the Attachment control, then the button will be no more required to add a file.

Conclusion

This is the authentic way to attach any file from Power Apps to SharePoint. In my next article, I will write how to update the ID of the SharePoint list in the Document library. I hope you enjoy working with me.

To know, How To Build An Interactive Dashboard Using Power BI please read this article. Thanks.