web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Send auto-replies to s...

Power Automate

Unanswered

Send auto-replies to senders when a new email arrives after office hours not working

(1) Share

Report

Report

Posted on by HamidBee

932 Super User 2024 Season 1

I am using the 'Send auto-replies to senders when a new email arrives after office hours' template. When I run the flow. I get the following error:

The value of first parameter is of type 'Null' but the function 'substring' expects a string.

Here is what I have:

Thanks in advance.

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

srduval 1,760 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sounds like it doesn't like something in your substring. Can you post that expresssion

Was this reply helpful? Yes No
HamidBee 932 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Just a note, I made no changes to the template. The expression is:

substring(triggerBody()?['DateTimeReceived'], 11, 8 )

Was this reply helpful? Yes No
Ellis Karim 11,793 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!
You could get the integer value for the hour, then perform a check so see if it's between, say 9 and 17 for office hours:

int(formatDateTime(triggerOutputs()?['body/receivedDateTime'],'HH'))

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (2)

Report
Copy link

Link copied!
Use this:
substring(triggerBody()?['receivedDateTime'], 11, 8 )

Was this reply helpful? Yes No

Join the conversation