Skip to main content

Notifications

Copilot Studio - General
Answered

Can Power VA create a CSV file

(0) ShareShare
ReportReport
Posted on by 265

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 30 on at
    Re: Can Power VA create a CSV file

    I solved it 🙂 

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

    @renatoromao Can you help me? 

  • Anna123456 Profile Picture
    Anna123456 30 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,819 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

     

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

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard