Hey @Timm1
you can use a SharePoint List with just the same columns, that you have in your form and for each item in your table, you create a new item in your SharePoint list. If you want to combine these to a request, you can work with two lists, one for the form itself (like basic information who, to whom, when, totals etc. about the request) and a details list with the Item ID from the other list (lookup or just plain text/value column) and the other information like requested leave, start date, end date, days, hours.
In your app, you can use a Gallery, this Gallery is connected to an Power Apps Collection. To create a new collection, you can use (on app start):
ClearCollect(colLocalList,{Leave:"",StartDate:""...})
This collection is connected to your Gallery. Within your gallery you have your fields, that are edible like dropdown, date etc. On the "OnChange" properties of your actions in your gallery, you need to add an Update() function like:
//Update the value "Leave" for the current item
Update(colLocalList,ThisItem,{Leave:Self.SelectedText.Value})
You need another button to add more items to your collection using Collect() function:
Collect(colLocalList, {})
The last button will patch everything to your SharePoint list(s) using the patch() fuction:
Patch function in Power Apps - Power Apps | Microsoft Docs
Hope this gives you an idea on how to achieve this.
Best regards
Marvin
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
