Your company is having an AI Summit next week and you want to promote the Hashtag #AIwithPowerGI to grow your online presence and to foster communication between attendees, sponsors, and speakers. You can of course have your Community Manager review the comments and get general insights on how the Summit went: Is the perception positive, […]
Check how you are doing in social media with AI Read More »
Let’s suppose you are a legal company that receives hundreds of emails daily that relate to contracts for both Companies (legal entities) and Individuals. You need to separate those two different types of emails in different folders because they are processed differently. Your mailbox looks something like this: Your contacts always send you the name
Classify your emails based on Subject using AI Read More »
We will create an Azure Function that will merge PDF documents stored in a container of our storage account in Azure, this function will receive the file names to be merged/combined in the parameters of the URL and they will be separated by commas. Below is an example of the POST request that the code
Azure Function to combine PDF files Read More »
Client secret credential type is straight forward in Power Automate, you only need to grab the secret value, paste it in the right field and you are good to go! For Certificate credentials, you need an additional step for the Pfx field value – it is simple to complete though. Let’s see how we can
Active Directory OAuth in Power Automate Read More »
In the last days Microsoft announced that Power Automate Desktop is now available for all Windows 10 users at no cost, regardless if the user has an Office365 subscription or not. In their efforts of “democratizing” automation they have opened the doors for pretty much anybody: you just need download the latest version of Power
Power Automate Desktop: now available at no additional cost. Read More »
NOTE! You can take a look at our most recent post on this topic, that is updated with the most recent features: https://powergi.net/2022/07/11/everything-about-downloading-files-from-the-web-using-power-automate/ Power Automate has evolved a lot in the recent months, and with their Desktop application they have expanded the possibilities of automation. However, it has limitations when it comes to download files
Power Automate Desktop Read More »
Use an excel table to modify your SQL query If you regularly run queries to any database in your workplace, chances are you have encountered a user request like this: We can use Excel to query the database and get the information requested, but you will have to manually write the WHERE conditions that include
Dynamic SQL queries with Excel’s Power Query Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called Sample File, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have missing columns? In the below example,
Combine Files With Slightly Different Columns Read More »
When we connect to a folder to combine all the files, Power Query creates a “Query” called “Sample File”, which is used as example to process each file, the results will depend on the columns that exist in this file. But what happens when any of the files have less columns than others? In the
Power Query Files from Folder: Read More »
Combining files with Power Query is great but what happens when some unformatted files have less columns?
Learn How to Combine Tables With Slightly Different Columns Read More »
