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 / How to create a datave...
Power Apps
Unanswered

How to create a dataverse table to support a form like this screenshot

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

JoeyWalker7_0-1648651237378.png

We want to create a power app duplicate this form.  However, there is no data so we have to create our own tables in dataverse. Any suggestions?

I have the same question (0)
  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Anonymous 

    You need a Table where it is called a header with the Team Members and Functions, Then you need to add another table with 1:N relationship from the first table for the sessions.

    It would be better as well if you explain the business case and how it is working and if the number of sessions are fixed or can increase over time.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Mira, thank you for your response. 

     

    The business case is that one department wants to record their team members' attendance. The regular users (Team Members) will be able to use the app to edit/update the attendance record. The admins (Their managers) will be able to go in and view the total attendance records of team members. Also, the admins should be able to add/edit/delete any team members (which means that Team Member table should be dynamic).

     

    For the separate table with sessions. should I use Team Members' id as foreign key? And also,  how should I show the date even though no one is working on that day (For instance, Aug-20 as shown in the screenshot.)

     

    Thank you!!

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

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!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard