Hi, I would like to take a file, uploaded via Forms, and put it in a folder structure, defined by the Forms answer.
If folder does not exist, create one, if it does exist, add in existing.
E.g.:
Form_Q1: folder archive level 1
Form_A1: Comp A
Form_Q2: folder archive level 2
Form_Q2: Doc type 1
File upload: entry.pdf
Results in entry.pdf being archived in:
Site\Library\Comp A\Doc type 1\entry.pdf
Thanking you in advance for helping,
Solved! Go to Solution.
hi @DD2020 please follow this example
json
{
"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"
]
}
}
Proud to be a Flownaut!
hi @DD2020 please follow this example
json
{
"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"
]
}
}
Proud to be a Flownaut!
Thank you @ChristianAbata
I have copy/paste the syntax for "parse JSON", as in your message.
Get the following error (xxxxxxx replaces real names):
InvalidJSON. The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value 'file u[{"name":"12345_xxxxxxx.pdf","link":"https://xxxxxxx/xxxxxxx/xxxxxxx/Documents/Apps/Microsoft%20Forms/xxxxxxx/Question/12345_xxxxxxx.pdf","id":"01C5SL7SHKAW2S6GOSBZGKYI5UNORZFLP3","type":null,"size":52007,"referenceId":"01C5SL7SCSKTFAQD2GJRD2JFDJ6ZHJTHLS","driveId":"b!7eD4K1I0Pk2sbq3M3b0N0ZWTag5ZinFAqWfQ1Kzpfqy2R39XMKJHRpG8SSSY1kmn","status":1,"uploadSessionUrl":null}]' cannot be parsed: 'Error parsing boolean value. Path '', line 1, position 1.'.
???
you can generete your schema follow this example please 😉
Proud to be a Flownaut!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
40 | |
36 | |
28 | |
27 | |
27 |