Recent Posts:
- Remove Characters From A String – The Easy Way!If you want to remove symbols from a string, for example these characters: Use the Replace() function. This example is with a string variable varString1: Replace() can be nested so you can continually replace individual characters to something else. In this example, we start with… Read more: Remove Characters From A String – The Easy Way!
- Power Apps with SharePoint – A Design BlueprintNearly all my Canvas-Power-App-with-SharePoint solutions follow the same architecture: This design approach can handle complex scenarios and easily scales to multiple environments.
- StartsWith() Index Pattern – Power Automate Flows to Parse SharePoint Column into Index ColumnsThese flows create or maintain the individual columns in a ‘StartsWith() Index’ pattern. Section 1 – Build the initial index in a separate list based on an existing list of records: The StartsWith() Index Pattern article describes this method in detail. This post is how… Read more: StartsWith() Index Pattern – Power Automate Flows to Parse SharePoint Column into Index Columns
- StartsWith() Index Pattern – Provide Power Apps Near Full Text ‘Keyword’ Searching that Supports Delegation to Large SharePoint ListsThis technique provides Power Apps near full text keyword searching capabilities for a large SharePoint list. The idea is to take the column you want to search and break it apart, word by word, into individual ‘index’ columns. Then you can StartsWith() search these columns,… Read more: StartsWith() Index Pattern – Provide Power Apps Near Full Text ‘Keyword’ Searching that Supports Delegation to Large SharePoint Lists