Flow Fails ? due to SharePoint List Column starting with a number

(0) Share

Report

Posted on by Angry_Sys_Admin

181

Afternoon all.

In my staff management app, all staff have a 6 monthly review date, this date is taken from a date picker in a SharePoint column.

I need to create a flow which reminds managers 1 week before the due date to book a meeting with the member of staff however when I run the flow, it fails and I think it has something to do with the column name starting with number, strangly, the error says the column does not exist but the filter query has picked up the correct date from the column, please see below:

Any assistance would be much appreciated as I'm a novice when it comes to anything other than simple flows

Many thanks

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RobElliott 10,503 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Angry_Sys_Admin go to list settings, select the 6 Month Review Date column and check in the address bar what the internal name of the column is, it's after field= at the end of the url. Make sure the filter query is using that internal name.

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
Angry_Sys_Admin 181 on at

Like (0)

Report
Copy link

Link copied!

@RobElliott Yes the above name used in the flow is the internal column name,

So in the flow it looks correct

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report
Copy link

Link copied!

In the Filter Query put:

OData__x0036_MonthReviewDate eq '2023-06-27'

Get Items Filter Query

If you check the outputs of the Get Items you can see how it reads the column:
Get Items Outputs

You want to make the Filter Query be the same as what shows in the Outputs.

Was this reply helpful? Yes No
Angry_Sys_Admin 181 on at

Like (0)

Report
Copy link

Link copied!

@wskinnermctc

Thanks for the reply.

This is now working

Was this reply helpful? Yes No