If you connect a Power Automate workflow to a PowerApp, you call the Run() method and can pass it parameters. If the PowerApp isn't allowing you to add parameters to Run(), just select your object and under Action select Power Automate. Remove the Flow and re-add it, and you should then be able to add the parameters you want to pass.
Thursday, March 25, 2021
Tuesday, February 23, 2021
The gallery view in SharePoint is great, especially when used to show people. For example, I've created a New Hire list that is populated by a Powershell script that pulls in any new hires nightly. But the images for the people are tiny:
But it's SO CLOSE to what we're looking for!
So with a couple of quick edits, you can increase the size of those images.
- From your Views, select "Format the current view":
Monday, February 1, 2021
If you're an owner of a team and you try to add the Tasks by Planner tab and get the "We couldn't save your tab settings. Please try again.":
Wednesday, September 30, 2020
Here's a PnP Powershell script that copies all views from one SharePoint list to another list:
# Url to the site
$siteUrl = "https://vivity.sharepoint.com"
# The list where we want to copy all of the views
$listWithViewsToCopy = "Banana"
# The list name to copy the views to
$listToCopyTo = "Pineapple"
Write-Host "Connecting to PnP..."
Connect-PnPOnline -Url $siteUrl -Credential (Get-credential)
# Get all the views and properties for the list
$viewsToCopy = Get-PnPView -List $listWithViewsToCopy -Includes "ViewQuery","ViewType","ViewData","ViewJoins","ViewProjectedFields","RowLimit","Paged"
# Loop through each view and create it in the new list
foreach ($view in $viewsToCopy)
Write-Host "Adding View: "$view.Title
# Loop through all fields and create an array
$fields = [System.Collections.ArrayList]::new()
# Add the new view
Add-PnPView -List $listToCopyTo -Title $view.Title -Fields $fields -Query $view.ViewQuery -ViewType $view.ViewType -RowLimit $view.RowLimit
Thursday, June 11, 2020
Monday, June 8, 2020
The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator
To get around that, add a query with the scope of RecursiveAll to your query like so:
Connect-PnpOnline -Url 'https://vivity.sharepoint.com/sites/sitename' -Credentials (Get-Credential)
$query = "<View Scope='RecursiveAll'><RowLimit>5000</RowLimit></View>"
$items = Get-PnPListItem -List 'My List' -Query $query
Thursday, October 3, 2019
The following steps describe how to create this:
Upload the template files and css
First, download the the code from the following in github: https://github.com/sregan1/SharePoint-Office365/tree/master/Sites%20Directory
Open up SharePoint Designer and select on All Files in the left hand navigation. Then go to /_catalogs/masterpage/Display Templates/Content Web Parts. Copy Control_Sites_Directory.html and Item_Sites_Directory.html here. Edit the url in these files (where it says "vivity.sharepoint.com") to your url.
Go to Site Assets, and create a Styles folder (if not there already), and copy SitesDirectory.css there.
Setup the web part query
edit it, hit the Change Query button, Switch to Advanced Mode and paste in the following "contentclass:STS_Site" into the Query text box