Formatting from Microsoft Forms to Excel using Power Automate

(1) Share

Report

Posted on by KH-01041444-0

I have a Microsoft Form where one of the questions in the form is a document upload. I am using Power Automate to take the responses from the Form and populate them to a table in Excel. When Power Automate does this the formatting of the document upload question is flawed. It includes "name", "link", "id", "type", "referenceid", etc. all in one string. This does now allow me to open the file. I am wondering how to just get power automate to include ONLY the "link" part when exporting the content to excel, so from the document can be accessed without having to manually delete words around the link. An example of how the link is being formatted is attached.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @KH-01041444-0

Firstly thank you for sharing the picture. however, when you are asking about data manipulation we need the actual "string" data so that we don't have to type or try to read that blarby mess" lol) Since its just JSON.

Next, its not flawed its part of how it gets passed in because it gets stored in the back end as part of the question.

To Access the actual content you simply have to do this

1. Add your Get Response Details

2. Add a Parse JSON Action

--Content field = the dynamic content response from Step 1

--Generate the Schema. - Use an Example, the one you gave to us

3. Add a Compose

--add this expression (assuming you left the Parse Json the default name

first(json(outputs('Parse_JSON')?['body']))?['link']

And now you have the link.

If this answers your question please mark as answered. Thanks!

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @KH-01041444-0

Can I answer anything else for you? Below is the answer to this question, and would appreciate if you could Mark it so and maybe a like.

If you have any questions please let me know.

Cheers,

Was this reply helpful? Yes No