Skip to content
  • Microsoft Power Platform
    • Microsoft Power Automate
    • Microsoft Power BI
    • Microsoft Power Apps
    • AI Builder
  • Microsoft 365 / Office 365
    • Microsoft SharePoint Online
    • Microsoft Teams
    • Microsoft Office Online
    • OneDrive for Business
    • Microsoft Forms
  • Microsoft Azure
  • Microsoft Dynamics 365
  • About
    • About the Author Pieter Veenstra
    • Contact SharePains today!
    • My Published Articles elsewhere…
    • Privacy Policy
  • Power Automate, the ultimate user guide!
  • Power Apps, the ultimate user guide
  • Share your pains today!
  • About the Author Pieter Veenstra
  • Contact SharePains today!
!New!
Filter Query in SharePoint Get Items in Power Automate 3 Ways to add a column to an array in Power Automate Patch any field type in a SharePoint list item using Power Apps Call flows from a model driven app Variables or Compose? Consider neither in Power Automate Your 1st lesson in Power Apps, in a few easy steps! Create new tabs in your Teams in Microsoft Teams using Power Automate Who can create new environments in the Power Platform How to handle leavers in Power Automate How to embed a canvas app in your model driven app Automatically re-enable flows that were suspended in Power Automate The target in the Launch function in Power Apps Create new group alert using Power Automate Delegation Warnings in Power Apps 1 Top tip: PowerPlatformLearn.com and master the Power Platform within no time
  • Facebook
  • Twitter
  • LinkedIn
  • GitHub
  • Reddit
SharePains by Pieter Veenstra
SharePains

SharePains by Pieter Veenstra

Office 365, Power Platform, SharePoint, Azure and Dynamics

  • Microsoft Power Platform
    • Microsoft Power Automate
    • Microsoft Power BI
    • Microsoft Power Apps
    • AI Builder
  • Microsoft 365 / Office 365
    • Microsoft SharePoint Online
    • Microsoft Teams
    • Microsoft Office Online
    • OneDrive for Business
    • Microsoft Forms
  • Microsoft Azure
  • Microsoft Dynamics 365
  • About
    • About the Author Pieter Veenstra
    • Contact SharePains today!
    • My Published Articles elsewhere…
    • Privacy Policy
Friday, January 22, 2021
  • Power Automate, the ultimate user guide!
  • Power Apps, the ultimate user guide
  • Share your pains today!
  • About the Author Pieter Veenstra
  • Contact SharePains today!

Month: March 2020

Get 1 item in an array in Power Apps

SharePains Home | Archives for 2020 | Archives for March

Get 1 item in an array in Power Apps

A While back I wrote a post about arrays in Power Automate. Today I will look at arrays in Power Apps. Create an Array In a Flow you can create … read the get-1-item-in-an-array-in-power-apps post

Get item in Array in Power Apps Comment on Get 1 item in an array in Power Apps
The new Tests feature in Power Apps

SharePains Home | Archives for 2020 | Archives for March

The new Tests feature in Power Apps

Recently the option to add tests to your Power Apps has been added. This this post I will have a look at this new experimental feature. Tests (experimental) The new … read the power-apps-tests-feature post

Comment on The new Tests feature in Power Apps
10 Policies to consider when implementing Microsoft Teams

SharePains Home | Archives for 2020 | Archives for March

10 Policies to consider when implementing Microsoft Teams

If Microsoft Teams is just about turning it on and point people to the right location to get started then why are there so many policies to be configured in … read the policies-implementing-microsoft-teams post

Policies in Microsoft Teams 3 Comments on 10 Policies to consider when implementing Microsoft Teams
Quickly edit data in your Common Data Service

SharePains Home | Archives for 2020 | Archives for March

Quickly edit data in your Common Data Service

When you use the Common Data Service as a data source it can be quite cumbersome to edit data. Most of the times I used to just create a form … read the edit-data-in-you-common-data-service post

edit data in Common Data service Comment on Quickly edit data in your Common Data Service
Create super fast joins of 2 arrays in Power Automate

SharePains Home | Archives for 2020 | Archives for March

Create super fast joins of 2 arrays in Power Automate

On my The advanced Pieter’s method in Power Automate post, I received a comment asking about joins when using json arrays. In this post I’ve assumed that you have read the … read the create-joins-in-power-automate post

