web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : KNfLi1oiPoErjw5lOc7PGj
Power Automate - Building Flows
Answered

Microsoft Forms does not recognize number columns in SPO list (using flow to populate list)

Like (0) ShareShare
ReportReport
Posted on 21 Apr 2025 22:09:19 by 12
I'm using MS Forms as the UI to populate an SPO list via Power Automate flow but I noticed that Microsoft Forms does not recognize number columns in the SPO list.  It forces me to use Text column instead of a number column but then I can't do calculations from a text field.  Any thoughts? 
I have the same question (0)
  • Verified answer
    David_MA Profile Picture
    12,030 Super User 2025 Season 2 on 30 Apr 2025 at 14:23:52
    Microsoft Forms does not recognize number columns in SPO list (using flow to populate list)
    Since you do not show your flow, I cannot be sure, but what I think you are really asking is that the value from a question in Microsoft Forms that is set as a number:
    When used to populate a number field in a SharePoint list, it generates an error that the value is a string. This is correct as while you can tell forms that only numbers can be entered, the field in Microsoft Forms is still a string field.
     
    To overcome this, when populating the SharePoint list, just wrap the dynamic content from the form in an int() expression. 
  • rzaneti Profile Picture
    4,096 Super User 2025 Season 2 on 30 Apr 2025 at 13:26:39
    Microsoft Forms does not recognize number columns in SPO list (using flow to populate list)
     
    I just want to confirm if you had a chance to test the solution recommended in my previous message.

    If it works properly and answered your question, please mark it as Accepted Answer, so other users with the same issue can find it easily in the future :)
  • Verified answer
    rzaneti Profile Picture
    4,096 Super User 2025 Season 2 on 21 Apr 2025 at 22:15:42
    Microsoft Forms does not recognize number columns in SPO list (using flow to populate list)
     
    I'm assuming that you're generating the input Forms directly from SharePoint List. If you are getting any issues to create a given field from the form, I would recommend you to manually create the SP column as number, and do the same in the MS Forms directly (instead of on SharePoint). You will be able to connect the question to the column later in Power Automate.
     
    If these instructions are not enough, please provide some additional context on you flow design.
     
    Let me know if it works for you or if you need any additional help!
     
    If this solved your issue, please mark it as Accepted Answer.
    👍 If it helped, feel free to give it a like!

    🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
    💼 Find me on LinkedIn
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete