Modern Collaboration on Microsoft 365, Power Platform, Azure and more...

Autor: Marvin Bangert (Seite 1 von 4)

Power BI RLS from SharePoint column

Hi folks,

Sometimes you get data not from a database, but as a file like CSV and you need to visualize it in Power BI, but not giving access to the data for everyone. And worse, the people are not mentioned in the file itself. Today I will show you how you can control access to a specific file using SharePoint and Row Level Security (RLS) in Power BI. This trick only works if your users User Principal Name (UPN) is the same as the email. Let’s start.

Weiterlesen

Power Automate – Rename SharePoint file

Hey folks,

Today, there is a short quick tip on how to change the name of a document using Power Automate.

As you figured out already, when you are using the “Update file properties” action within Power Automate, you are only able to update the title field of a document, but not the name of the document. To update the file name, you need to use the “Send an HTTP request to SharePoint” action and update the field “FileLeafRef” as it references to the “name column” of the SharePoint library.

Weiterlesen

Power Automate – SharePoint trigger non-default flows

Hey folks,

This post will be a brief overview of how to trigger a Power Automate flow, which is not inside the default environment, from SharePoint.

As you may have noticed, if you create a flow using the SharePoint triggers “For a selected item” or “For a selected file” within a non-default environment, you cannot find it within the “Automate” option inside a SharePoint list or library.

Weiterlesen

PowerAutomate – Create SharePoint site collection

Hey folks,

In this post you will learn how to create a SharePoint site collection using Power Automate. I will also explain the different parameters to configure, prerequisites and how to check if a site already exists. Also you will learn about the parameter “SensitivityLabel” to actually apply a sensitivity label to your site while creation and why you shouldn’t use “Classification” anymore.

Weiterlesen

Different ways how to deploy SharePoint Syntex model

Hey folks!

today we will learn how to deploy a SharePoint Syntex Model on a SharePoint library in different ways. Especially, when you want to automatically deploy it on a SharePoint library, e.g. for each new project or department site, it can get a bit more complex to automate everything. Unfortunately, currently it’s not possible to deploy it using a SharePoint site template, but I will show you all other ways how to deploy it.

Weiterlesen

Power BI: Divison wanted – my German ‘Bezirksliga’ suggestion

Hey folks,

if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.

Weiterlesen
« Ältere Beiträge

© 2024 Cloudkumpel

Theme von Anders NorénHoch ↑