Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / ODATA Filter Query on ...
Power Automate - Building Flows
Answered

ODATA Filter Query on Tomorrow

(0) ShareShare
ReportReport
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:

AT_AlanTse123_1-1704265074129.png

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

 

AT_AlanTse123_0-1704264753950.png

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

 

The date shown in desktop mode

AT_AlanTse123_2-1704265255125.png

The date shown in browser mode:

AT_AlanTse123_3-1704265315171.png

 

 

 

  • AT_AlanTse123 Profile Picture
    AT_AlanTse123 181 on at
    Re: ODATA Filter Query on Tomorrow

    Hi @v-mengmli-msft ,

     

    Noted, i renamed the column, it works.

    Thank you very much for your help.

  • Verified answer
    v-mengmli-msft Profile Picture
    v-mengmli-msft on at
    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.

  • AT_AlanTse123 Profile Picture
    AT_AlanTse123 181 on at
    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?

    AT_AlanTse123_1-1704269571072.png

     

     

    AT_AlanTse123_0-1704269478411.png

     

  • v-mengmli-msft Profile Picture
    v-mengmli-msft on at
    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.

    vmengmlimsft_1-1704268880797.png

     

    Best regards,

    Rimmon

  • AT_AlanTse123 Profile Picture
    AT_AlanTse123 181 on at
    Re: ODATA Filter Query on Tomorrow

    Hi @v-mengmli-msft ,

     

    Thank you for your reply.

    I try your method, but it causes below error.

    AT_AlanTse123_0-1704267726651.png

    AT_AlanTse123_1-1704267748207.png

     

    May i know how to fix it?

     

    Thank you very much

  • v-mengmli-msft Profile Picture
    v-mengmli-msft on at
    Re: ODATA Filter Query on Tomorrow

    Hi @AT_AlanTse123 ,

     

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

    vmengmlimsft_0-1704266920755.png

     

     

    Best regards,

    Rimmon

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing Category Subscriptions!

Quick Links

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans