Power Platform Community Forum Thread Details

Trying to pull contents from Excel table row (automatically created upon MS Form submission) into a SharePoint list

Getting a very wordy error message as I'm trying to pull data from an Excel table row (automatically created upon MS Form submission) into a SharePoint list I created. (I decided to try this route instead of recreating what I want using a Flow; MS Forms automatically adds data to the Excel table (in an Excel file), so.. why not just steal the data I want from it, right?)

In the Excel table created by MS Forms, hyperlinks are provided when an attachment is submitted (the hyperlink goes to where MS Forms stores the attachment(s) in SharePoint: Shared Documents > Apps > Microsoft Forms, etc.) (great!)- What I'm trying to do is grab those attachment hyperlinks and add them to my SharePoint list under the appropriate column. And that's where I'm having issues.

My Flow seems to work up until it's time to add any Attachment hyperlinks to my SharePoint list. Note: The MS Form includes "branching," so required fields (and attachments) not involved in the submission will be blank.

My Flow: When a MS Form response is submitted, I get response details, get the excel worksheets, get excel tables, and list rows present in a table (I dunno what I need, so I grabbed it all..) I created a "Compose" action as a first step to grabbing the hyperlink (should it exist) for each potential place in the Form one could have been submitted. Not sure what the next step is to add it to my SharePoint list.

My error message: "The 'inputs.parameters' of workflow operation 'Create_item_-_Add_form_responses_to_SharePoint_list' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Upload_x0020_the_x0020_revised_x' is required to be of type 'String/uri'. The runtime value '"[{\"name\":\"Revised Photo-Bonnie_Bonnie Denham 7.jpg\",\"link\":\"https://{doc library path}/Shared%20Documents/Apps/Microsoft%20Forms/Change%20Request%20Form/Question%201/Revised%20Photo-Bonnie_Bonnie%20Denham%207.jpg\",\"id\":\"01EMKUZ32KDSDIKOI5SZFZQBU34UTXLVK7\",\"type\":null,\"size\":193359,\"referenceId\":\"01EMKUZ35U7OAW357JRZEIZXSI44BQ4OQH\",\"driveId\":\"b!DnhdaXf5vE2LsZvREPSc0QpASom9bYtHpQFscigyc4cr79NzW2VjQpmzPo-J9X1H\",\"status\":1,\"uploadSessionUrl\":null}]"' to be converted doesn't have the expected format 'String/uri'."

Screenshot 1.png Screenshot 2.png Screenshot 3.png Screenshot 4.png Screenshot 5.png