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

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / THE REQUESTED OPERATIO...
Power Apps
Unanswered

THE REQUESTED OPERATION IS INVALID. SERVER RESPONSE: Controls Support Failed: The query is not valid.

(0) ShareShare
ReportReport
Posted on by Compsci28 16

This is the part of my formula that throws the error. Does anything look wrong?

 

 

AddColumns(
Search(
Filter(
Filter(
Sort(
'Controls Support',
'Requested Date',
If(
iptStatus_4.SelectedText.Value = "Open",
Ascending,
Descending
)
),
'Ref Assignee' = datAssignee_4.Text
),
Or(
IsBlank(iptStatus_4.SelectedText.Value),
'Ref Status' = iptStatus_4.SelectedText.Value
),
Or(
IsBlank(iptCategory_4.SelectedText.Value),
'Ref Category' = iptCategory_4.SelectedText.Value
),
Or(
IsBlank(iptDivision_4.SelectedText.Value),
'Ref Division' = iptDivision_4.SelectedText.Value
),
'Ref Status' = "Open" || 'Ref Status' = "Closed" || 'Ref Status' = "Declined"
),

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 155,752 Most Valuable Professional on at

    Hi @Compsci28 ,

    Can you please provide the whole formula and use Format Text in a text box as below

    AddColumns(
 Search(
 Filter(
 Filter(
 Sort(
 'Controls Support',
 'Requested Date',
 If(
 iptStatus_4.SelectedText.Value = "Open",
 Ascending,
 Descending
 )
 ),
 'Ref Assignee' = datAssignee_4.Text
 ),
 Or(
 IsBlank(iptStatus_4.SelectedText.Value),
 'Ref Status' = iptStatus_4.SelectedText.Value
 ),
 Or(
 IsBlank(iptCategory_4.SelectedText.Value),
 'Ref Category' = iptCategory_4.SelectedText.Value
 ),
 Or(
 IsBlank(iptDivision_4.SelectedText.Value),
 'Ref Division' = iptDivision_4.SelectedText.Value
 ),
 'Ref Status' = "Open" || 'Ref Status' = "Closed" || 'Ref Status' = "Declined"
 ),

     

  • Compsci28 Profile Picture
    Compsci28 16 on at

    AddColumns(
        Search(
            Filter(
                Filter(
                    Sort(
                        'Controls Support',
                        'Requested Date',
                        If(
                            iptStatus_4.SelectedText.Value = "Open",
                            Ascending,
                            Descending
                        )
                    ),
                    'Ref Assignee' = datAssignee_4.Text
                ),
                Or(
                    IsBlank(iptStatus_4.SelectedText.Value),
                    'Ref Status' = iptStatus_4.SelectedText.Value
                ),
                Or(
                    IsBlank(iptCategory_4.SelectedText.Value),
                    'Ref Category' = iptCategory_4.SelectedText.Value
                ),
                Or(
                    IsBlank(iptDivision_4.SelectedText.Value),
                    'Ref Division' = iptDivision_4.SelectedText.Value
                ),
                'Ref Status' = "Open" || 'Ref Status' = "Closed" || 'Ref Status' = "Declined"
            ),
            varSearchText,
            "Title",
            "Details",
            "CustomerName",
            "Requester",
            "From"
        ),
        "Requester Name",
        Coalesce(
            LookUp(
                'Controls Support Customers',
                Email = Requester
            ).Name,
            If(
                EndsWith(
                    Requester,
                    "@muratec-usa.com"
                ),
                Trim(
                    Concatenate(
                        IfError(
                            First(
                                Office365Users.SearchUser(
                                    {
                                        searchTerm: Requester,
                                        top: 1
                                    }
                                )
                            ).GivenName,
                            ""
                        ),
                        " ",
                        IfError(
                            First(
                                Office365Users.SearchUser(
                                    {
                                        searchTerm: Requester,
                                        top: 1
                                    }
                                )
                            ).Surname,
                            ""
                        )
                    )
                )
            ),
            Requester
        )
    )

  • Compsci28 Profile Picture
    Compsci28 16 on at

    @WarrenBelz any ideas.?

  • WarrenBelz Profile Picture
    WarrenBelz 155,752 Most Valuable Professional on at

    @Compsci28 ,

    Firstly, your syntax composes as correct (another reason I wanted Format Text), so there is not formula error as such.

    Then apart from the nested Filter (which you do not need as you can put it all in one statement) and the Sort "inside" rather than wrapping it around the whole formula, the top bit looks fine.

    I do not use the Office365Users connector, so cannot comment on that area (although you said there were no errors there.

    The only other comment is that I have found Search and Filter do not always "play well together" and I tend to use an In statement with the rest of the filter and this has always worked.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Compsci28 Profile Picture
    Compsci28 16 on at

    @WarrenBelz  Can you show me how it would all fit into one statement.?

  • WarrenBelz Profile Picture
    WarrenBelz 155,752 Most Valuable Professional on at

    HI @Compsci28 ,

    Firstly, I cannot possibly test this and I free-typed it, so I will have to leave you to fix any stray/missing brackets or commas, but you will get the idea of the syntax required.

    Sort(
 AddColumns(
 Filter(
 'Controls Support',
 'Ref Assignee' = datAssignee_4.Text ||
 (
 IsBlank(iptStatus_4.SelectedText.Value) &&
 'Ref Status' = iptStatus_4.SelectedText.Value
 ) ||
 (
 IsBlank(iptCategory_4.SelectedText.Value) &&
 'Ref Category' = iptCategory_4.SelectedText.Value
 ) ||
 )
 IsBlank(iptDivision_4.SelectedText.Value) &&
 'Ref Division' = iptDivision_4.SelectedText.Value
 ) ||
 'Ref Status' = "Open" || 
 'Ref Status' = "Closed" || 
 'Ref Status' = "Declined" ||
 varSearchText in Title ||
 varSearchText in Details ||
 varSearchText in CustomerName||
 varSearchText in Requester ||
 varSearchText in From
 ),
 "Requester Name",
 Coalesce(
 LookUp(
 'Controls Support Customers',
 Email = Requester
 ).Name,
 If(
 EndsWith(
 Requester,
 "@muratec-usa.com"
 ),
 Trim(
 Concatenate(
 IfError(
 First(
 Office365Users.SearchUser(
 {
 searchTerm: Requester,
 top: 1
 }
 )
 ).GivenName,
 ""
 ),
 " ",
 IfError(
 First(
 Office365Users.SearchUser(
 {
 searchTerm: Requester,
 top: 1
 }
 )
 ).Surname,
 ""
 )
 )
 )
 ),
 Requester
 ),
 'Controls Support',
 'Requested Date',
 If(
 iptStatus_4.SelectedText.Value = "Open",
 Ascending,
 Descending
 )
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Compsci28 Profile Picture
    Compsci28 16 on at

    @WarrenBelz  Thank you Warren! I will try it out

  • WarrenBelz Profile Picture
    WarrenBelz 155,752 Most Valuable Professional on at

    Just checking if you got the result you were looking for on this thread. Happy to help further if not.

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Compsci28 Profile Picture
    Compsci28 16 on at

    No im still getting the same error

  • Compsci28 Profile Picture
    Compsci28 16 on at

    @WarrenBelz I am most likely typing it in wrong. I copy and pasted this from another app that is doing the exact same thing, and working, it is just for a different department. I copied the entire formula over and just changed the list it is connecting to which is identical to the the list from the old formula

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
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 483

#2
WarrenBelz Profile Picture

WarrenBelz 399 Most Valuable Professional

#3
11manish Profile Picture

11manish 327

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans