Unanswered

Record form responses in SharePoint

(0) Share

Report

Posted on by Emma_Sv

Hello everyone..

I have a little problem I'm stuck on, hope someone can help.
I have created a flow with "Record form responses in SharePoint".
Everything works, except when I want to download it in excel and want to Pivot the result.
How do I build a Flow so that the answers that come out of the result are numbers and not text?

Here is my latest flow, but it still comes out as text.
The last poste i have put in int(outputs('Compose'))

All responses (9)

Answers (0)

v-mengmli-msft on at

Like (0)

Report

Re: Record form responses in SharePoint

Hi @Emma_Sv ,

Regarding the question of SP and Excel, I suggest that you can post on the relevant community to get professional answer.

Best regards,
Rimmon Li
Emma_Sv 14 on at

Like (0)

Report
Re: Record form responses in SharePoint

Downloading it from my sharepoint list. In the red circle, I select Export to Excel.
v-mengmli-msft on at

Like (0)

Report

Re: Record form responses in SharePoint

Hi @Emma_Sv ,

Can you tell me how you downloaded the results to excel? I can't get the information from your previous screenshot.

Best regards,
Rimmon Li
Emma_Sv 14 on at

Like (0)

Report

Re: Record form responses in SharePoint

Sorry, but now I feel lost/stupid. If it is active, how come it comes out as text and not numbers when I download the result in excel?
v-mengmli-msft on at

Like (0)

Report

Re: Record form responses in SharePoint

Hi @Emma_Sv ,

Have you noticed that the colors of the two outputs of Compose are different? The color of the Compose2 outputs represents the numeric type, which indicates that the int function is in effect.

Best regards,
Rimmon Li
Emma_Sv 14 on at

Like (0)

Report

Re: Record form responses in SharePoint

Hi, okej..
v-mengmli-msft on at

Like (0)

Report

Re: Record form responses in SharePoint

Hi @Emma_Sv ,

The steps below in my test don't matter, please run your flow and show the outputs of Compose2.

Best regards,
Rimmon Li
Emma_Sv 14 on at

Like (0)

Report
Re: Record form responses in SharePoint

Hi.

Do you have an extra step after Compose2? Here is my view, looks like you have an extra step. Or am I missing something?
v-mengmli-msft on at

Like (0)

Report

Re: Record form responses in SharePoint

Hi @Emma_Sv ,

Could you show me the outputs of Compose2?
Everything worked fine in my tests:

Best regards,
Rimmon Li