Beginning at contract renewal (no sooner than August 1, 2024), all school tenants will receive 100TB of free pooled storage. Microsoft 365 and Office 365 A3 and A5 customers will get an additional 50GB and 100GB of pooled storage per paid user, respectively. New storage tools will provide greater visibility into your pooled storage and help you better manage storage across services. Effective Feb 1, 2024, Office 365 A1 free users will have a maximum limit of 100GB OneDrive storage.
Step 2. Create a form to collect students’ records.
Step 3. Create a Power Automate flow, which is triggered by the submition action in this form. The flow looks as foolows in the New desiner interface:
Step 3. Create a Power Automate flow, which is triggered by the submition action in this form. The flow looks as foolows in the New desiner interface:
It looks like this in the old interface.
It looks like this in the old interface.
Here is the detailed instruction to fill in the fields.
Before adding Step 3, save the first two step of the flow and run the Test. Upload any mp4 file through the form and wait untill the flow will be successfully completed. Click the icon of the second step and put the cursor at the beginning of the field including the upload data. Press "Ctrl+A" to select the whole content of this field, and then press "Ctrl+C" to copy it to the buffer. This will be used as a sample in the third step. Now turn in the edit mode and add the "Parse JSON" action. The content field must be filled with the "Upload you ..." icon, and the schema is obtained by presing the "Generate from sample" button and inserting the content of the buffer to the obtained new field with "Ctrl+P" key combination.
Power Automate in a new design
Please, notice that in the new design of the Power Automate Studio users cannot get a correct schema in the Parse JSON step of this flow. The reason is that there is only the output for the body field of the second step flow output. It includes the required data inside and one cannot extract them using the body copy as a sample. Microsoft has restricted the number of turns back to the old interface. The only way to create this flow is to copy the correct JSON Schema from old flows. You can find the first part of tis Schema on the left. The second part with overlapping is shown below.
Power Automate in a new design
The part, which is ended with "status": {
is present in the first section of the Schema above. Please, do not try to generate this Schema inside the new interface. Just copy the correct schema and insert it into the schema window of the Parse JSON step. If you can stay in the old design, then do this. In this case you will get a field of the upload file, can copy it and use as a pattern for the Parse JSON schema. In any case, the schema given can be directly inserted in the schema field. Just copy it as the text below and insert in the main field of the Parse JSON step.
{ "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string" }, "link": { "type": "string" }, "id": { "type": "string" }, "type": {}, "size": { "type": "integer" }, "referenceId": { "type": "string" }, "driveId": { "type": "string" }, "status": { "type": "integer" }, "uploadSessionUrl": {} }, "required": [ "name", "link", "id", "type", "size", "referenceId", "driveId", "status", "uploadSessionUrl" ] } }
The full Schema can be copied from above.
It is important to notice that only the first "Get file content" is an OneDrive (Business) action. The other two actions are taken within the "OneDrive" conector.
Expand the “File Name” field to the “f_x” editor window, choose the “concat” function and insert between the paranthesis the icons of “Display Name”, “Submit time”, and ‘.mp4’ separated by comas.
It turned out that the "Get file content" action in "OneDrive for Business" has a restriction for files in 500 Mb. Therefore, if a screen recording exceeds this limit, then the flow fails. To overcome this difficulty, I recommend to slightly change this flow.
I insert the "Condition" action which checks if the "size" of the file is less than 534288000 bytes or not. If the answer is "Yes", then flow runs as shown above. Otherwise, the Excel table is filled in a different way, not as in the picture shown below.
The text in the "Name" filed is corrected with the "concat" function, and the "UploadPersonal" field is filled with the "link" icon. See the formula with "concat" below.
This picture shows the flow in the new interface. The flow is ready and can be tested.
Create an application to open recordings both from the Personal OneDrive and the corporative OneDrive. This application has two screens: the main screen for the gallery
and the second screen for the details. You navigate to the details screen through the black arrow in the orange square.
The filtering option is standard.
Clicking the green field assigns the variable “SelectGalleryItem” the value from the corresponding row in the Excel Table.
Both buttons are connected to the upload fields of the table, which open the corresponding recording.
Using this application an educator can keep students’ recording in the Business OneDrive for 7 days or even less, and for up to 30 days or more in the Personal OneDrive. After that the recordings are removed by Power Automate flows.