Hi ,
I've been encountering the below error on the last step of my flow - add row into a table. I'm unsure what is triggering this issue? The flow is to extract the email content when it arrives into a Share mailbox and to feed the email content into a excel table.
The length of substring can't be longer than '1813' which is the length of the source string.
Would someone be able to shed light what this error could mean?
Appreciate any help.
Hi Eric,
Here's an example of what I'm trying to do.
Page title:
Feedback:
Sentiment:
I'm a complete newbie and the substring I've used are borrowed from previous comments in the forum.
I have a feeling it may have something to do with the email arriving on the shared mailbox which seems to be where the error is occurring. I say this because if I forward the email from the shared mailbox to myself, the flow works perfectly fine? Could it be caused by the extra lines when the email arrives in the shared mailbox?
Hi @auswtz ,
Can you post your substring formula?
Without seeing your formula, I suspect your third parameter is causing an issue.
Substring takes in 3 parameters:
* Source string - the original piece of text
* Start index - the index/position where you want to start extracting from
* Length - the number of characters you want to extract (from the start index)
An example is below:
Apple
substring('apple', 1, 3) would return app
substring('apple', 2, 3) would return ppl
Check your length parameter isn't set to 1813 if your start index is greater than 1 because it will try to extract past the end of your text .
Try this online substring tester to plug in your values and test it out.
--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up
Connect on LinkedIn