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
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / SharePoint Query Error...
Power Apps
Answered

SharePoint Query Error: The requested operation is invalid. The query is not valid.

(0) ShareShare
ReportReport
Posted on by takolota1 4,980 Moderator

Hello,

I have a problem where a Gallery Items formula isn't working when I try to filter by building or date. I have a very similar formula working just fine for a different application, but it won't work here.

 

The formula works in this entry log app when the building and date filters are empty.
WorksWithoutDateOrBldg.png


However, once I put in a building or date filter, nothing shows up and I get this error saying the query is invalid.

Doesn'tWork.png

Error.png

 

 

Strangely enough, I initially copied the query from this other application where it does work when I filter by date or building:
WorksHere.png

 

Here's the formula on the entry log application where it isn't working:

 

If(IsNumeric(Value(TextInput10.Text)),
//If search is for a room number
 If(
 //If a date is not selected and a building is not selected.
 IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
 Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
 //If a date is selected and a building is not selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
 Filter(Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
 //If a date is not selected and a building is selected.
 IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
 //If a date is selected and a building is selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text))))),

//If search is not for a room number
 If(
 //If a date is not selected and a building is not selected.
 IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
 Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
 //If a date is selected and a building is not selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
 Filter(Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
 //If a date is not selected and a building is selected.
 IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
 //If a date is selected and a building is selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text))))



The only change I made from the working medication application to the not working entry log application, is I switched out the Search functions with Filter & StartsWith functions so I could make everything delegable. But I'm not having any problem with searching by name or room in the not working entry log application, I'm only having issues filtering by building or date.

Maybe there's some issue with the query now that it's trying to delegate everything to SharePoint instead of pulling records in first? Or maybe it's something else.

Is anyone familiar with similar issues?

Categories:
Building Power Apps
I have the same question (0)
  • Ramole Profile Picture
    Ramole Super User 2024 Season 1 on at

    @takolota 

     

    It will easier if you post your formula as a text format  

    Capture.JPG

  • takolota1 Profile Picture
    takolota1 4,980 Moderator on at

    Here is the medication log formula that isn't throwing an error:


    If(
    IsNumeric(Value(TextInput10.Text)),
    //If search is for a room number
    If(
    //If a date is not selected and a building is not selected.
    IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
    Filter(
    SortByColumns(
    RSA_Medication_Log,
    "Created",
    Descending
    ),
    (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text) + 1) Or (Room >= 10 * Value(TextInput10.Text) And Room < 10 * (1 + Value(TextInput10.Text))) Or (Room >= 100 * Value(TextInput10.Text) And Room < 100 * (1 + Value(TextInput10.Text)))
    ),
    //If a date is selected and a building is not selected.
    Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
    Filter(
    Filter(
    SortByColumns(
    RSA_Medication_Log,
    "Created",
    Descending
    ),
    Created >= DatePicker8.SelectedDate And Created < DateAdd(
    DatePicker8.SelectedDate,
    1,
    Days
    )
    ),
    (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text) + 1) Or (Room >= 10 * Value(TextInput10.Text) And Room < 10 * (1 + Value(TextInput10.Text))) Or (Room >= 100 * Value(TextInput10.Text) And Room < 100 * (1 + Value(TextInput10.Text)))
    ),
    //If a date is not selected and a building is selected.
    IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
    Filter(
    SortByColumns(
    Filter(
    RSA_Medication_Log,
    Bldg = ComboBox1.Selected.Result
    ),
    "Created",
    Descending
    ),
    (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text) + 1) Or (Room >= 10 * Value(TextInput10.Text) And Room < 10 * (1 + Value(TextInput10.Text))) Or (Room >= 100 * Value(TextInput10.Text) And Room < 100 * (1 + Value(TextInput10.Text)))
    ),
    //If a date is selected and a building is selected.
    Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
    Filter(
    Filter(
    SortByColumns(
    Filter(
    RSA_Medication_Log,
    Bldg = ComboBox1.Selected.Result
    ),
    "Created",
    Descending
    ),
    Created >= DatePicker8.SelectedDate And Created < DateAdd(
    DatePicker8.SelectedDate,
    1,
    Days
    )
    ),
    (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text) + 1) Or (Room >= 10 * Value(TextInput10.Text) And Room < 10 * (1 + Value(TextInput10.Text))) Or (Room >= 100 * Value(TextInput10.Text) And Room < 100 * (1 + Value(TextInput10.Text)))
    )
    ),
    //If search is not for a room number
    If(
    //If a date is not selected and a building is not selected.
    IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
    Search(
    SortByColumns(
    RSA_Medication_Log,
    "Created",
    Descending
    ),
    TextInput10.Text,
    "Client",
    "Medication"
    ),
    //If a date is selected and a building is not selected.
    Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
    Search(
    Filter(
    SortByColumns(
    RSA_Medication_Log,
    "Created",
    Descending
    ),
    Created >= DatePicker8.SelectedDate And Created < DateAdd(
    DatePicker8.SelectedDate,
    1,
    Days
    )
    ),
    TextInput10.Text,
    "Client",
    "Medication"
    ),
    //If a date is not selected and a building is selected.
    IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
    Search(
    SortByColumns(
    Filter(
    RSA_Medication_Log,
    Bldg = ComboBox1.Selected.Result
    ),
    "Created",
    Descending
    ),
    TextInput10.Text,
    "Client",
    "Medication"
    ),
    //If a date is selected and a building is selected.
    Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
    Search(
    Filter(
    SortByColumns(
    Filter(
    RSA_Medication_Log,
    Bldg = ComboBox1.Selected.Result
    ),
    "Created",
    Descending
    ),
    Created >= DatePicker8.SelectedDate And Created < DateAdd(
    DatePicker8.SelectedDate,
    1,
    Days
    )
    ),
    TextInput10.Text,
    "Client",
    "Medication"
    )
    )
    )


    I can't format the entry log formula because it says there is an error. But I tried re-doing the formula from the above med log formula and just switching out the data source.

    If(
    //If a date is not selected and a building is not selected.
    IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
    Search(
    SortByColumns(
    'Entry & Exit Logs',
    "Created",
    Descending
    ),
    TextInput10.Text,
    "Title"
    ),
    //If a date is selected and a building is not selected.
    Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
    Search(
    Filter(
    SortByColumns(
    'Entry & Exit Logs',
    "Created",
    Descending
    ),
    Created >= DatePicker8.SelectedDate And Created < DateAdd(
    DatePicker8.SelectedDate,
    1,
    Days
    )
    ),
    TextInput10.Text,
    "Title"
    ),
    //If a date is not selected and a building is selected.
    IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
    Search(
    SortByColumns(
    Filter(
    'Entry & Exit Logs',
    Bldg = ComboBox1.Selected.Result
    ),
    "Created",
    Descending
    ),
    TextInput10.Text,
    "Title"
    ),
    //If a date is selected and a building is selected.
    Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
    Search(
    Filter(
    SortByColumns(
    Filter(
    'Entry & Exit Logs',
    Bldg = ComboBox1.Selected.Result
    ),
    "Created",
    Descending
    ),
    Created >= DatePicker8.SelectedDate And Created < DateAdd(
    DatePicker8.SelectedDate,
    1,
    Days
    )
    ),
    TextInput10.Text,
    "Title"
    )
    )
    )



    Strangely when I use the formula above with the Search instead of the Filter & StartsWith, filtering by building and date work, but it still throws an error warning about an invalid query.

  • RandyHayes Profile Picture
    RandyHayes 76,299 Super User 2024 Season 1 on at

    @takolota 

    Please replace your formula with the following:

    With({_roomNumber: IfError(Value(TextInput10.Text), 0),
 _searchText: If(IsNumeric(TextInput10.Text), "", TextInput10.Text) },

 SortByColumns(
 	Search(
 Filter(RSA_Medication_Log,
 (_roomNumber = 0 || 
 (Room >=_roomNumber && Room <_roomNumber + 1) ||
 (Room >= (_roomNumber * 10) && Room < (10 * (_roomNumber + 1))) ||
 (Room >= (_roomNumber * 100) && Room < (100 * (_roomNumber + 1)))
 ) &&
 (IsBlank(DatePicker8.SelectedDate) || (Created >= DatePicker8.SelectedDate && Created < DateAdd(DatePicker8.SelectedDate,1,Days)) &&
 (IsBlank(ComboBox1.Selected.Result) || Bldg = ComboBox1.Selected.Result)
 ),
 _searchText, "Client", "Medication"
 ),
 "Created", Descending
 )
)

    This will provide the same results as your long "If" formula and will be easier to maintain.

     

    In the second prat of your original formula (after the I can't format... statement), you are then trying to filter by a different datasource - 'Entry & Exit Logs'.  You cannot use two different datasources like that on an items property. 

    So, I'm not really sure where that one fits in or how you anticipated using it.

    If you can clarify that a bit more, I might be able to provide some guidance there as well.

     

    I hope this is helpful for you.

  • takolota1 Profile Picture
    takolota1 4,980 Moderator on at

    Hello Randy,

    I had to change a few parts of that to get it to work because Value(TextInput.Text) doesn't seem to error if it isn't a number so if the searchbox / text input is blank it doesn't show anything.
    Also I specifically SortByColumns first to get the most recent records 1st if it runs into any delegation issues. So that formula looks like this:

     

     

    With({_roomNumber: If(IsNumeric(Value(TextInput10.Text)), Value(TextInput10.Text), 0),
 _searchText: If(IsNumeric(TextInput10.Text), "", TextInput10.Text)},
 Search(
 Filter(
 SortByColumns(
 'Entry & Exit Logs',
 "Created",
 Descending
 ),
 (_roomNumber = 0 || (Room >= _roomNumber && Room < _roomNumber + 1) || (Room >= (_roomNumber * 10) && Room < (10 * (_roomNumber + 1))) || (Room >= (_roomNumber * 100) && Room < (100 * (_roomNumber + 1)))) && (IsBlank(DatePicker8.SelectedDate) || (Created >= DatePicker8.SelectedDate && Created < DateAdd(
 DatePicker8.SelectedDate,
 1,
 Days
 )) && (IsBlank(ComboBox1.Selected.Result) || Bldg = ComboBox1.Selected.Result))
 ),
 _searchText,
 "Title"
 )
)

     

     

    However, it looks like this formula introduces more delegation issues than the previous one.

    FineButDelegation.png

     

    I am ultimately trying to get the following delegable formula to work for the Entry & Exit Logs datasource. I am not trying to use 2 datasources, I was just mentioning that a similar formula works with another application & datasource.

     

    Delegable formula I want to work:

     

    If(IsNumeric(Value(TextInput10.Text)),
//If search is for a room number
If(
//If a date is not selected and a building is not selected.
IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
//If a date is selected and a building is not selected.
Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
Filter(Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
//If a date is not selected and a building is selected.
IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
//If a date is selected and a building is selected.
Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
Filter(Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text))))),

//If search is not for a room number
If(
//If a date is not selected and a building is not selected.
IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
//If a date is selected and a building is not selected.
Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
Filter(Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
//If a date is not selected and a building is selected.
IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
//If a date is selected and a building is selected.
Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
Filter(Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text))))

     

      

  • Verified answer
    takolota1 Profile Picture
    takolota1 4,980 Moderator on at

    Okay, I tested each piece of the formula and found that some simple re-organizing fixed the issue, but I don't know why.

    Instead of doing multiple Filter functions for date, building, and InputText, I combined some of the Filters with an And statement. I wonder if SharePoint has some limit on the amount of nested filters you can do or something.

    Here's the fully delegable formula for a searchbox, date filter, and category filter:

    If(IsNumeric(Value(TextInput10.Text)),
//If search is for a room number
If(
 //If a date is not selected and a building is not selected.
 IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
 Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
 //If a date is selected and a building is not selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
 Filter(Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
 //If a date is not selected and a building is selected.
 IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text)))),
 //If a date is selected and a building is selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)), (Room >= Value(TextInput10.Text) And Room < Value(TextInput10.Text)+1) Or (Room >= 10*Value(TextInput10.Text) And Room < 10*(1+Value(TextInput10.Text))) Or (Room >= 100*Value(TextInput10.Text) And Room < 100*(1+Value(TextInput10.Text))))),

//If search is not for a room number
If(
 //If a date is not selected and a building is not selected.
 IsBlank(DatePicker8.SelectedDate) && IsBlank(ComboBox1.Selected.Result),
 Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)),
 //If a date is selected and a building is not selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && IsBlank(ComboBox1.Selected.Result),
 Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), (Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)) And (StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text))),
 //If a date is not selected and a building is selected.
 IsBlank(DatePicker8.SelectedDate) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(SortByColumns('Entry & Exit Logs', "Created", Descending), Bldg = ComboBox1.Selected.Result And (StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text))),
 //If a date is selected and a building is selected.
 Not(IsBlank(DatePicker8.SelectedDate)) && Not(IsBlank(ComboBox1.Selected.Result)),
 Filter(SortByColumns(Filter('Entry & Exit Logs', Bldg = ComboBox1.Selected.Result), "Created", Descending), (Created >= DatePicker8.SelectedDate And Created < DateAdd(DatePicker8.SelectedDate, 1, Days)) And (StartsWith(FirstName, TextInput10.Text) Or StartsWith(LastName, TextInput10.Text)))))

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 136 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 109 Super User 2026 Season 2

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