Answered

Document Expiration reminder - ExpColumn 'ExpDate' does not exist.

(0) Share

Report

Posted on by Lucas_Goncalves

Hello There!

I´m trying to create a flow that will remind users (Column Document Owner) of the documents that will expire within the next 30 days (Column Expiry Date).

I tried to build following this website (https://www.sharepointsiren.com/2018/03/using-flow-to-send-email-reminder-from-sharepoint-data/). I followed exactly.

The problems shows when the output is inserted: ExpDate eq ‘Output’

I removed this part, and the flow worked as charm (sending me e-mails of all itens within the List, without filter).

How can I solve this? Is the only thing that is avoiding me to complet my project task...

Error:

"status": 400,
"message": "Column 'ExpDate' does not exist. It may have been deleted by another user.\r\nclientRequestId: 9b63e1d6-6076-477b-aaa7-91756b3b61ac\r\nserviceRequestId: dfd6df9e-60cb-0000-b2f3-067f89e8dba9"

Categories:

Building flows

I have the same question (0)

All responses (19)

Answers (1)

Brad_Groux 4,556 on at

Like (1)

Report

This is likely a syntax or formatting issue, so if you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Lucas_Goncalves 85 on at

Like (0)

Report

Brad, thank you for your fast answer! Hope you can help me solve it until the end of day!

I tried to upload images. Please check:

Overral:

Overral 2 (SCOPE):

Was this reply helpful? Yes No
v-zhos-msft on at

Like (0)

Report

Hi @Lucas_Goncalves ,

As the pic shown, the column name is 'Expiry Date'.

So you need set the Filter Query like below:

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Lucas_Goncalves 85 on at

Like (0)

Report

Hello!

Error persists!

{
"status": 400,
"message": "Column 'ExpiryDate' does not exist. It may have been deleted by another user.\r\nclientRequestId: 0ec3823a-6a64-4941-8785-dd286660b391\r\nserviceRequestId: 771be19e-b02c-0000-9ade-f3d63c8e7b94"
}

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Lucas_Goncalves

Is the ExpiryDate column a calculated column? If so, that I believe that is your issue - you cannot reference calculated columns in an OData filter. To work around this issue, allow for the date calculation to take place in the compose action.

Was this reply helpful? Yes No
Lucas_Goncalves 85 on at

Like (0)

Report

Hello!

Yes it is a calculated column!

It calculates 365 days after the Effective Date column:
Is it possible to show me how to manage to have this output? Maybe referencing EffectiveDate + 365 eq 'Output'?

Was this reply helpful? Yes No
Lucas_Goncalves 85 on at

Like (0)

Report

Changed the column name (Effective date = column type is Date and Time); and same error:
{
"status": 400,
"message": "Column 'EffectiveDate' does not exist. It may have been deleted by another user.\r\nclientRequestId: 45b80dfe-d0bc-4495-b27a-a9f035639971\r\nserviceRequestId: 941ce19e-8054-0000-9881-c9e89c52cdab"
}

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Lucas_Goncalves

The first step to resolving your issue is to see how Flow is referring to the column. Take a look at the output of Get Items without the Filter Query. Scroll through the output and see how your column is referenced. Flow usually, but not always uses the columns internal name.

Was this reply helpful? Yes No
Lucas_Goncalves 85 on at

Like (0)

Report

Sorry could not understand...

Can you explain with images?

PS: I removed all Filter Query, and I receive an e-mail for each file, without filter. I mean, it is working. Just need to apply the filter to only send e-mail about those files that expired...

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Lucas_Goncalves :

In the screen shot below, I have used the Gt Items action to retrieve items from a SharePoint list. In the body section of the output, I scrolled down to see how my columns are referred to. So, even though I have a column called "Another Date", it shows up in the output as "AnotherDate" (no space). In the Filter query, I would need to refer to the column as AnotherDate.

Was this reply helpful? Yes No