Power Platform Community Forum Thread Details

I want to create a shift pass down summary form. Prior used was info path. I have three shifts and each shift needs to report: Time, Location, Delay, SS-Code, Description (summary) and two dropdowns with the personnel: Controller TC and Controller PD. Then there is a section to report Vehicle Routing and needs these details: Time, Trains, Description of Routing. Another Section called Carry over items and these details: WR#, Date, Status, SS-Code, Description and last I have the section of "Safety Issues" with details of Date, Status, SS-Code and Description. My challenge is on its own i can have three forms but that is not what I need. I need to be able to have all lines visable so when each shift comes in they can glance over it. I need all to pull into one report at the end of day. I only have the option of using share point lists and I can't seem to create the power app I need. I may be over thinking it but I also need them to be able to "Add a Line" for each section as they add their details. What would the best set up for this be? I tried converting the infopath form but I haven't had success.

Categories:

Building Power Apps

Hi @CU13031423-0,

According to me, best setup (recommended for Power Apps + SharePoint):

Create separate SharePoint lists for each section:

Shift Activities (Time, Location, Delay, SS-Code, Description, Controller TC, Controller PD, Shift, Date)
Vehicle Routing (Time, Trains, Description, Shift, Date)
Carry Over Items (WR#, Date, Status, SS-Code, Description, Shift)
Safety Issues (Date, Status, SS-Code, Description, Shift)

Build one Power Apps screen with multiple galleries

One gallery per section or tab view.
Filter by Date = Today() so all shifts are visible.

Example:

Filter('Shift Activities', Date = Today())

Add “Add Line” button
Use a form or Patch to create new records.

Why this works

All shifts visible in one screen
Users can add multiple lines
Easy to generate end-of-day report using Date + Shift fields.

I hope this works for you!