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
Solved! Go to Solution.
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
)
)
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
208 | |
98 | |
60 | |
51 | |
43 |
User | Count |
---|---|
258 | |
160 | |
85 | |
79 | |
57 |