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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a series of g...
Power Automate
Suggested Answer

Creating a series of generated CSV files

(0) ShareShare
ReportReport
Posted on by DM-01111410-0 2
I'm trying to generate 9 pre-defined CSV files with AI generated content based on a few prompts.  They will be used to populate data in our software.
 
For example, I want to tell it to generate a set of data for video game companies, and it will generate 1 file with the name of the game, another file with all the different products associated with that game (e.g. XBox, PS5, PC, etc.).  It will "invent" all the data.  There will probably be about 4-5 prompts needed to classify the data needed in each file, and to tell it how many rows to generate.
 
I'm struggling to figure this out.  Any advice?
 
Thanks
Categories:
Building flows
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    David_MA 14,554 Super User 2026 Season 1 on at
    If you need to generate mock data, I would suggest Mockaroo - Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel. You may get a reply, but I don't think you're going to get much assistance with writing AI prompts in the Power Automate Community. There is no specific action in Power Automate that I am aware of that generates sample data from an AI prompt.
     
    You might also want to take a look at AI Prompt Template Generator - Free Online | MaxAI.me which helps you to write prompts for AI. I haven't given it a try yet, as I don't want to register for one more thing.
  • DM-01111410-0 Profile Picture
    DM-01111410-0 2 on at
    Thanks David_MA - I'm going to try that.
     
    I've been able to get ChatGPT to do it just using the regular prompt, but it makes a lot of mistakes and takes several steps. 
     
    I'll try Mockaroo.
     
    Thanks again!

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 921

#2
Valantis Profile Picture

Valantis 801

#3
Haque Profile Picture

Haque 588

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans