web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Formatting Filter Query
Power Automate
Unanswered

Formatting Filter Query

(0) ShareShare
ReportReport
Posted on by

Shyan_0-1687980815341.png

 

When written as shown above everything works fine.

However, when the column name is two words (shown below) it no longer works, and tells me "Bad Request"

 

Shyan_1-1687980919613.png

 

Is there a character to represent the "space"? Please advise

Categories:
I have the same question (0)
  • ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @Anonymous 

     

    Pls use the internal name for the field as Filter query works with internal name.

     

    To find the internal name, pls follow the below steps:

    1. Navigate to SharePoint list settings:

    ManishSolanki_0-1687982775136.png

     

    2. Select the 'End date' column in the 'Columns Section'. In this example, I am looking for internal name of column 'hyperlinkpictureCol':

    ManishSolanki_1-1687982859818.png

     

    3. The internal name will be the value of 'Field' query parameter (part after = symbol):

    ManishSolanki_2-1687982986382.png

     

     

    If this helps & solve your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

  • Community Power Platform Member Profile Picture
    on at

    It did not fix it, I still get the BadRequest error. It might be important to note that End Date is a value from a foreign key. Please let me know if you have any other solution.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard