Sharepoint list - sending email of the list for expired dates

Fraser Mackenzie 0 Reputation points
2025-11-04T19:55:34.6166667+00:00

I am creating a process flow but cannnot get it to work.

User's image

User's image

I have then taken the list from my directory.

in the filter query i am adding in

User's image

But when i test this it says bad request.

The column name in the filter query and in the list are the same (i.e. in the URL of sharepoint list).

Any help is appreciated.

Microsoft 365 and Office | SharePoint | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ian-Ng 4,705 Reputation points Microsoft External Staff Moderator
    2025-11-04T22:11:12.6+00:00

    Hi @Fraser Mackenzie, 

    Welcome to Microsoft Q&A forum. 

    I understand you're building a Power Automate flow to send email notifications for expired dates in a SharePoint list, but it's failing with a 'Bad Request' error. This is happening even though you've already confirmed the Filter Query uses the correct internal column name from SharePoint.

    According to its description, it looks like you are having a problem with the Microsoft Power Automate flow. If my understanding is correct, as our category focuses on Office 365 products, the problem you encountered is related to Microsoft Flow, to ensure that you get professional help and avoid incorrect information from our side, we suggest you post on the Microsoft Power Automate Community for expert assistance. The best place to get assistance is the Microsoft Power Platform Community Forum Thread. 

    The community forum is actively monitored by Power Automate experts and dedicated users who are best equipped to help you diagnose and resolve this specific 'Bad Request' error. 

    undefined

    This forum is dedicated to Power Automate and is supported by a knowledgeable community, including Microsoft experts and partners. By posting there, you'll have access to more specialized resources and insights, which can help resolve your issue more effectively.  

    I hope this information is helpful and appreciate your understanding.

    Should you have any further questions, please feel free to reach out.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.