Power Platform Community Forum Thread Details

my original post is not showing, so I am reposting..

What I'm trying to do now is upload a specific file to SharePoint and include it in a PowerApps/Flow Approval Process.

The business needs to start the business process from an Excel Template (which they have been using historically).

I've modified the template to launch the PowerApp and passed the filename (including path) into PowerApps.

Using VBA I have modified the template to encode the file to base64 and attempted to pass the encoded text as a parameter to PowerApps. I have found that there is a limitation on the length of the base64 string (about 1953 chr); when this is exceeded VBA displays a Runtime error=5 (Invalid procedure call or argument).

The other approach is to find a way to to use the Attachment Control to display the file so that I can have PowerApps convert the binary (via Image.Value) to base64 and pass it to Flow where I will convert it back to binary, save to SharePoint and then start the Approval Process. (I have successfully performed the base64 encoding, passed to Flow, convert to binary and saved to SharePoint).

If that's not possible, is there a was to have the Attachment Control open to a specific folderpath (which is being passed as a paramenter from Excel)?

thanks rc

Categories:

Building Power Apps