How I create this example :
SharePoint
Two Lists :
List1 Name - Staff
columns - Title type Text availble on List creation recomended to not rename this column
Add Sample Data like Names of Staff to Title column
List2 Name - Task
columns - Title same as above, TaskName type Single Text, Date type Date and Time
Power Apps
Connect both Lists to the App using Data buton on left navigation
Add
Two Dropdowns to the Screen:
Dropdown1 connect it to Staff and point it to Title column to see list of Sample names added
Dropdown2 add Sample tasks or You can create support lists similar to List1 and connect it to Dropdown2
["Dance","Clean","Walk","Sleep"]
Date Picker - just add a date picker from insert this one You do not need do anything alse
Button Add Task
This is where we will create a colection called colTasks this collection will populate our first Gallery what will show assigned tasks what You than will Patch to SP list.
OnSelect property add below code:
Collect(
colTasks,
{
Title: Dropdown1.Selected.ID,
Date: DatePicker1.SelectedDate,
TaskName: Dropdown2.Selected.Value
}
)
Title is a FK taken from Staff List what will build relationship between List Staff and List Tasks in One To Many type.
First Gallery list of tasks
Add Blank Gallery. In items add colTasks
and to the template add two lables one for Date and secound for Task Name
in Text property add:
ThisItem.Date
and
ThisItem.TaskName
Header is created from Ractangle and lable with Text lined up to position of lables in Gallery
Button Submit Task List
This button will add all tasks from collection colTasks to Tasks list
OnSelect property add below code
You can see i'm using ForAll to loop the collection and patch each item to SPlist I'm also creating an alias for the collection called c to make it easier for patch to understand what I'm asigning to each column from the collection
at end I'm clearing collection to make sure Gallery is ready for new input.
ForAll(
colTasks As c,
Patch(
Tasks,
Defaults(Tasks),
{
Title: c.Title,
TaskName: c.TaskName,
Date: c.Date
}
)
);
Clear(colTasks)
Now the last two galleries
Create a blank gallery again and in Item property add Staff
Than add lable
ThisItem.Title
Secound Gallery
Copy Task Gallery and in Item property add this code
Filter(Tasks,Title = Text(Gallery2.Selected.ID))
Make sure Gallery2 reflecting name of gallery with Staff Names I wrap Gallery2.Selected.ID in Text() we will compare it to title column and that column is type Text so this need to match.
Now Gallery Staff (Gallery2) we will add a counter for tasks but first you will need to add a lable to this gallery and in Text property add
Thisitem.ID
call it lbl_StaffID
Now add another lable call it lbl_TaskCounter and in Text property add below code
Sum(ForAll(Filter(Tasks,Title = lbl_StaffID.Text),1),Value)
all should look like this maybe not same designe 😛
Ok we move back to Gallery1 and we add Remove function just in case someon will make a mistake 🙂
Add icon "Trash" to the Template inside of the gallery
and in onselect Property of the Icon add below code
Remove(colTasks,Thisitem)
Now hope all is working for You 🙂
