Power Platform Community Forum Thread Details

Auto Task assignments in power apps- Issue

Hi! Thanks for reaching out, and you're definitely on the right track. It sounds like your Power Apps app is designed to:

Distribute files to multiple selected employees.
Generate task numbers for each assignment.
Store everything in a database.
But currently, it only assigns files to one user, even when multiple are selected.

Let’s troubleshoot and guide you toward a working solution.

✅ Common Cause of Your Issue

In Power Apps, when you use a Gallery or ComboBox to select multiple users, you need to loop through each selected user and perform the assignment logic individually.

If you're only assigning to one user, it’s likely that your Submit button is only processing the first item in the selection, or not looping at all.

✅ Suggested Fix: Use a `ForAll()` Loop

Here’s how you can structure your logic in Power Apps:

ForAll(

ComboBoxEmployees.SelectedItems,

Patch(

TasksTable,

Defaults(TasksTable),

{

Employee: ThisRecord,

TaskNumber: Text(Now(), "yyyymmddhhmmss") & Text(Rand()*1000),

FileReference: SelectedFile,

Station: SelectedStation,

RecType: SelectedRecType

}

)

🔍 Explanation:

ComboBoxEmployees.SelectedItems: the list of selected employees.
ForAll(...): loops through each selected employee.
Patch(...): creates a new record in your database (e.g., Dataverse or SharePoint).
TaskNumber: generates a unique task number using timestamp and random digits.

✅ Next Steps

Confirm your ComboBox is set to allow multiple selections:
- ComboBoxEmployees.SelectMultiple = true
Ensure your database (e.g., SharePoint or Dataverse) can store multiple assignments:
- Each task should be a separate row with a reference to the employee and file.
Test with 2–3 employees selected and verify that multiple records are created.