Saving microphone audio recorded in PowerApps into SharePoint library
Overview
Saving microphone audio recorded in PowerApps into SharePoint library has been discussed long time, but AFAIK there is no “low-coding” solution for this challenge.
Today, we have ability to convert images and audios to base64 string by using JSON function in PowerApps. (See here)
and here I summarized simple & low-coding solution for saving audio from Microphone to SharePoint Library using JSON and Flow.
NOTE: This approach only works well in PC browser, not mobile device.
PowerApps
First I assumed that there added 1 Microphone control, TextInput, and Button in my app.
TextInput is just used as file name, and button triggers Flow described later.
For Microphone control, set below function in OnStop property:
Set(tmpJson,JSON(MicrophoneAudio1.Audio,IncludeBinaryData));
Set(strB64Audio, Mid(tmpJson,25,Len(tmpJson)-25);
where IncludeBinaryData is key to convert Microphone audio into base64 string.
The remaining part Mid(...) is extracting base64-ed content from generated string.
Flow
Saving base64ed audio into SharePoint library is very simple and straightforward.
1. Initialize string variable using "Ask in PowerApps" with name "b64Audio"
2. Add Create file action of SharePoint connector with
- Filename : Ask in PowerApps
- Filecontent : base64ToBinary(variables('b64Audio'))
* Other parameters are your site and some document library which you want to store file.
Save flow with name "SaveAudio"
Ref: http://johnliu.net/blog/2017/7/building-non-json-webservices-with-flow
Back to PowerApps
We can now store microphone audio to SharePoint library.
Last, execute flow "SaveAudio" by select button:
OnSelect : SaveAudio.Run(strB64Audio,TextInput1.Text)
Check result
This provides you easy & low-coding solution to save microphone audio to SharePoint list.
You can apply this method for meeting note with recording or some fun apps :-)
Author And Source
この問題について(Saving microphone audio recorded in PowerApps into SharePoint library), 我々は、より多くの情報をここで見つけました https://qiita.com/h-nagao/items/d36e0ba5552cfe94ad07著者帰属:元の著者の情報は、元のURLに含まれています。著作権は原作者に属する。
Content is automatically searched and collected through network algorithms . If there is a violation . Please contact us . We will adjust (correct author information ,or delete content ) as soon as possible .