Tuesday, July 13, 2021

Power Automate (Flow): Limit Columns by View

How to use the "Limit Columns by View"

App: Power Automate 

You may have tried to use the "Limit Columns by View" field and received something similar to: 

Error code: '400', Message: 'List View Not Found clientRequestId: 422C5F17-1C1B-46CD-AE5E-E3E2865D89D5 serviceRequestId: 422c5f17-1c1b-46cd-ae5e-e3e2865d89d5'. Client request id: '422C5F17-1C1B-46CD-AE5E-E3E2865D89D5'

Solution: You can't use the view name. You need to get the view ID (GUID).

  1. Browse to your list.
  2. Go to the view.
  3. Click on the view name.
  4. Click on "Edit current view".
  5. In the address bar you'll see something similar to: sharepoint.com/sites/dev/_layouts/15/ViewEdit.aspx?View=%7B8676E46D-E1C7-4A70-N2N2-BC7289A06F75%7D&List=%7BF413A77B-2EAF-4560-AAEE-EA904070318C%7D
  6. I've highlighted the part that you need to find in your URL. It's between the "View=%7B" and "%7D&List". This is the ID of the View. This is what you need for the "Limit Columns by View" field.



Tuesday, February 5, 2019

“The installation of this package failed” while installing a SharePoint update

Symptom: If you get the message “The installation of this package failed” while trying to install a SharePoint update.

Potential resolution: Check that you have enough hard drive space for the patch to extract and run. 

Tuesday, May 2, 2017

Opening a form as a Site Member gives: "Sorry, you don't have access to this page"

Symptom: 
You have a SharePoint list and the user reporting the issue is a Site Member. When the user tries to open a list item in view mode they are redirected to a page with the message: "Sorry, you don't have access to this page"

Issue: 
The issue I had was that one of the fields in the list was a person field. This field restricted the choice of people to a SharePoint Group. On checking this SharePoint security group. I found that the setting for this group "Who can view the membership of the group" was set to "Group Members".

Resolution:
Once I changed the "Who can view the membership of the group" to "Everyone" everything worked as expected.

Tuesday, April 25, 2017

Nintex Forms: Birthday Date Picker Year

Issue: By default the date picker will display the years as ±10 years. This is not suitable for a Date of Birth date picker. 

Fix:


  1. Edit the form in Nintex Forms.
  2. Double click the Date picker field.
  3. Open up the "Advanced" section.
  4. For setting "Store Client ID in JavaScript variable" change to "Yes".
  5. An additional field will be visible called "Client ID JavaScript variable name". Provide it a name. In my example it's called "birthdayControl".
  6. Click Save. Dialog will close.
  7. Click "NINTEX FORMS" on the ribbon.
  8. Click "Settings"
  9. Open up the "Custom JavaScript" section of the "Settings - Form" dialog.
  10. Add the following:
    NWF$(document).ready(function(){
          NWF$('#'+birthdayControl).datepicker('option',{yearRange:'-80:-0'});
    });
  11. Change the variables to suit your situation:
    1. birthdayControl: Client ID Variable set in step 5 above.
    2. -80: How many years back you want to display in the date picker.
    3. -0:How many years forward you want to display in the date picker.
  12. Click "Save". Dialog will close.
  13. Publish the form.
  14. Your specific date control should now show a more appropriate year selection for Date of Birth.

Tuesday, July 5, 2016

SharePoint 2013: Internet Information Services is not installed?

Symptoms:
While attempting to run the "SharePoint Products Configuration Wizard" for SharePoint 2013. You get a dialog which states:
"Internet Information Services is not installed. You must have Internet Information Services installed in order to use the SharePoint Products Configuration Wizard."
But your sure IIS is installed.

Issue:
Some IIS dependent services might not be running.

Fix:
Open up the Services Management Console (Press the Windows key. Then start typing Services. Open "Services")
Ensure the following services are running:
IIS Admin Service
World Wide Web Publishing Service

Sunday, August 9, 2015

Android Google widget: Searching just apps on the phone/device

Long version:
I recently upgraded from a Nexus 5 to a Samsung Galaxy S6. One thing that bugged me from this change was the way the Google search widget behaved. The Nexus 5 would present content on the device as quick results as you type the search phrase. This is what I used to quickly find apps and open them. On the S6 it would search the web, music, contacts, books and apps.

Short version:
To configure the Google search gadget to present apps as quick results:
Open up the apps tray.
Open up the Google folder and/or find "Google Settings".
Open up "Search & Now".
Open up "Phone Search".
Now you can select what the Google gadget searches.

I've only got "Apps" and "Contacts" selected. But it's up to you how you use this widget

Monday, February 3, 2014

SharePoint 2013: "Sorry, we're having trouble reaching the server"

Trying to add users to SharePoint groups.

When I type in a name I get the following message: "Sorry, we're having trouble reaching the server"

I had been tinkering with the web app directly in IIS (don't try this at home) and I disabled "Anonymous access". 

Apparently this is necessary for SharePoint to function. So don't mess with it.