Answered

Exrract strings froma Sharepoint List

(0) Share

Report

Posted on by CM72

Hello, i have a ms form and send the results to a Sharepoint List, but in one of the fields can receive multiple answers. So, in the flow i edited to separate the results adding and enter. Now i can see the results separated, but i can't apply a filter because there can be one, two or more options.

Is there a way to extract the values of the strings?, These strings are names and they can be listed in different order, these strings have different sizes but the are always the same for example the appear like this

option1

option2

option3

Is there a way to extract every string a send it to an excel file? the strings can be sorted in different order, so i need to look for an specific string no matter in what position is it.

Thanks a lot!!

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@CM72 Pls take help from this-How to store Microsoft forms responses in a SharePoint list? « Gopenly

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
CM72 21 on at

Like (0)

Report
Copy link

Link copied!

I was following the steps but i found a problem when creating the array: In your example:
Split(replace(replace(replace(outputs(‘Get_response_details’)?’body/rc9bce6a0275e4d789bd1098d569868d5′],'[‘,”),’]’,”),'”‘,”),’,’)
The value marked in bold i replaced with my id of the field in forms is that correct? what i did? then copy the same but i think i'm making some mistakes there. Can you explain me please what should i put after the id, or how the following characters should be form
Thanks in advance
Thanks!!

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @CM72

outputs('Get_response_details')? body/rc9bce6a0275e4d789bd1098d569868d5'].

A square bracket is missing before the body.

Please modify it to: outputs('Get_response_details')?['body/rc9bce6a0275e4d789bd1098d569868d5'].
You can also convert this multiple choice question into an array with the json function.

I think this link will help you:

回复：在共享点列表中为... - 电源平台社区 (microsoft.com)

Best Regards,

Levi

Was this reply helpful? Yes No
Verified answer

CM72 21 on at

Like (0)

Report
Copy link

Link copied!

Yes it works, thanks a lot!!!

Was this reply helpful? Yes No
CM72 21 on at

Like (0)

Report
Copy link

Link copied!

There were some mistakes i couldn't solved. But someone else posted another solution. Thanks!!

Was this reply helpful? Yes No
CM72 21 on at

Like (0)

Report
Copy link

Link copied!

There were some mistakes i couldn't solved. But someone else posted another solution. Thanks!!

Was this reply helpful? Yes No