Hi y'all,
EDIT:
This was solved! Apparently functions don't work as functions if they are text.
Also if someone is looking at my "indexof#" trying to use it: the formula should actually be
add(int(indexOf(variables('EmailSubjectString'),'#')),1) you will get an error if you have the ",1" inside the int function!
ORIGINAL POST:
I am trying to accomplish automating a sales order fulfillment tracker and I need help parsing out strings from the email subject line to use as my key value. I found a similar post in the community but the problem with using the "from" is that it always comes from different people so I can't depend on that to be constant.
I am trying to use a unique to each request phrase in the subject line to be the key value that will be the "link" between my email chains and a sharepoint Key column.
The key ID will be generated by concatenating from a VBA excel request tool where it populates the request number in the subject line (as well as other more reader friendly text): "REQ# + Date (year / month / day / hours / seconds) + Site Name" so a request made on August 19th 2020 at 9:30.15 for site AbbeyRd would appear in the subject line as "REQ#20200819096015AbbeyRd". I put the "@" as where they want to pick it up from (also populating from the excel request tool).
I am trying to use indexing to find the # character, find the @ character, and return everything in between the two, as site names do not have a set character count.
When I ran this one, the output was just one of the functions and not the unique ID. Am I missing something?
Thank you in advance!
-KL
