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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Forms to Sharepoint Li...
Power Automate
Unanswered

Forms to Sharepoint List to Excel

(0) ShareShare
ReportReport
Posted on by

Hi! I am having some trouble with flow. 

I linked form responses to sharepoint list and from the list, i transferred them to a new excel workbook using Flow. 

The form is splitted into 2 sections. It works fine when the whole form is filled.

But, if only section 1 of the form is filled, the responses will not be pushed from sharepoint list to the excel workbook. Any ideas how to resolve this issue? 

Thanks! 

Categories:
I have the same question (0)
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @Anonymous 

     

    Please share your flow screens so that we can help you.

     

    Thanks

    Hardesh

  • staceycey1 Profile Picture
    2 on at

    @Hardesh15 thank you! 🙂 

     

    1.png2.png3.png4.png5.png

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @staceycey1 

     

    After condition, you are using Apply to each two times. Why are you using twice? can you explain about it?

    Thanks

    Hardesh

     

  • Community Power Platform Member Profile Picture
    on at

    @Hardesh15 

    When I chose "Project Objectives" and "Implementation Status", Apply to Each automatically appears. And I do not know how to remove it.  I am very new to this. Thanks! 

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @staceycey1 

     

    are these column value type- multiple choice values?

     

    Thanks

    Hardesh

  • Community Power Platform Member Profile Picture
    on at

    @Hardesh15 yes. they are multiple choice values. 

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @staceycey1 

    Use variable to store multiple choices. follow these steps-

     

    1. Use Initialize a variable - Select type-String

    2. Use-Append to string variable- Input- your variable and value - dynamic content of your choice field value.

    it will apply to each automatically and store your choices inside variable.

    later you can use this variable for your use.

     

    Thanks

    Hardesh

  • Community Power Platform Member Profile Picture
    on at

    @Hardesh15 do i add this into my flow or a new flow? 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard