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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Auto Populate a Datave...
Power Apps
Unanswered

Auto Populate a Dataverse table.

(0) ShareShare
ReportReport
Posted on by

Is it possible to auto populate a dataverse table? I have created a model driven app and within it I have a table which I use to record multiple questions. These questions are then answered in another table either a yes or a no and linked to a systemuser table. Id like to be able to fully automate or even semi automate the creating of the rows in the question answer table, Is this at all possible. I've been able to manually do it by editing the dataverse table with excel and copying the relevant GUIDs for the User and questions but id prefer to have a more user friendly method if possible.

 

I know I can manually creates the links one by one withing the app, but there are 500+ questions that need to be added to 50+ users so this would take some time.

I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Anonymous 

    There are several ways to bulk add data.  See https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query  for one. 

  • Ram Prakash Duraisamy Profile Picture
    5,593 Super User 2025 Season 2 on at

    Hello @Anonymous 

     

    Hope you are doing good, try using Realtime Workflow to process the same.

     

    1. Navigate to https://make.powerapps.com

    2. Click gear icon at the top

    3. Click Advance Settings --> It will open a page --> Select Process

    4. Select New --> Enter the Name --> Select Type as workflow --> Select Entity(Table1)

    5. Click Create --> Select Type as When a record is created

    6. Click Add Step --> Select Create --> Select Table2

    7. Click on Set Properties and Map the Fields 

     

    That's it:)

     

    Else you can use Microsoft Flow.

     

     

    Please mark as Answer if it is helpful and provide Kudos

     

    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

    Blog : https://microsoftcrmtechie.blogspot.com

  • Verified answer
    Community Power Platform Member Profile Picture
    on at

    Thankyou for the replies, in the end I imported the data manually. 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard