I broke my flow and I cannot figure out why!! (Form Approval with attachment)

@Susan Fioribello
all error fixing starts with the error itself.

First is to ensure your run did happen when the form is submitted, if the flow has no run history, then you want to make sure your form ID is updated on the trigger step and the “get response” action. (when you “move” a form from user to group, i don't remember if that will change the form ID or not)

Form ID highlighted in yellow (when you get the URL from the browser location bar when designing the form).

https://forms.office.com/Pages/DesignPageV2.aspx?origin=NeoPortalPage&subpage=design&id=ExA3u5aBcDEfoooooooooo0000000000ooooooooooVUMFRXMkY4V0dVQjJSV1A3SzNWUzJTT1lDUyQlQCN0PWcu

If flow does trigger (have a run history) check the action that failed and see what the error message is to determine what needs to be done. (if the flow failed at the Parse JSON action, your create share link action will not execute, see the Parse JSON action to see what the error is)

@Susan Fioribello
new editor definitely has more issue that's unknown, so use old editor (the switch is on the upper right corner of flow window) like Austen said

However, the Apply to Each is “correct"ly placed by flow b/c a single question on form for uploading CAN allow uploading of more than 1 file, even when you can limit the question to allow only single file to be uploaded, FLOW connector action has to accommdate the potential “array” of file being uploaded.

The Parse JSON schema tells the flow that there is an array of file, so when you reference one of the field for the file upload (i.e. id) in your create share link action, flow will automatically place the action in an Apply to each for the array of files uploaded.

You can go one of 2 path:

• leave the Parse JSON as is (benefit is less change)
  • remove the dynamic content from the Create share link action and drag and move the action outside of the apply to each and delete the apply to each
  • in the dynamic content, put in this expression:
    first(body('Parse_JSON_Donation_picture_upload'))?['id']
• change the Parse JSON to only look at the first file of the upload question (benefit is to allow you to get all of the file upload property, including name, without using first() expression on all of them, and flow will never create a new Apply to each loop when you directly select the field for the file upload)
  • in the Content field of Parse JSON action, remove the dynamic content (which is the file upload question), and go to expression and type in first(), then put your text cursor between the paranthesis and go to dynamic content and select the file upload question
  • change the Schema to what I have below
  • remove the dynamic content from the Create share link action and drag and move the action outside of the apply to each and delete the apply to each
  • then directly select the id dynamic content from the parse json action

Schema to use if you select option 2 above:

{

"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": {}

}

}

@Susan Fioribello
bbdevdaytestuploadfilecreatesharelink_20240607180455.zip

decodeUriComponent(replace(body('Parse_JSON_Require_Single_File_Upload_First_File')?['link'], 'https://yourorgsharepointurl/teams/BusinessAutomation', ''))

expression used above will use the link dynamic content from the 2nd parse json and decode it to a path that can be used after replacing the initial part of the url that is the site address. This way you don't need to worry about knowing the folder path of where to find your uploaded file.

use the zip file to import and try it out