cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
asali7
Regular Visitor

Difficulty using Form data in file content when creating OneDrive file

Hi All,

 

I've created Flows in the past where I've obtained the response details from a Forms submission and used them as file content to create a .txt or .doc file with the response details as the content. I've used this same workflow in my other Flows without issue. However, in this specific instance, for each response the content of the file returns something along the lines of @outputs('Get_response_details')?['body/r7f85e2f85cde4cf08864b2e4e05ecfd3'] or similar for each question on the form. However, I can use the form responses to create the file name without experiencing any error. I've tried creating files in OneDrive and in SharePoint with the same results.

 

The only difference between this form and the forms I've used in other flows is that this form is a group form and not owned by me individually. As such, I've had to select "Enter custom value" from the drop down menu in the "When a new response is submitted" and "Get response details" steps and specify the form id as found after FormId in the form's URL. Would this cause a problem? If so, is there any solution? Other individuals need access to this particular form which is why I can't maintain sole ownership.

 

I've provided a screen capture of my flow. Any help is appreciated. I'm supposed to have this done by the end of business on Monday. 😕

 

Annotation 2020-08-15 164159.png

 

Annotation 2020-08-15 164148.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
rohsh354
Community Support
Community Support

Hello @asali7 ,

 

I tried creating file on OneDrive using the form response details, and it shows the content file even after passing the formID as custom value.

 

As a test, please try adding a compose before create file action, and check if the compose action shows the actual value of Student's email address. If yes, then leverage the output of compose in your create file action, as shown below.

 

Screen1.png

 

Screen2.png

 

Screen3.png

 

 

Hope this helps !

 

Thanks and Best Regards,

 

Community Support Team _Rohit Sharma.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
rohsh354
Community Support
Community Support

Hello @asali7 ,

 

I tried creating file on OneDrive using the form response details, and it shows the content file even after passing the formID as custom value.

 

As a test, please try adding a compose before create file action, and check if the compose action shows the actual value of Student's email address. If yes, then leverage the output of compose in your create file action, as shown below.

 

Screen1.png

 

Screen2.png

 

Screen3.png

 

 

Hope this helps !

 

Thanks and Best Regards,

 

Community Support Team _Rohit Sharma.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

@rohsh354Thank you! Worked like a charm. That was a ridiculously easy fix. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (4,329)