Unanswered

error in leave request test flow

(0) Share

Report

Posted on by nsan

Hello everyone.

I am trying to create a Leave request flow based on the instructions that I found in a tutorial . (https://www.spguides.com/leave-request-approval-flow/)

I have managed to build the flow and I am in the process of testing it.

In the middle of the flow I am getting the attached error.

I am new at this and any help would be appreciated.

I understand that there is , probably, a step that I must include and has to do with how the date is handled.

Any ideas?

Categories:

Building flows

screenshot from f...

error message.jpg

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @nsan,

The error suggests that the format of your start date value is not correct. The dayofweek function expects a format like yyyy-MM-ddTHH:mm:ss.fffffffK

Just to double check. Is your StartDate field in the SharePoint list also a date/time type of field?

Can you also share/double check what the format of the value was for this error in this specific flow run, you can check this in the outputs of the When a new item is created trigger action.

Was this reply helpful? Yes No
nsan 6 on at

Like (0)

Report

Hello Expiscornovus

Thank you very much.
Here is how the Start Date and End date looks like in the sharepoint list
The StartDate variable is declared like this in the flow
so I assume that this is where the correct function must be used

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report
Hi @nsan,

Yes, that is the correct location. However, it looks like you have added the expression as plain text. Can you add it via the expression tab?

Try the below

triggerOutputs()['body/StartDate']

Was this reply helpful? Yes No
nsan 6 on at

Like (0)

Report

Hello Expiscornovus

Thank you very much for the tip. Worked just fine.
I am facing another error now in my flow.
I get the attached error.
I think that it has to do with the formulas at the Details field
These formulas are initialized in the flow like this

Any ideas would be much appreciated

Screenshot.jpg

Was this reply helpful? Yes No
Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report

Hi @nsan,

It looks like you have added the expression for the End Date variable value also as plain text. Can you also add that addDays expression via the expression tab?

Was this reply helpful? Yes No
nsan 6 on at

Like (0)

Report

I proceeded with the update in the EndDate variable via the expression tab.
This is the content that I wrote as expression in the EndDate variable
addDays(triggerOutputs()?['body/EndDate'],1)

Re-tested but still getting the same error as before.
Is the expression correct? Should I change something there?

Was this reply helpful? Yes No