Provision SharePoint Lists with Power Automate from April Dunnam

Learn how to use PowerAutomate to create a Sharepoint list and a Sharepoint DocLibary. This is especially useful as a template for new SharePoint lists.

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Upload & tag multiple file attachments with Power Apps from Reza Dorrani

Here I learned how to upload multiple files from Powerapps, via Flow (PowerAutomate), to Sharepoint or CDS (DataVerse). In addition, I can store metadata on the uploaded files.

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Power Apps filter multiple selections – Exact or All options – Try again from Shane Young

In this video you will learn “RenameColumn”, “AddColumn” and “Clearcollect with multiple selection”. I like these features because it allows me to optimize performance.

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

Using global variables in Power Virtual Agents from Tomasz Poszytek

Here I learned how to set a global variable. (in PowerApps this would be SET) The simple variables are otherwise only available in the current topic. (in PowerApps this would be UPDATECONTEXT)

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

How To Find The DataVerse Table For Power BI from Daniel Christian

A good tip on how to read & evaluate data with PowerBi from the DataVerse.

You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.

PowerApps testing (incl. monitoring)

Step 1: Go to the Advanced tools in the PowerApp (https://eu.create.powerapps.com/studio/). There please first select “Tests (experimental)”.

Step 2: Go to the “Copy play link” on the top right in the following screen (“Tests”) and generate the link. (For this purpose, please make a “record”, above left, of the complete test)

Step 3: Go in Step 1 to “Monitor (preview)” and in the next screen at the top right to “Play published app”

Step 4: Copy everything from the “Monitoring-URL” to / incl. “&mep = …” and add this to the link from Step 2. -> With this link the testing is carried out and recorded in the monitoring at the same time.

How to create a folder in OneDrive for Business

I was recently asked by a colleague whether you can also create folders automatically. My answer was expressed quite legally: “It depends.” Because with OneDrive for Business it is currently not possible to take a direct route.

But where there’s a will, there’s a way. For this I simply took advantage of the fact that if you want to create a file, you can also create a folder at the same time.

  1. Here I just chose a manual trigger by entering a folder name.
  2. With FolderPath I have selected the parent folder -> select “add dynamic content” -> separate from the folder name with “/”.
  3. Since I am not interested in the file, I simply delete it again in this step.

Have fun creating folders.

How to create a notification for completed tasks in Planner with Microsoft Flow

The biggest problem is usually that you assign a task to someone else via Microsoft Planner and you don’t know when this task will end. In addition, most notifications only inform you that this has ended.

However, I wanted a notification containing the direct link to the completed task and the description. This means that additional information can be communicated in the description field. (The description field can be changed directly via the Planner Task or via Microsoft To-Do)

  1. I used the TaskComplete as a trigger.
  2. So that I also get the details of this task, I fetch this information with TaskDetails.
  3. Via Completer (Office 365 users -> Retrieve user profile) I get the email address of the person who completed the task.
  4. Here I repeat step 3, only with the “Value Created by User ID” to determine the creator of the task.
  5. In the last step, the notification email is created. The mail goes to the Creator and the Completer in the CC.

For the direct link to the task, you need the grid like in the picture (left) “https://tasks.office.com/XXX/de-ch/Home/Task/” and directly behind the ID of the task.

Now I wish you a lot of fun with the new TaskComplete notification.

Addition: Here you can find your grid for your organization.