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 / Capturing selected rec...
Power Apps
Unanswered

Capturing selected records from seperate table in dataverse

(0) ShareShare
ReportReport
Posted on by

Hi, need a bit of advise,
I've been tasked with creating an end of shift report, the premise being that all the primary details (date, shift, weather etc) are captured in one table (tbl_shift_reporting), then the user can create new detail items to add to the report, and or select existing detail items/issues that are still valid from a seperate table (tbl_shift_reporting_detail) to add to the information to be sent out.

The issue i'm trying to get my head round is how to capture the new/selected items for each shift.

The new/selected items are in a second table (tbl_shift_reporting_detail), and could be added to many reports depending on how long they are valid for. I need to be able to record (in possibly a 3rd table?) which records they selected? 
Because they are valid for multple reports, a 1 to many relationship/ standard lookup field between the 2 existing tables wouldn't work, I'm struggling to work out the best way of achieving this.
I need to be able to record what records were selected for each shift, but having a whole new table to record each of the detail records selected (1 row per item selected), seems a bit excessive?

Any advise would be appreciated!!

I have the same question (0)

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
WarrenBelz Profile Picture

WarrenBelz 525 Most Valuable Professional

#2
Haque Profile Picture

Haque 273

#3
Kalathiya Profile Picture

Kalathiya 232 Super User 2026 Season 1

Last 30 days Overall leaderboard