Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

How to make not startswith funtion in get items

(0) ShareShare
ReportReport
Posted on by 62
Hi Experts:
   I want to filter the ID by not startswith, but it dosen't work, could you  help with it?
  • Expiscornovus Profile Picture
    Expiscornovus 31,008 on at
    How to make not startswith funtion in get items
    Hi @york,
     
    What type of field is CurrentStatus? 
     
    Not doesn't work in the OData Filter Query field of the Get Items action. Also have a look at this thread:
     
    As a workaround you could for example use a Filter Array action after this Get Items action. Or use a HTTP request with a $filter query parameter instead of the Get Items.

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

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,609

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,420

Leaderboard