Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
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! 

  • Community Power Platform Member Profile Picture
    on at
    Re: Forms to Sharepoint List to Excel

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

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Forms to Sharepoint List to Excel

    @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
    Re: Forms to Sharepoint List to Excel

    @Hardesh15 yes. they are multiple choice values. 

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Forms to Sharepoint List to Excel

    @staceycey1 

     

    are these column value type- multiple choice values?

     

    Thanks

    Hardesh

  • Community Power Platform Member Profile Picture
    on at
    Re: Forms to Sharepoint List to Excel

    @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
    Re: Forms to Sharepoint List to Excel

    @staceycey1 

     

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

    Thanks

    Hardesh

     

  • staceycey1 Profile Picture
    2 on at
    Re: Forms to Sharepoint List to Excel

    @Hardesh15 thank you! 🙂 

     

    1.png2.png3.png4.png5.png

     

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at
    Re: Forms to Sharepoint List to Excel

    @Anonymous 

     

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

     

    Thanks

    Hardesh

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,645 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow