Skip to main content
Community site session details

Community site session details

Session Id : wX13aZ1jyEcmRpfnynY2X6
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 8 Mar 2022 05:55:19 by 39

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.pngScreenshot 2.pngScreenshot 3.pngScreenshot 4.pngScreenshot 5.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete