Hi All,
Is it possible in flow ( or other system) to use the substring of the subject of an email as the ID variable of a list item to be updated in SharePoint. That doesn’t make much sense so I’ll try to explain it a bit more.
I have a list in SharePoint Online it has the standard columns including the ID and one additional column, “body”. I have a mailbox in office 365. Both are connected to flow.
What i need is when an email arrives in the mailbox a flow is triggered. The flow checks the subject line and extracts the number from the subject.
It then uses that value as the ID of the list item in needs to update with say the body part of the email. As an example an email with a subject line of #10 is received, it then copies the body of the email to the body column of ID 10 list item in SharePoint.
Is that possible? If so how?
I’m basically trying to make a 2 way communication system from within SharePoint. I.e. I update and item, it emails the user, they respond and it updates the correlating list item?
Thanks in advance.
Tyrone