Skip to main content
Power Automate
    • Connectors
    • Templates
    • Digital process automation
    • Robotic process automation
    • Business process automation
    • Process advisor
    • AI Builder
  • Pricing
  • Partners
    • Blog
    • Documentation
    • Roadmap
    • Self-paced learning
    • Webinar
    • Business process and workflow automation topics
    • Overview
    • Issues
    • Give feedback
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • User groups
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Microsoft Power Automate Community
    • Welcome to the Community!
    • News & Announcements
    • Get Help with Power Automate
    • General Power Automate Discussion
    • Using Connectors
    • Building Flows
    • Using Flows
    • Power Automate Desktop
    • Process Advisor
    • AI Builder
    • Power Automate Mobile App
    • Translation Quality Feedback
    • Connector Development
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Galleries
    • Community Connections & How-To Videos
    • Webinars and Video Gallery
    • Power Automate Cookbook
    • Events
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Community Engagement
    • Community AMA
    • Community Blog
    • Power Automate Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power Automate Community
    • Galleries
    • Webinars and Video Gallery
    • Power Automate - Get Microsoft Forms Data includin...

    Power Automate - Get Microsoft Forms Data including Attachments

    10-20-2020 08:43 AM

    Dual Super User RezaDorrani
    Dual Super User
    3006 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    RezaDorrani
    Dual Super User RezaDorrani
    Dual Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Power Automate - Get Microsoft Forms Data including Attachments

    ‎10-20-2020 08:43 AM

    Hello everyone,

     

    In this video, you will learn about how to build a flow to connect to Microsoft Forms.

     

    We will use flow to get forms data for all column types - choice, multiple choice, numbers, multiple attachments etc. and move them to a SharePoint list.

     

    Expressions Used in Video:

     

    To get JSON value for string data types -

    json(Dynamic content column)

     

    To set multiple choice column value (Select action) -

    { "Value": "@{item()}" }

     

    To convert string to number -

    float(Dynamic content column)

     

    To get id of file uploaded -

    item()?['id']

     

    To get name of file uploaded -

    item()?['name']

     

    To learn more about expressions-

    https://aka.ms/learnexpressions

     

    #PowerAutomate #MicrosoftForms #FormsAttachments #SharePoint

    watch?v=kbqXsKPTmZk

    Preview file
    492 KB
    Labels:
    • Labels:
    • Guided Learning
    • On-Demand Webinars
    • Overview
    • Promotional
    • Tutorials
    Message 3 of 3
    3,006 Views
    1 Kudo
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    elliegeraets
    elliegeraets
    New Member
    In response to cds63
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎03-08-2022 01:02 PM

    Also having this issue.

    Message 1 of 3
    1,317 Views
    0 Kudos
    Reply
    cds63
    cds63 Helper I
    Helper I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎01-25-2022 05:57 PM

    This is great, however my Apply to Each statement fails, if there's no attachments.  I get the following error details:

     

    The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@outputs('Compose_Files')' is of type 'Null'. The result must be a valid array.

     

    Everything still populates properly on the MS List when there's no files and the Flow runs successfully when there's attachments. Is the Flow statement designed to always have attachments or have I done something wrong?  Thanks for your time. 

    Message 2 of 3
    1,610 Views
    1 Kudo
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign up free
    • Sign in

    Browse

    • Templates
    • Connectors
    • Partners

    Downloads

    • Mobile
    • Gateway

    Learn

    • Documentation
    • Learn
    • Support
    • Community
    • Give feedback
    • Blog
    • Pricing

    • © 2023 Microsoft
    • Contact us
    • Trademarks
    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Terms & conditions
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices