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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Generate fake data for...
Power Apps
Unanswered

Generate fake data for testing app

(0) ShareShare
ReportReport
Posted on by 169

 Hello I would like if this is possible to generate 2000  data line in Microsoft Lists for testing my app and see if it's still work well. it is possible ? I've searched and I just see some tuto for excel.

Categories:
  • WarrenBelz Profile Picture
    156,532 Most Valuable Professional on at

    Hi @Dive1 ,

    This will take a while to run and you can put whatever you want in the fields, but I have used the sequence number as an example in a Text and numeric field

    Patch(
     YourSPList,
     ForAll(
     Sequence(2000),
     {
     TestNo: Value * 4,
     Data: "Test" & Text(Value)
     }
     )
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

     

  • Dive1 Profile Picture
    169 on at

    How do this work with for exemple I have choice in my data

    like a table "Sector" with in it Sector1; Sector2 and Sector3 ?

  • WarrenBelz Profile Picture
    156,532 Most Valuable Professional on at

    @Dive1 ,

    You would enter

    Sector: {Value: "YourValueHere"}

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • Dive1 Profile Picture
    169 on at

    is that something like that I don't understand how I should write it

    Patch(
     OpportunitesVTest2000;
     ForAll(
     Sequence(2000);
     {
     Secteur.Value: "Lamballe";
     "Date Création".Value:today();
     Com.Value: CurrentUser.FullName;
     Etat.Value: "En Cours";
     Société: "Soc1";
     "Nom client": "ClientTest";
     "Ville client": "VilleTest";
     Type_Mat: "RG500";
     Montant.Value: 500;
    
     }
     )
    )

     

    It says I have error  like that is not the operator that they await

  • WarrenBelz Profile Picture
    156,532 Most Valuable Professional on at

    @Dive1 ,

    Please see corrected post - yours would be

    Patch(
     OpportunitesVTest2000;
     ForAll(
     Sequence(2000);
     {
     Secteur: {Value: "Lamballe"};
     "Date Création": Today();
     Com: {Value:CurrentUser.FullName};
     Etat: {Value: "En Cours"};
     Société: "Soc1";
     "Nom client": "ClientTest";
     "Ville client": "VilleTest";
     Type_Mat: "RG500";
     Montant.Value: 500
     }
     )
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

     

  • Dive1 Profile Picture
    169 on at

    I think I've writed good but it seem it don't work it tell me "the type of argument is not valide(Table). Value Record await." "The fuction 'patch' contain wrong argument"

    Patch(
     OpportunitesVTest2000;
     ForAll(
     Sequence(2000);
     {
     Secteur: {Value: "Lamballe"};
     'Date Création': Today();
     Com: {Value:User().FullName};
     Etat: {Value: "En Cours"};
     Société: "Soc1";
     'Nom client': "ClientTest";
     'Ville client': "VilleTest";
     Type_Mat: "RG500";
     Montant: {Value: "200"};
     '%Réussite': {Value: "80"};
     Commentaire: "test";
     'Date de relance': Today();
     'Marque reprise': {Value: "SANS REPRISE"};
     }
     )
    )

     

    Does I have to write all table in the function ? some of them I want them empty so I did't write in it. 

  • WarrenBelz Profile Picture
    156,532 Most Valuable Professional on at

    @Dive1 ,

    Which item is this error on? I cannot see your data, so you can you please provide a screen shot of your SharePoint List settings with the field types of each of these.

  • Dive1 Profile Picture
    169 on at

    hello the errors in on all the formule everything is red.

    I've joint the sharepoint lists with their type

    (Une seule ligne de texte = Text

    Date et Heure = Date and Hour

    Personne ou groupe = Person or group

    Nombre = Number

    Choix = choice)

    MicrosoftLists.png
  • WarrenBelz Profile Picture
    156,532 Most Valuable Professional on at

    @Dive1 ,

    From what you have posted, it would be something like this

    Patch(
     OpportunitesVTest2000;
     ForAll(
     Sequence(2000);
     {
     Secteur: {Value: "Lamballe"};
     'Date Création': Today();
     Com: 
     {
     '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
     Claims: "i:0#.f|membership|" & Lower(User().Email),
     Department: "",
     DisplayName: User().FullName,
     Email: Lower(User().Email),
     JobTitle: "",
     Picture: ""
     },
     Etat: {Value: "En Cours"};
     Société: "Soc1";
     'Nom client': "ClientTest";
     'Ville client': "VilleTest";
     Type_Mat: "RG500";
     Montant: 200;
     '%Réussite': {Value: "80"};
     Commentaire: "test";
     'Date de relance': Today();
     'Marque reprise': {Value: "SANS REPRISE"};
     }
     )
    )

    If there are any errors, please first read my blog on Controls and their outputs. Your original post was  Hello I would like if this is possible to generate 2000  data line in Microsoft Lists for testing my app and see if it's still work well. it is possible ?  - you need to understand your control references, so please try and investigate errors and note what you have found and done.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • Dive1 Profile Picture
    169 on at

    I've still have the same errors on all the formule.

    I've changed the "Type_Mat" and added some table. for me it's seem all good so I don't understand why I have still errors

    Patch(
     OpportunitesVTest2000;
     ForAll(
     Sequence(2000);
     {
     Secteur: {Value: "Lamballe"};
     'Date Création': Today();
     Com: 
     {
     '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";
     Claims: "i:0#.f|membership|" & Lower(User().Email);
     Department: "";
     DisplayName: User().FullName;
     Email: Lower(User().Email);
     JobTitle: "";
     Picture: ""
     };
     Etat: {Value: "En Cours"};
     Société: "Soc1";
     'Nom client': "ClientTest";
     'Ville client': "VilleTest";
     Type_Mat: {Value: "Tracteur"};
     'Etat acquisition': {Value: "Neuf"};
     Marque: {Value: "John Deere"};
     TypeMat: "MB500";
     Montant: 200;
     '%Réussite': {Value: "80"};
     Commentaire: "test";
     'Date de relance': Today();
     'Marque reprise': {Value: "SANS REPRISE"};
     }
     )
    )

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 411 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 338

#3
WarrenBelz Profile Picture

WarrenBelz 256 Most Valuable Professional

Last 30 days Overall leaderboard