How to upload Powerapps Audio into sharepoint?

[PavanKumar]

Problem: Recently I have a requirement to upload recorded audio from powerapps to sharepoint.

Requirements seems to be straight forward if you have a basic knowledge of Powerapps and Microsoft flow isn’t it? But there is a catch (let’s see that in sometime :-))

Just for the completeness of this blog, I will reiterate certain Hows.

How to Record and listen the Audio in powerapps?

In powerapps we have a media control named MicroPhone to record the audio, and another media control named Audio to listen to the recorded audio.

Further on how to do that:

In the Microphone control (I named as MyMic) Onstop property collect the recorded audio as follows:

ClearCollect(collInspectionAudio, MyMic.Audio);

In the Audio Control Media property, place the collection which you have used to collect the recorded audio earlier as follows:

First(collInspectionAudio).Url

We now know how to record and listen the audio within powerapps. Now lets discuss the actual challenge on how to upload it to sharepoint.

Analysis

We use Microsoft flow to upload to sharepoint however in my microsoft flow it looks straight forward to pass the audio as First(collInspectionAudio).URL to my sharepoint file content as shown below.

when I execute the Powerapps and hence my flow it is creating an audio file in my sharepoint, however its not playing. when I see the outcome of the Flow i found it strange because File content looks as below:

When I further drilldown into the problem by checking the datatypes in flowstudio. I realized that in Createfile action of Sharepoint connector expects Binary format whereas powerapps send its audio content in byte format.

Solution:

So the only way to get around is accept Byte parameter from Powerapps and use it to upload file in sharepoint.

For that, I used Outlook connector  to send an email. When I ask for attachment parameters in powerapps it can send in byte format.

Note: If you have a requirement to send email of the audio file along with uploading in sharepoint then that’s amazing. If you don’t have such emailing requirement then another slight hack is required.

1.  Create a condition which never becomes true. (in my case 100 equals 200 which never becomes true ;-))
2. In the true section call Outlook connector and ask for parameters for Attachment Name and Attachment Content.
3. In the false section call Sharepoint Connector and create a file by using same parameters which we have in Step 2.

Final working Microsoft Flow looks like this:

Warm Regards,

For any doubts or questions, please contact me on pavankumar88.garlapati@gmail.com

Pavan Kumar Garlapati

Follow my Blog: https://pavankumargarlapati.wordpress.com

[kelomee]

Hi PavanKumar, this is perfect only if you use or run PowerApps on your PC but how can you save recorded audio from Mobile devices?

[PavanKumar]

Hi @kelomee ,

This option works for both Web and devices. Please elaborte what challenge are you facing to answer it.

Regards,

Pavan Kumar Garlapati

---

@PavanKumar wrote:

Problem: Recently I have a requirement to upload recorded audio from powerapps to sharepoint.

Requirements seems to be straight forward if you have a basic knowledge of Powerapps and Microsoft flow isn’t it? But there is a catch (let’s see that in sometime :-))

Just for the completeness of this blog, I will reiterate certain Hows.

How to Record and listen the Audio in powerapps?

In powerapps we have a media control named MicroPhone to record the audio, and another media control named Audio to listen to the recorded audio.

Further on how to do that:

In the Microphone control (I named as MyMic) Onstop property collect the recorded audio as follows:

ClearCollect(collInspectionAudio, MyMic.Audio);

In the Audio Control Media property, place the collection which you have used to collect the recorded audio earlier as follows:

First(collInspectionAudio).Url

We now know how to record and listen the audio within powerapps. Now lets discuss the actual challenge on how to upload it to sharepoint.

Analysis

We use Microsoft flow to upload to sharepoint however in my microsoft flow it looks straight forward to pass the audio as First(collInspectionAudio).URL to my sharepoint file content as shown below.

when I execute the Powerapps and hence my flow it is creating an audio file in my sharepoint, however its not playing. when I see the outcome of the Flow i found it strange because File content looks as below:

When I further drilldown into the problem by checking the datatypes in flowstudio. I realized that in Createfile action of Sharepoint connector expects Binary format whereas powerapps send its audio content in byte format.

Solution:

So the only way to get around is accept Byte parameter from Powerapps and use it to upload file in sharepoint.

For that, I used Outlook connector  to send an email. When I ask for attachment parameters in powerapps it can send in byte format.

Note: If you have a requirement to send email of the audio file along with uploading in sharepoint then that’s amazing. If you don’t have such emailing requirement then another slight hack is required.

1.  Create a condition which never becomes true. (in my case 100 equals 200 which never becomes true ;-))
2. In the true section call Outlook connector and ask for parameters for Attachment Name and Attachment Content.
3. In the false section call Sharepoint Connector and create a file by using same parameters which we have in Step 2.

Final working Microsoft Flow looks like this:

Warm Regards,

For any doubts or questions, please contact me on pavankumar88.garlapati@gmail.com

Pavan Kumar Garlapati

Follow my Blog: https://pavankumargarlapati.wordpress.com

---

---

@PavanKumar wrote:

Problem: Recently I have a requirement to upload recorded audio from powerapps to sharepoint.

Requirements seems to be straight forward if you have a basic knowledge of Powerapps and Microsoft flow isn’t it? But there is a catch (let’s see that in sometime :-))

Just for the completeness of this blog, I will reiterate certain Hows.

How to Record and listen the Audio in powerapps?

In powerapps we have a media control named MicroPhone to record the audio, and another media control named Audio to listen to the recorded audio.

Further on how to do that:

In the Microphone control (I named as MyMic) Onstop property collect the recorded audio as follows:

ClearCollect(collInspectionAudio, MyMic.Audio);

In the Audio Control Media property, place the collection which you have used to collect the recorded audio earlier as follows:

First(collInspectionAudio).Url

We now know how to record and listen the audio within powerapps. Now lets discuss the actual challenge on how to upload it to sharepoint.

Analysis

We use Microsoft flow to upload to sharepoint however in my microsoft flow it looks straight forward to pass the audio as First(collInspectionAudio).URL to my sharepoint file content as shown below.

when I execute the Powerapps and hence my flow it is creating an audio file in my sharepoint, however its not playing. when I see the outcome of the Flow i found it strange because File content looks as below:

When I further drilldown into the problem by checking the datatypes in flowstudio. I realized that in Createfile action of Sharepoint connector expects Binary format whereas powerapps send its audio content in byte format.

Solution:

So the only way to get around is accept Byte parameter from Powerapps and use it to upload file in sharepoint.

For that, I used Outlook connector  to send an email. When I ask for attachment parameters in powerapps it can send in byte format.

Note: If you have a requirement to send email of the audio file along with uploading in sharepoint then that’s amazing. If you don’t have such emailing requirement then another slight hack is required.

1.  Create a condition which never becomes true. (in my case 100 equals 200 which never becomes true ;-))
2. In the true section call Outlook connector and ask for parameters for Attachment Name and Attachment Content.
3. In the false section call Sharepoint Connector and create a file by using same parameters which we have in Step 2.

Final working Microsoft Flow looks like this:

Warm Regards,

For any doubts or questions, please contact me on pavankumar88.garlapati@gmail.com

Pavan Kumar Garlapati

Follow my Blog: https://pavankumargarlapati.wordpress.com

---

[kelomee]

Thank for your reply Pavan.

Actually I have done the technique/approach you've shared. 

I managed to convert the binary format (base64) into a playable .mp3 file and attached tru email. This worked perfectly when you use desktop browser only.

Running the app using the mobile device also worked fine in creating a file and attach tru email BUT the file attached or created CAN NOT be played by any Audio Player.

THis is the URL created by iPhone (not a binary / base64 format)

temp/recording_06623689-E5BB-486B-B530-886ED63D1902-561-00000035DC1838E8.aac

If you manage to play .aac file created by IOS, please let me know.

Thank you.

By the way, I have posted my issue in this thread, you might want to take a look what others in the community says. 

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/How-to-save-a-recorded-audio-from-IO...

Regards

Kelo

[js_]

I have a similar issue. I can Base64 encode the audio when I run it on my laptop. On iPhone my app just doesn't work. It shows the same kind of relative path instead of the Base64 string.