Hi @stevib1975 ,
For your travel cost submission app in Power Apps, you're on the right track with using a gallery, but you'll need a bit more to handle the complexity of multiple items per claim. Here's a simplified approach:
SharePoint List Structure:
Have one list for Claims (each claim has a unique ID).
Create another list for Claim Details (where each entry links to a claim in the Claims list and contains information like Type of Cost, Value, Travel Goal).
Power Apps Design:
Use a gallery to display Claims. When a user selects a claim, show another gallery within the first one or on another screen to display the related Claim Details.
To add new positions to a claim, include an “Add” button in the Claim Details gallery that lets users input new items.
Managing Data:
For dynamic rows, use the 'Add' button to collect new entries and 'Delete' icon in each row for removal.
Implement logic to update SharePoint lists only when the user submits or finalizes the claim.
Security and Workflow:
To prevent changes after manager approval, include a status field in your Claims list. Once a claim is approved, lock the editing feature in the app based on this status.
Consider using Power Automate to manage the workflow, like sending notifications for approval and locking the claim for editing post-approval.
Hope this gives you a direction to start with! If you find this solution helpful, please feel free to accept it. 😊