Inner joins using json 10 Comments on Create super fast joins of 2 arrays in Power Automate
2 New filter options in Get Files action in SharePoint connector

SharePains Home | Archives for 2020 | Archives for March

2 New filter options in Get Files action in SharePoint connector

Remember last week’s posts about getting all files in a folder in SharePoint? I used the Send an http request to SharePoint action avoiding the odata filter options in the … read the 2-new-filter-options-in-get-files-in-sharepoint post

Folder filter in SharePoint connector 2 Comments on 2 New filter options in Get Files action in SharePoint connector
Enable controls for owners in Power Apps

SharePains Home | Archives for 2020 | Archives for March

Enable controls for owners in Power Apps

How often do you want to enable controls for owners only when you work with Power Apps? Many applications have some debug screens or little help features that you need … read the enable-controls-for-owners-only-in-power-apps post

Admin only controls in Power Apps Comment on Enable controls for owners in Power Apps
5 Power Platform projects developers must know!

SharePains Home | Archives for 2020 | Archives for March

5 Power Platform projects developers must know!

When you get started with Power Platform projects, you will quite quickly find all sorts of hurdles on your way. The Power Platform projects mentioned in this post may help … read the power-platform-projects-developers-must-know post

Comment on 5 Power Platform projects developers must know!
Get all files in a SharePoint folder using Power Automate

SharePains Home | Archives for 2020 | Archives for March

Get all files in a SharePoint folder using Power Automate

So often I hear complaints about SharePoint actions in flow not working. In this post I will look at the complication when you try to get all files in a … read the get-all-files-in-a-sharepoint-folder post

Get all files form a SharePoint folder 12 Comments on Get all files in a SharePoint folder using Power Automate
The advanced Pieter’s method in Power Automate

SharePains Home | Archives for 2020 | Archives for March

The advanced Pieter’s method in Power Automate

Yesterday, I noticed John Liu and Brian Dang discuss Pieter’s method. This method is referring tot my post of using a compose action inside an apply to each and then … read the pieters-method-for-advanced-in-flows post

The advanced Pieter's method 7 Comments on The advanced Pieter’s method in Power Automate
3 steps to read csv files from SharePoint

SharePains Home | Archives for 2020 | Archives for March

3 steps to read csv files from SharePoint

In this post I will give a pattern for reading a csv file form SharePoint. An example csv file For this post I created a csv file with 3 columns … read the read-csv-files-from-sharepoint post

read csv file in SharePoint 47 Comments on 3 steps to read csv files from SharePoint
Get the result of your failed actions in Power Automate

SharePains Home | Archives for 2020 | Archives for March

Get the result of your failed actions in Power Automate

Today, I bumped into the result function in Flow. We can now collect failed action details directly within the flow and report the failures in flows. Failures in Flows When … read the get-the-result-of-your-failed-actions post

result function in Power Automate 2 Comments on Get the result of your failed actions in Power Automate
Sort an array in Power Automate in 3 easy steps

SharePains Home | Archives for 2020 | Archives for March

Sort an array in Power Automate in 3 easy steps

A while back I wrote about how to sort an array in Power Automate and I used an Azure function to do the job. One of the annoying things of … read the sort-an-array-in-power-automate post

Sort and array in you flow 5 Comments on Sort an array in Power Automate in 3 easy steps
Looking for a different post?
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 4,627 other subscribers

Links
  • hybrIT Services HybrIT Services, this is where I work HybrIT Services, this is where I work
  • Microsoft Flow and PowerApps User Group Milton Keynes Join the UK Microsoft Flow and PowerApps User Group Milton Keynes Join the UK Microsoft Flow and PowerApps User Group Milton Keynes
  • ULS Monitor Monitor your SharePoint logs and see the issues before users do. Monitor your SharePoint logs and see the issues before users do.
  • Collab 365 today Get the latest news from over 365 blogs Get the latest news from over 365 blogs
  • Community Connect Are you looking for speakers or local technology experts? Are you looking for speakers or local technology experts?
Top posts
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
Archives
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • May 2013
  • March 2013
  • October 2012
  • May 2012
  • April 2012
  • March 2012
  • January 2012
  • December 2011
  • November 2011
  • August 2011
  • July 2011
  • June 2011
  • January 2011
  • December 2010
SharePains Privacy Policy