So I was able to create the list in SharePoint however I am unable to translate the form so ill try to be more accurate when describing what I am trying to achieve with this flow. Currently the flow is automated to send an email to the recipient listed whenever someone discloses that they are experiencing any of the listed symptoms.
Workers are supposed to sign in at the construction site through the form. In the form there is a drop down menu with the names of all the supervisors where they are supposed to select their supervisor (different for every construction site).
(I will use myself as an example this time)
The way this flow currently works is it sends an email whenever someone submits a form where they have selected that they are experiencing COVID-19 symptoms. However the email address is imputed manually which defeats the purpose of this being a automated flow.
I have tried automating this process two ways.
1. Populating a sharepoint list with the name of the supervisor and their email.
I then tried to set the original form response as a variable using initialize variable and then changing this variable to equal the value on the "name" column in the sharepoint list and then changing it again to equal its equivalent in the "title" column. Then reference this variable as the email address in the condition portion of the flow. However I would get an error saying that the address was invalid (I probably did the conversion part wrong) or that the text I was referencing was in array format when it needed to be as a string (or vice versa)
2. Since I am working on my jobs SharePoint site I can make a list of the supervisors as a column specifically for people automatically recording the names into a contact that should in theory translate pretty smoothly to what I need it for. However I did not know how to reference it on the flow. I was unable to get it to change from the name in the form to the name in the sharepoint list and then reference this name as a contact when sending the email as a variable.
