Unanswered

Compose Date from a Get items Step in Flow

(0) Share

Report

Posted on by AMR80

I have a Flow that triggers when an item is created in a SharePoint list (Shop Attendance). If the column "Delay90Days" value is "yes" it gets items from another SharePoint list (Employee Roster) to find their start date. It then formats their Start Date to add 90 days. Once it grabs the date 90 days from their start date, it delays until then and updates the originally created item to give them vacation time (on the Shop Attendance site). I am getting an error on my Compose step where the formatDateTime expression is.

Error: "The template validation failed: 'The repetition action(s) 'Get items' referenced by 'inputs' in action 'StartDatePlus90' are not defined in the template.'."

Here is the Expression I'm using: formatDateTime(addDays(items('Get items')?['Start%5Fx0020%5FDate']),90,'yyyy-MM-dd')
I think maybe the error is telling me I have this part wrong: "items('Get items')?['Start%5Fxoo20%5FDate'])"??

If anyone knows how I should update this expression or maybe another way to accomplish the same goal, I'd appreciate the help.
Screenshot of the Flow attached.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

RobElliott 10,313 Super User 2025 Season 2 on at

Like (0)

Report

Re: Compose Date from a Get items Step in Flow

@AMR80 I think your Start%5Fxoo20%5FDate should be Start_x0020_Date

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
AMR80 27 on at

Like (0)

Report

Re: Compose Date from a Get items Step in Flow

@RobElliott It took it, but I still got the same error when trying to save my Flow. Pic attached.

Was this reply helpful? Yes No
Verified answer

AMR80 27 on at

Like (0)

Report

Re: Compose Date from a Get items Step in Flow

I ended up using this expression:
formatDateTime(addDays(body('Get_item')?['Start_x0020_Date']),90,'yyyy-MM-dd')

But I had to create a variable for the SharePoint ID of the Roster item I was isolating to be able to use this part of the formula: "body('Get_item')?['Start_x0020_Date']". Attached is a snapshot of the Flow as it sits now.

Was this reply helpful? Yes No