I have two functions that work on their own.... but can't figure out a way to combine them into one function.
Search(Sort('Permit Management','Project Name',SortOrder.Ascending),'Search Input'.Text,'Project Name','Work Order')
Filter('Permit Management','Project Status'='cmbProject Status Filter'.Selected.Value)
Permit Management = Dataverse table name
Project Status is a Choice Column with a combo box named Project Status Filter
Would you need more info than this?
@marshallzart - note that the code offered by @happyume is useful in case you're using SharePoint (the Search function is not delegable with that data source).
Thank you, I tried this but it ended up changing a lot of the Project Names from what they are named in the columns. The functions worked (ie sort, search and filter) though.
The solution Amik posted above did exactly what I was looking for though.
Thank you
This worked perfectly, I'm new to this so I will spend some time trying to understand how/why it works
Can you try this formula:
With(
{
baseTable:
Filter(
'Permit Management',
'Project Status'='cmbProject Status Filter'.Selected.Value
)
},
Sort(
Search(
baseTable,
'Search Input'.Text,
'Project Name','Work Order'
),
'Project Name',
SortOrder.Ascending
)
)
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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.
Sort(
Search(
Filter(
'Permit Management',
Len('cmbProject Status Filter'.Selected.Value) = 0 || 'Project Status' = 'cmbProject Status Filter'.Selected.Value
),
'Search Input'.Text,
'Project Name',
'Work Order'
),
'Project Name',
SortOrder.Ascending
)