Skip to main content

Notifications

Copilot Studio - General
Answered

Can Power VA create a CSV file

Posted on by 22

Hello everyone,

 

As I know in the chat bot, we can create variables to keep user response, can we somehow use those variables to create CSV file containing those variables ? I'm not sure how, but maybe in collaboration with Power Automate, create CSV then put the CSV in OneDrive ? 

 

Thanks,

  • shalini227 Profile Picture
    shalini227 2 on at
    Re: Can Power VA create a CSV file

    Can i know what are the changes you did to make it work?

  • Anna123456 Profile Picture
    Anna123456 6 on at
    Re: Can Power VA create a CSV file

    I solved it 🙂 

  • Anna123456 Profile Picture
    Anna123456 6 on at
    Re: Can Power VA create a CSV file

    @renatoromao Can you help me? 

  • Anna123456 Profile Picture
    Anna123456 6 on at
    Re: Can Power VA create a CSV file

    Hello Renatoromao, 

     

    I tried your solution but I am struggeling with the last point. Can you help me and say what I am doing wrong? 

    What I do: 
    csv1.pngcsv2.pngcsv3.png

     

    Best wishes, 

    Anna 

  • Verified answer
    renatoromao Profile Picture
    renatoromao 6,459 on at
    Re: Can Power VA create a CSV file

    Hi @Voltes ,

     

    Exactly, you can create an automation with Power  Automate to store all variables inside the CSV file.

     

    - For each question, click on the variable an enable between topics

    - Inside the End with Survey system topic, you can create an action calling the Power Automate with inputs.

    - Inside your workflow, save the variables like a table, column by column, into the CSV file stored in the OneDrive

     

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,995

#3
Expiscornovus Profile Picture

Expiscornovus 1,708

Leaderboard