Is it possible to list all tasks assigned to a user in a form?

[Anonymous]

I have an initial form that when submitted will be handed off to another group of users. I was wondering if there was a way to display a list of the forms submitted to users, who they were submitted by, and allow them to view and accept or deny the submission.

I don't have access to Microsoft Graph API which I think would be the most useful for this so would this be possible?

Also on a side-note without Graph is there a way to group users?

[KrishnaV]

Hi @Anonymous ,

What is this form? where are you saving this form? when you mean by form is it implemented in Power Apps and data is storing in a SharePoint List / DB?

Give us some more insight to help you better.

Let me know I am always happy to help.

Regards,

Krishna

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want to list all available tasks assigned to current sign in user, allow them to view and accept or deny the submission?

Further, where do you store the submission from your Edit form? In a SP List?

I assume that you store your form submission in a SP List, and there is a 'Assigned User' column in your SP List to store the user who you want to assign the task (the submission) to. And you also added a Choice type column (called "SubmissonStatus") to store the "Accept" or "Deny".

Based on the needs that you mentioned, I think a Gallery and Filter function could achieve your needs. You could consider add a Gallery control (called "TasksGallery") in your app, set the Items property to following:

Filter('Tasks SP List', 'Assigned User' = User().FullName)

Add another Detail screen, and add a Display form inside it, connect this Display form to same Task SP List as above TasksGallery. Set the Item property of Display form to following:

TasksGallery.Selected

Set the OnSelect property of the ">" icon in above TasksGallery to following:

Navigate(DisplayformScreen)   // press it to navigate to the Display form screen to view the submission

within above Detail screen, add a "Accept" button and "Deny" button. Set the OnSelect property of the "Accept" button to following:

Patch(                        // update the "SubmissionStatus" field value to recognized this submission has been Accepted
      'Tasks SP List',
      TasksGallery.Selected,  // or type LookUp('Tasks SP List', ID = TasksGallery.Selected.ID)
      {
         SubmissionStatus: {
                             Value: "Accept"
                           }
      }
)

set the OnSelect property of the "Deny" button to following:

Patch(                    // update the "SubmissionStatus" field value to recognized this submission has been Denyed
      'Tasks SP List',
      TasksGallery.Selected,   // or type LookUp('Tasks SP List', ID = TasksGallery.Selected.ID)
      {
         SubmissionStatus: {
                             Value: "Deny"
                           }
      }
)

Patch function

Please take a try with above solution, check if the issue is solved.

Best regards,

[Anonymous]

@v-xida-msft 

Okay, so I have a form where a user can log in with an email and password. From there it validates the type of user.

If the user is Type A, I want to allow them to see the submissions they have made, edit a submission if it is sent back to them, and submit a new submission.

If the user is type B I want them to be able to view any submission assigned to them, then be able to view the selected submission and add information to the current submission selected, If they deny it will get routed back and assigned to the type A person and let them know what changes need to be made. If Type B accepts and adds the information needed then it will get assigned to type C.

Type C needs to be able to view all submissions assigned to them and then approve or deny the request, if approved it will send an email to type A telling them it was approved and if denied it will email type A and tell them it was denied.

The only difficult part here is, I'm not doing validation based on the current user that is signed into powerapps but the information used on my sign-in page. 

I don't have any SP lists or anything like that just yet. I'm willing to build out whatever will make this work.

I currently have forms built out for the initial submission, the login screen, and then I have blank screens for the Type A, type B, and Type C dashboards.

Right now I'm storing the information from the initial submission in a collection so it is easy to access.

I'm not sure if this information would help you but I'm thinking what you posted wouldn't work as a solution for me.