ODATA Filter Query on Tomorrow

(0) Share

Report

Posted on by AT_AlanTse123

181

Hi all, i want to use power automate to create the flow that update SharePoint list from excel every day.

I want to filter the column called "OC" which starts with "YT" and the Work Date which is tomorrow.

It is successful to filter OC column but fail if also filter the Work Date.

May i know how to fix it?

Error detail:

Below is my flow, thank you very much for your help.

The expression of date: startOfDay(addDays(utcNow(),1,'yyyy-MM-dd'))

The date shown in desktop mode

The date shown in browser mode:

I have the same question (0)

All responses (6)

Answers (1)

v-mengmli-msft on at

Like (0)

Report

Re: ODATA Filter Query on Tomorrow

Hi @AT_AlanTse123 ,

It seems that you lost '' outside expression. Please try this:

Best regards,
Rimmon

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Re: ODATA Filter Query on Tomorrow

Hi @v-mengmli-msft ,

Thank you for your reply.
I try your method, but it causes below error.

May i know how to fix it?

Thank you very much

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

Like (0)

Report

Re: ODATA Filter Query on Tomorrow

Hi @AT_AlanTse123 ,

The error shows "eq" and "Startswith" can't be in same filter query.
Please try this:
Replace first condition in your filter query with "Filter array" action.

Best regards,
Rimmon

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (0)

Report

Re: ODATA Filter Query on Tomorrow

Hi @v-mengmli-msft ,

Thank you for your reply.
I still have the error about the Work Date column.
May i know is the column name problem or anything else?

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (1)

Report

Re: ODATA Filter Query on Tomorrow

Hi @AT_AlanTse123 ,

I recommend you remove space in excel column.
FilterQuery does not support columns with spaces, this was a known limitation before and I'm not sure if this limitation has been resolved currently.

Was this reply helpful? Yes No
AT_AlanTse123 181 on at

Like (1)

Report

Re: ODATA Filter Query on Tomorrow

Hi @v-mengmli-msft ,

Noted, i renamed the column, it works.
Thank you very much for your help.

Was this reply helpful? Yes No