-
Link formatting in Microsoft Search Result Types
If you’re reading this then you have probably been looking for a way to reformat a URL in your search results that is being returned as a property for items returned from a query against a content source. Like me you’ve probably found that the documentation around the JSON that can be used in a…
-
How to Craft Effective Prompts for Generative AI Models
Generative AI models are powerful tools that, based on a given input, can create original and diverse content, such as text, images, music, and code. However, to get the best results from these models, it is important to provide them with clear and specific prompts that guide the generation process. A prompt is a piece…
-
Prompt Engineering?
The more I use Microsoft Copilot and Bing Chat Enterprise (BCE) the more I’m coming to realise the importance of what and how you ask the AI for if you want the most meaningful answers or content. Like interacting with search engines, the more detail you provide the more context you provide for the information…
-
Using KQL in Microsoft Search
Using the Keyword Query Language (KQL) in your queries in Microsoft Search, you can restrict your search to only pull back the specific results you want. This is a very powerful way to limit search results when the available filters don’t meet your requirements and the bonus is that KQL works across all of the…
-
“getting your data” message after a PowerApps new form submission
I was recently building an app from scratch (start from blank not a template) that leverages a couple of SharePoint lists both of which the app writes items to at different times. When I encountered the message “Getting you data …” which is not strictly speaking an error but was definitely an issue. I had followed…
-
Fiscal year/quarter calculations
I have been doing some work in Microsoft PowerApps recently and found that as part of one of the application requirements it was necessary to calculate for the user the current fiscal year (e.g. FY19) as well as the current fiscal quarter (e.g. Q1, Q2, Q3 or Q4). This information was then used to pre-populate…
-
Provider Hosted App Error – Invalid issuer or signature persists after update
The Client Secret for one of our provider hosted apps expired yesterday and we started receiving the expected “[SecurityTokenException: Invalid issuer or signature.]” error. This happens every 12 months as the secret key by default expires 12 months after it is generated. When you create Provider/Remote Hosted app you have to generate a Client ID…
-
Adding an O365 Security group to the Site Collection Administrators group
Here is the scenario… you wish provision every site collection in your SharePoint Online environment so that a key group of staff, say for example your support staff, have Site Collection Admin access. To provide centralised control of this group you want to define it and its membership outside the boundaries of your SharePoint Online…
-
Report Performance – Dataset filters vs query parameters?
http://www.sqlchick.com/entries/2012/1/8/relating-parameters-filters-in-sql-server-reporting-services.html The two types of filters in SSRS are: Dataset Filter. This is the most common: filtering within the source query. When you implement a filter within the dataset, less data is sent over the network from the source database server to the Report Server – usually a good thing. Report Filter. This includes filtering…
-
What is my Site Collection Quota in SharePoint Online?
What is a Site Quota? Site Quotas allow you to define a limit on the storage capacity of a top-level site (in SharePoint terms a site collection).The storage limit applies to the site collection as a whole. In other words, the storage limit applies to the total size of the content for the top-level site and…