Hello all,
I was hoping by now someone would have shared some similar experience but maybe I haven't supplied enough information. Please see below code statements and attached screenshots to understand functionality.
I did find an interim solution but that solution was defeated moments ago. I was able to successfully create a new SharePoint Column called RefID which was a calculated column where I specifically told the formula to "look" at the default ID and populate itself into this new column. It worked.... Up until I update an item in my SharePoint list using my PowerApps. The RefID column resets to zero and I get sad.....
Alright, enough of that. See below for code and screenshots.
SortByColumns(Filter(Filter(Filter(Filter(Filter(iProductIssues, StatusValue <> "Not Assigned"),
StartsWith(RefID, SearchInput_9.Text)),
StartsWith(Title, SearchInput_1.Text)),
StartsWith(OwnerValue, SearchInput_2.Text)),
StartsWith(IssueAdminValue, SearchInput_5.Text)),
"PriorityValue",
If(SortDescending1,Descending,Ascending))
The underlined code statement is the one I wish I could just type in:
StartsWith(ID, SearchInput_9.Text
Unfortunately, PowerApps will not let me search the default ID column in SharePoint by doing this. Grrr..
Here is what my UI looks like to give a better understanding of functionality:
User Interface Search Functionality
Basically, my users can search the gallery multiple ways but the ID field is a critical one as once an issue is assigned, that user can simply type the ID number and go right to it.
I'm open to ideas on how to fix this.
Here is also my SharePoint Column formatting:
