Hi everyone. I am trying to send an email based off an ID number that is correlated to someone's email address. This ID number is stored on a SharePoint list once we receive an email from HR saying that this new person has been hired. So I have it set up so that once we receive the email confirming that they've been hired, an item on a list is created that includes their name, the facility they will be working at, start date, their ID number, etc. This ID number is referred to as a 3-4 ID at our company and somehow it is correlated to our email addresses. If I create a people column in a SharePoint list, I can type in a person's 3-4 ID and it will find that person just as it would if I typed in their name. I can also send emails from Outlook (just like a normal email that would you create in Outlook) using someone's 3-4 ID. So somehow, some way, our 3-4 IDs are tied to our email addresses. But it won't work when I pull the 3-4 ID from the SharePoint list and try to send an email through a flow using their 3-4 ID.
If possible, I want to automate sending an email using their 3-4 ID. Here is the flow that I came up with that doesn't work.
abc123 is a pretend 3-4 ID
(abc123 is just an example of how a 3-4 ID looks at our company)
Since that didn't work, it made me wonder if I could somehow run a flow that would create a 'person' in a people column once the email from HR was received that somehow calculated who the person was based off of their 3-4 ID. But I can't figure that out either.
And then I was wondering if I could set it up to where when I parse the information from the HR email that creates the item in the SharePoint list, if that info could be parsed into a people column. Right now I have it set up to where when I parse information from the email to create the item in the SharePoint list, it parses into a text column. So I set it up to parse into a people column instead, and that didn't work either. It just left it blank.
Anyone got any ideas on how to make this work?
