Alternative to the ‘in’ operator for Power Apps when filtering SharePoint data
Sep12

Alternative to the ‘in’ operator for Power Apps when filtering SharePoint data

Many of you may already have faced some delegation limitations when using SharePoint as a data source for your canvas apps. When the operation or filter is delegable, it means the query results are processed by the data source and returned to Power App rather than being processed locally in the App, with a maximum of 2000 items to be returned per call. For performance reasons, the default… Continue Reading Michel Mendes’s...

Read More
Power Apps & SharePoint: Dynamically get the site URL from lists used in an App (and make your app Flows easily reusable)
Aug29

Power Apps & SharePoint: Dynamically get the site URL from lists used in an App (and make your app Flows easily reusable)

Imagine a situation you create a Power Apps button triggered Power Automate Flow. This Flow stores a file in SharePoint from data in the app and you need to use the same Power Automate Flow idea in different Power Apps canvas apps. It’s basically the same Flow just the flow to export content from the app to a file in a SharePoint. Would you recreate the same flow and edit the copies over and… Continue Reading...

Read More
Enable Azure Application Insights in Power Apps canvas apps
Jul03

Enable Azure Application Insights in Power Apps canvas apps

Power Platform already gives us some statistics related to canvas apps usage from the Power Apps home or Admin Center, which are really good, but those feature statistics related to the whole app, not to a specific screen, or related to user screen flow. But luckily we can easily have that in place with Azure Application insights. What is Azure Application insights? Azure Application Insights… Continue Reading...

Read More
Trigger a Flow only if a specific user modified a SharePoint list item
May16

Trigger a Flow only if a specific user modified a SharePoint list item

If you want to proceed running actions in a Power Automate Flow only if a specific user did the change in a SharePoint list item, you can easily use a condition and manage that. But this will consume one Flow run from your daily runs allowance. To do this before the Flow is executed, you can use Trigger conditions to achieve it. So the Flow will be triggered only if the formula specified as… Continue Reading michelcarlo’s...

Read More
Avoid unsupported characters errors when creating Teams channels in a Flow
May02

Avoid unsupported characters errors when creating Teams channels in a Flow

If you want to automate Microsoft Teams Channels using Power Automate Flows, you can use a simple action named ‘Create a channel’ from the Teams Connector in your Flows (still in preview at the time of writing this post – May 2020). But due to naming restrictions, if you use unsupported characters (~#%&*{}+/:<>?|’”..) in the channel name, you will get errors related to that and the...

Read More
Quick tip: Force Power Automate Flows to be executed in a queue instead of multiple instances
Apr27

Quick tip: Force Power Automate Flows to be executed in a queue instead of multiple instances

The default behaviour of a Power Automate Flow is to allow multiple instances of the same flow running. But depending on the scenario or implementation, this can be a big problem, for example, a Flow that is triggered when an item is modified and then based on that iterates through a big list of items and updates a field. Especially when it comes to SharePoint Online, the Flow can be throttled… Continue Reading...

Read More
PowerShell script: Prevent Power Apps users from accessing lists from SharePoint UI
Apr15

PowerShell script: Prevent Power Apps users from accessing lists from SharePoint UI

Power Apps with SharePoint lists as a data source are becoming widely built, especially due to licensing, as if a company already has the Microsoft 365/Office 365 enterprise plans, SharePoint connectors for Power Apps are included (while Azure SQL/Common Data services and others require premium plans). If we connect any SharePoint list to Power Apps, it has to be shared with all users for them… Continue Reading...

Read More
SharePoint HTTP connector: Send a no-reply email from a specific sender name in a Flow
Apr04

SharePoint HTTP connector: Send a no-reply email from a specific sender name in a Flow

ally if there’s a need for a no-reply email message in Power Automate Flows, the Mail connector is used. But when using Mail connector the sender display name can’t be changed. It will always be “Microsoft Power Apps and Power Automate”. However, if the message needs to be sent to internal users within your tenant only, an alternative approach using SharePoint Rest API and the ‘Send an HTTP…...

Read More
Power Automate – SharePoint ‘Get Items’ action: New options for folders
Mar21

Power Automate – SharePoint ‘Get Items’ action: New options for folders

Recently a new option was released in Power Automate (formerly Microsoft Flow) which is available in the SharePoint action ‘Get Items’: Limit Entries to Folder Include Nested items The same settings have recently been included in the action ‘Get files (properly only)’: For some people, it would make sense to see those settings for files and not in a list as by default folders are not… Continue Reading...

Read More
Manage Power Automate Flows with a Power Automate Flow??
Oct27

Manage Power Automate Flows with a Power Automate Flow??

I recently came into a situation where I needed to add a user as co-owner for all of the flows under another user account, where there are lots of flows created. Did I add the user manually in every flow? No, I created a flow to add the user as owner in my Flows! In this post, I will quickly show how to build this simple and useful flow. In order to easily trigger the Flow manually, create it… Continue Reading...

Read More
Automatically export Power BI Reports to files in SharePoint
Oct19

Automatically export Power BI Reports to files in SharePoint

Do know how easy is to automatically save Power BI exported reports into SharePoint or other data sources? Check a simple way of automating this process in this post. First things first, for the report you want to automate the ‘Capture’, you’ll need to set up a Power BI Report subscription, so you’ll receive report updates on your Office 365 Outlook mailbox. From this e-mail message, we… Continue Reading...

Read More
What’s the story with SharePoint certifications?
Jul20

What’s the story with SharePoint certifications?

I constantly receive questions regarding SharePoint certifications and recommendations of what to study and get up to speed with what’s new in the SharePoint world, so I decided to wrap up the main topics here (no news, it’s mainly to summarise the recommendations). What are the current SharePoint developer certifications available? At the moment, there are no active SharePoint developer… Continue Reading...

Read More
Microsoft Flow – How to move SharePoint Online list items to folders
Mar04

Microsoft Flow – How to move SharePoint Online list items to folders

Let’s say you have a SharePoint list with folders organized by continent and you have as well a choice column with the continent name in this. You want to move automatically all the list items with the chosen continent to the specific continent folder. The first idea would be to use Microsoft Flow to do that, but there is no out-of-the-box action that moves list items to folders. At the… Continue Reading michelcarlo’s...

Read More
SharePoint Modern Lists: Force forms to open in full size
Jan20

SharePoint Modern Lists: Force forms to open in full size

SharePoint list forms on modern experience lists will open in a dialog side box by design (at the moment of writing this post, no out-of-the-box options are available to change this). In my opinion for non-customized forms that’s ok, but for PowerApps forms in SharePoint lists, the layout is not fine when the form layout becomes large, due to currently the forms inside the lists not being… Continue Reading michelcarlo’s...

Read More
Security Trimming PowerApps based on Office 365 Groups
Jan15

Security Trimming PowerApps based on Office 365 Groups

PowerApps already does security trim for item-level permissions based on the Data Source permissions, but in some cases you may want to implement extra rules or more complex trimming types that are not possible with the selected Data Source. That’s when Office 365 groups come to help. Showing or hiding controls in a PowerApps based on Office 365 group membership is not obvious but it is not… Continue Reading michelcarlo’s...

Read More
Using Eircode (Ireland Postcodes) to get Geolocation from Google Maps with Microsoft Flow
Dec08

Using Eircode (Ireland Postcodes) to get Geolocation from Google Maps with Microsoft Flow

Let’s say you have a SharePoint list storing information with an Eircode column (postal code for addresses in Ireland), and you want to use that information in Power BI later to generate a map organizing all your items by location. Unfortunately, the Power BI maps don’t work fine with Eircodes, so how could we get the locations with the most precise information? Let’s use Microsoft Flow… Continue Reading michelcarlo’s...

Read More
Do you want to get up to speed in PowerApps?
Aug19

Do you want to get up to speed in PowerApps?

Do you want to start building your business applications with PowerApps and don’t know where to start? I’ve been working with PowerApps + Flow on top of Office 365 for a while, and as am always studying and learning new stuff, I came across with some different content sources to get updated. Here are some excellent resources to begin with: Developing Business Applications with Power Apps… Continue Reading...

Read More
Project Online – Setting up default SharePoint field values with Microsoft Flow and Project/SharePoint Rest API
Jul22

Project Online – Setting up default SharePoint field values with Microsoft Flow and Project/SharePoint Rest API

In this post, it’ll be shown how to set the default Risks list items title based on Project Name in project online, with the help of Microsoft Flow, Project Online Rest API and SharePoint Online Rest API. The “Send an HTTP request to SharePoint” allows us to overcome lots of the out-of-the-box SharePoint/Project Online Flow connectors limitations, by accessing various different… Continue Reading michelcarlo’s Article on...

Read More

SCOTtish summit 2021

On February the 27th Scottish Summit 2021 will come to you as a virtual event. With over 250 sessions from all Microsoft technologies. You need to register for your FREE ticket and download the Scottish Summit App to see all the great sessions.