Power Automate - Workflows
- Jennifer Garvey
To edit the workflow you will need to sign in with the Campus Connections Office 365 account
Click the Power Automate app from the icons on the left
Click My Flows
Click Campus Connections Mentor Coach Application insert row...
When a new response is submitted to the CC Mentor App – Fall 2021 (this will need to be updated each cycle) MS Form.
The workflow Gets the response details
Next step in the flow is to Parse the data returned for each file upload in order to grab just the link to insert into the Excel spreadsheet (for easy access).
Here is the code which is embedded in each Parse JSON action
{
"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"
]
}
}
Output is selected from the previous steps (URL)
4. Final step is to Add a row into a table in the Campus Connections – Mentor Coach Applications.xlsx spreadsheet saved on OneDrive under the Campus Connections shared account.
If you have questions or issues with this Workflow, contact chhshelpdesk@colostate.edu.