JSON Pivoting in Power Automate

JSON Pivoting in Power Automate

Transforming objects in Power Automate is mostly a challenge. Here is an example for you. Let’s imagine, I want to convert a JSON array of key-value pairs into an object in my Power Automate Flow. Correct, I want some kind of pivoting. In detail, here is my JSON array which I want to pivot: The result should be a single object: Ok, let’s start. JSON Array pivot into an Object as Power Automate Flow First, I’m creating a new Power…

Read More Read More

Using GenAI – Generate my Meeting Minutes!

Using GenAI – Generate my Meeting Minutes!

Today I will share another example where I utilize Generative AI with you. Although the story is explained quite quickly. Documenting meeting minutes can be a tedious task, especially when I am an active participant. However, the outcome of the meeting is crucial as I need to share the action items and results with my colleagues. What if I had a buddy who could do this task for me? Right, I use my Generative AI for this. In other words,…

Read More Read More

Setup GitHub Codespace for AWS Development

Setup GitHub Codespace for AWS Development

I recently came across a new way to write and create source code. I had been looking for an alternative because my computer didn’t have the necessary administrative privileges to install software and the resources available on it were also limited. In detail, I had no Git for source code management, no Docker Runtime, no AWS Command Line Interface (AWS CLI), and no AWS Cloud Development Kit (AWS CDK). In other words, I was lost, but I discovered GitHub Codespaces….

Read More Read More

Using GenAI – Create Demo Data

Using GenAI – Create Demo Data

Generative AI can do a lot for me. Today I’ll share a common example with you where I use my Microsoft OpenAI chatbot to simplify my life. My common example is, I need demo data and my AI Assistant will help me to setup this data in seconds. Moreover, I will use my own copilot that I deployed some weeks ago as an Azure Web Application (read more: Using Azure OpenAI in Business). In detail, I need an excel file…

Read More Read More

Amazon Q – Single Sign-On with Microsoft Entra ID

Amazon Q – Single Sign-On with Microsoft Entra ID

Creating a new Amazon Expert Q for Business application was straight forward. I wrote about this in my last blog post. You have seen, I uploaded documents from my local folder directly in Amazon Q. Afterwards, Amazon Q indexed my documents and automatically created a search index. Finally, I tested Amazon Q in the web experience preview. Great job so far! Today, I’ll deploy the web application and configure my Microsoft Azure tenant to act as the identity provider. I…

Read More Read More

Amazon Q!

Amazon Q!

Amazon Q is the new star at AWS Cloud. No, no it is not only another AI powered chatbot! First, Q comes across in two flavors. As Amazon Q (For AWS Builder Use), Q is your smart AI buddy for AWS which assist you with understanding, creating, expanding, and managing AWS applications. Well, this is like a built-in copilot for AWS. But wait, there is much more than that! Amazon Q is also made for business. As Amazon Q (For…

Read More Read More

Embedding Vector for Azure AI Search

Embedding Vector for Azure AI Search

My SharePoint documents are already integrated in Azure AI Search (Azure Cognitive Search). I explained the setup in my last blog post. In detail, I created a Search Index for my SharePoint site which contains some of my conference presentations (PPTX) and handouts (PDF) files. I realized during testing; Azure OpenAI can access the information by using Azure AI Search as a retriever tool with some limitations. But I haven’t added embedding vector or similarity search in Azure AI Search….

Read More Read More

Power Platform – Trigger Environment Activity

Power Platform – Trigger Environment Activity

You know the story, sometimes other things are more important and you forget to clean up. What happen is, after a while you get an email from Microsoft. Right, this email reminds you about the automated cleanup of my inactive Power Platform environments. This is good, because it helps to reduce unneeded resources. I got this email from one of my Demo Environments: In detail, I use this Dataverse Environment to simulate Application Lifecycle Management for Power Platform. In this…

Read More Read More

AWS Single Sign-On with Microsoft Entra ID

AWS Single Sign-On with Microsoft Entra ID

Single Sign-On (SSO) is a great thing! It simplifies my life in more ways than one. With SSO, I only need one username and password from my Microsoft account to access multiple websites and apps. This is making my online experience easier and more secure. It also saves me from password fatigue and streamlines the management of my accounts. The benefits are huge, but how can I setup Single Sign-On for my AWS accounts? In other words, I want also…

Read More Read More

Azure Cognitive Search and SharePoint for Azure OpenAI

Azure Cognitive Search and SharePoint for Azure OpenAI

In my last blog post, I explained how I use a Power Automate Flow to add my documents to Azure Cognitive Search. In detail, I copied selected files to my central Azure Blob Storage. This is not the best solution, but it outlines the possibilities of Automation in combination with Azure Cognitive Search. This time I show you, how I index my documents from SharePoint directly with Azure Cognitive Search. Right, I don’t copy my files to another storage. Now,…

Read More Read More