Data in collections not appearing in Power Apps
SharePains
by Pieter Veenstra
4d ago
Have you ever found that data in collections not appearing in Power Apps? Are you displaying data in collections from a data source while you haven’t used this data source directly in your UI controls? Explicit column selection If you have found that your galleries aren’t loading data then you might have fallen for the issues related to the Explicit column selection feature. So what does this feature do? When you load your data sources in Poweer apps you might expect that all this data gets loaded. When you read data sources that only contain real data then this might be ok, but just imagine ..read more
Visit website
How to use Microsoft Graph for SharePoint within Power Automate
SharePains
by Pieter Veenstra
4d ago
In this post a variety of options on how to use Microsoft Graph for SharePoint within Power Automate. My Microsoft Graph Series, so far I will start with a quick overview of the Microsoft Graph posts that I published recently. MS Graph API Authentication in Introduction Manage Users with the Graph API Manage calendars and events The Subscription model within Graph API using Power Automate Read Excel files faster using the Graph API Update Excel files using the Graph API SharePoint and the Graph API First of all the SharePoint connector within the Power Platform is quite good, so if you can ..read more
Visit website
Item vs items in Apply to each steps in Power Automate
SharePains
by Pieter Veenstra
1w ago
Today a short post, about the item function and the items function in Apply to each step. Apply to each in Power Automate When you create apply to each step you can use the Current item to refer to the item that is being processed within the apply to each step as shown below. Power Automate makes it easy to just select Current item from the Dynamic content and all is good! Until you looking under the hood of the Current item. We will see that the following expression is used when we select Current item: items('Apply_to_each') Nothing complicated. Copy/Paste actions But how about copying th ..read more
Visit website
Subscribe to Microsoft Graph using Power Automate
SharePains
by Pieter Veenstra
2w ago
In my series about the Graph API, I’m going to look at subscribe to ‘things’ to trigger a flow when events happen using Microsoft Graph in Power Automate. Subscriptions Using the subscription model it is possible to subscribe to any changes in on of the following: Call Records Channels Chat Chat Message Contact Conversation Members Drive Item Events Groups Group Conversation Lists Messages Presence Printers Print Task Definition Security Alert Teams To Do Tasks Users When you subscribe you can with different change types: created updated deleted Using these change types you can for exampl ..read more
Visit website
Manage Users using the Graph API in Power Automate
SharePains
by Pieter Veenstra
3w ago
When you manage user accounts within Power Automate, you can user the Office 365 Users connector, but sometimes the Graph API can give you more possibilities. Office 365 Users Connector The Office 365 Users connector gives some help with user management with the following actions: Get relevant people Get trending documents Get user photo Get user photo metadata Get user profile Search for user Update my profile Update my profile photo And then the most important of all actions Send an HTTP request (preview) Send an HTTP request (preview) As mentioned in yesterday’s introduction to the Graph ..read more
Visit website
Microsoft Graph API and the Power Platform
SharePains
by Pieter Veenstra
3w ago
This is going to be a large series of posts about the Microsoft Graph API and the Power Platform. Introduction to the Graph API I often get asked questions about the Graph API when using Power Automate. It can be difficult to get the configuration right. It only takes one character being wrong and the Power Automate might give you some unclear error message that takes you days to debug. What is the Microsoft Graph API? Well it is an API (application programming interface) that gives you access to a lot of the Microsoft Technology directly from your apps or flows. You can of course also use th ..read more
Visit website
A form with a multi-select dropdown with additional information collected for each selected option in Power Apps
SharePains
by Pieter Veenstra
1M ago
Yesterday I was asked on the chat here, if it is possible to use a multi-select dropdown in a form and then ask for each selected option some additional information. In this post the pattern that you could follow. Use case In my example I will have a form where I’m asking for working days and then for each working day I will ask for a range of working hours. The development of the solution all starts with data. In this case SharePoint is used. So I am goin to create two SharePoint lists. The first list is the My working days list, with the out of the box Title field and a Working days multi s ..read more
Visit website
Quickly find the parent from the child flow in Power Automate
SharePains
by Pieter Veenstra
1M ago
When you have used child flows and attempted to debug issues you will have come across the issue where you want to find the parent flow for the failing child flow. Parent – Child flows In this example I’ve created a simple set of flows. There is one parent flow and there is a child flow. The parent flow calls my child flow using the Run a child flow action. Then the Child flow has a manual trigger and does something before it responds back to the parent flow. Flow runs There are many flow runs of my parent flow after a while. And I will also have quite a few runs for my child flow. At some ..read more
Visit website
Create multi user real time apps in Power Apps
SharePains
by Pieter Veenstra
2M ago
When multiple users edit data and you want your app to show real time data, you will need a multi user real time app. It isn’t a good idea to reload all your data every time someone might have updated data. The data setup I’m going to use SharePoint as my data store within this post, however the pattern could be applied to any database, such as SQL or Dataverse. First of all I’m creating a list that will hold my data that is used by the app. So my list is called Data and it has a column Title. nothing special. But you can make your list as complicated as you like. Now when i create an app th ..read more
Visit website
Sort by Title in your Highlighted Content web part in SharePoint
SharePains
by Pieter Veenstra
2M ago
Yesterday I was asked about how to sort Documents in the Highlighted Content web part by the Title property. To sort by Title you will have to go through some extra steps. SharePoint Search web parts First I would like to take you through some history. In the year 2016, I wrote a blog post about making the Title field sortable in the classic SharePoint search web parts. And for the Highlighted content web part we have to roughly go through the same steps. SharePoint Search hasn’t changed very much and the important thing to notice is that the Title Property is still not sortable. So when you ..read more
Visit website

Follow SharePains on Feedspot

Continue with Google
OR