i have to create i list with staff names with person data type in SP List and when we have a any new submitted form we need to check which staff will handle the task MS Forms should contain a task title. After MS Forms is submitted, a power automate workflow should be triggered and started. To do the following. Based on the time submitted at, compare the time with the “shifts” column in Table A to find the Member field for that specific shift to be retrieved. After retrieving the Member (Person type) to Power Automate, store the Task title that was submitted in the MS Forms to Table B with the Member allocated from step 2.. List item

sharepoint list and person data type , time filtter, power automate, forms

noura al-shahrani 1

i have to create i list with staff names with person data type in SP List and when we have a any new submitted form we need to check which staff will handle the task

MS Forms should contain a task title.
After MS Forms is submitted, a power automate workflow should be triggered and started. To do the following.
Based on the time submitted at, compare the time with the “shifts” column in Table A to find the Member field for that specific shift to be retrieved.
After retrieving the Member (Person type) to Power Automate, store the Task title that was submitted in the MS Forms to Table B with the Member allocated from step 2.. List item

Echo Du_MSFT 17,116 Reputation points

2021-10-15T02:53:11.55+00:00

Hello @noura al-shahrani ,

Welcome to Q&A Forum!

According to your description, your problem is much related to Microsoft Flow. Therefore, we suggest that you can go to the Microsoft Power Automate Community for more professional help.

Thanks,
Echo Du