cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tadchya19
Frequent Visitor

The requested operation is invalid. Server Response: Meeting Room Request Form failed

Hi

I need your help 
I found the error : The requested operation is invalid. Server Response: Meeting Room Request Form failed: The expression "(([object Object])and(End_x0020_Date gt '2022-05-18'))" is not valid. Creating query failed. clientRequestId: 3f437c50-4d49-444e-8f35-34c742bcfde7 serviceRequestId: 3f437c50-4d49-444e-8f35-34c742bcfde7 

i don't know why
this is the Code in Gallery Item

If(
Subtitle1.Text = "Admin",
Filter(
'Meeting Room Request Form',
'Start Date' <= Today() And 'End Date' >= Today(),
(ComboBox1.Selected.Value = Title || ComboBox1.Selected.Value = "All")
),
Filter(
'Meeting Room Request Form',
User().Email = Title1.Text,
'Start Date' <= Today() || 'End Date' >= Today(),
(ComboBox1.Selected.Value = Title || ComboBox1.Selected.Value = "All")

))

Thank

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@tadchya19 

Try 

 

With({wfltr1: Filter(
                      'Meeting Room Request Form', 'Start Date' <= Today() And 'End Date' >= Today(),
                       ComboBox1.Selected.Value = Title || ComboBox1.Selected.Value = "All"
               ),
       wfltr2: Filter(
                      'Meeting Room Request Form', User().Email = Title1.Text,
                                          Or('Start Date' <= Today(), 'End Date' >= Today()
                                          ),
                                          Or(ComboBox1.Selected.Value = Title, 
                                              ComboBox1.Selected.Value = "All"
                                           )
              )
     },

   If(
      Subtitle1.Text = "Admin", wfltr1, wfltr2
    )
)

 

View solution in original post

2 REPLIES 2
Drrickryp
Super User
Super User

@tadchya19 

Try 

 

With({wfltr1: Filter(
                      'Meeting Room Request Form', 'Start Date' <= Today() And 'End Date' >= Today(),
                       ComboBox1.Selected.Value = Title || ComboBox1.Selected.Value = "All"
               ),
       wfltr2: Filter(
                      'Meeting Room Request Form', User().Email = Title1.Text,
                                          Or('Start Date' <= Today(), 'End Date' >= Today()
                                          ),
                                          Or(ComboBox1.Selected.Value = Title, 
                                              ComboBox1.Selected.Value = "All"
                                           )
              )
     },

   If(
      Subtitle1.Text = "Admin", wfltr1, wfltr2
    )
)

 

It Worked !! 👍

 

Thank you very much

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,294)