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'))

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Emma_Sv ,

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

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Emma_Sv 14 on at

Like (0)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Emma_Sv 14 on at

Like (0)

Report
Copy link

Link copied!

Hi, okej..

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Emma_Sv 14 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Emma_Sv 14 on at

Like (0)

Report
Copy link

Link copied!
Downloading it from my sharepoint list. In the red circle, I select Export to Excel.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No