'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Null'.

(0) Share

Report

Posted on by lorynhope

Our company migrated to a new tenant and in doing so, all of our flows broke.

The following 'replace' functions worked until now and I cannot figure out how to fix them:

replace(replace(replace(replace(triggerBody()?['Subject'],' ','_'),'#','_'),'+','_'),',','_')
replace(triggerBody()?['DateTimeReceived'],' ','_')

The error I'm receiving is in the subject line. Please help?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Paulie78 8,422 Moderator on at

Like (1)

Report

The trigger isn't sending any data for the replace to work with. Take a look at the trigger output in the run history. Perhaps you have moved to a new tenant but you haven't updated the flows appropriately?

Was this reply helpful? Yes No
lorynhope 8 on at

Like (0)

Report

Thank you for the suggestion. I am so far outside of my wheelhouse here. I've looked at the trigger output in the run history and am coming up short on where the issue is.

The flow we have takes an e-mail that comes into a shared mailbox, exports it and creates a file in Sharepoint - that's where this is failing. Once the file is created in Sharepoint it inserts a row into a Smartsheet.

If I take all of the replace logic out then the e-mails are mostly blank for subject, sender, etc. when I open them.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (2)

Report

I feel like a broken record, but check the run history, it's the best way to figure out what has gone wrong. Check it at every stage, right from the trigger action. Copy the outputs and put them into something like notepad++ so you can clearly see them. You should be able to see the properties of your inbound email there and that will lead you down the path of doing some meaningful troubleshooting.

Was this reply helpful? Yes No
lorynhope 8 on at

Like (0)

Report

Again - I appreciate your help - I have checked the outputs. I'm only looking to replace characters from the e-mail subject and the date/time received - and neither of those fields are null in any of the trigger outputs that I'm looking at.

Was this reply helpful? Yes No
krootz 458 on at

Like (1)

Report

@lorynhope the error is saying you have a null value. Is the replace expression inside an Apply to Each loop? if it is, one of the subject must be null. In the history, click on next failed.

Was this reply helpful? Yes No