Solution: Microsoft Flow error “The query to field ‘/fieldname/LinkTitleNoMenu’ is not valid”

I recently ran into the following error message in Microsoft Flow that was triggered by a SharePoint – modified list item flow: “The query to field ‘/fieldname/LinkTitleNoMenu’ is not valid.” You’ll see this message in some cases when lookup columns are being utilized on the lists you’re referencing in Microsoft Flow.

This error was caused, at least for me, as a result of setting my “destination” list’s lookup column setting to display as Title (linked to item) instead of just Title. The following details the steps involved in fixing it.

Continue reading “Solution: Microsoft Flow error “The query to field ‘/fieldname/LinkTitleNoMenu’ is not valid””

“Edit in Word” (or Excel) not opening document in Office 365, or “Read-Only” status upon opening and trying to save changes

When working in Office 365 or SharePoint and you open a document for editing, you get two choices. Edit in Word (or Excel) or Edit in Browser. Editing in browser is typically a safe route but it doesn’t give you full functionality like the clients will.

The issue I’m discussing here is when a user tries to edit a document from SharePoint using the client (not Edit in Browser) the client opens to a blank, gray background (no document) or doesn’t open at all. This is likely an account conflict in syncing or accessing.

In other cases, the document may open, but as read-only. If that’s the case, it’s likely permissions-related. You might first check the user’s specific permissions in SharePoint. Sometimes because of broken (not inherited) permissions, or partial access to a site, users are able to edit in browser, but not in the client. If this is your situation, it could well be the cause.

Hopefully this is a simple fix for you, but as it’s become clear to me a number of times with this issue it can be quite complicated. I have a couple fixes, though the second is less ideal. If anyone else has run into this and would like to offer their experience, please do so in the comments.

Continue reading ““Edit in Word” (or Excel) not opening document in Office 365, or “Read-Only” status upon opening and trying to save changes”

“Server error: The version of Microsoft SharePoint Foundation running on the server is more recent than the version of SharePoint Designer that you are using. You need a more recent version of SharePoint Designer.”

servererror.png

Depending on your organizational setup, this message may be misleading. For me, this message is prompted when I change my password used to sign in to Office 365. My version of SharePoint Designer (SPD) is not, in fact, out of date at all. My organization regularly requires password changes so these steps get me back and running with SPD in less than a minute:

  1. After opening SPD, go to “Accounts” in the left hand menu
  2. Under “connected services” remove connections for whatever could be causing the issue
  3. Click “add a service,” then “storage,” then “Office 365 SharePoint”addservice
  4. Login with your new credentials. This should also link any OneDrive for Business account associated with your O365 account

If a password change isn’t what prompted your issue, try going to “Account” then “Switch Account” to make sure it’s attempting to connect to the correct account.

“Master page editing has been disabled for this site” SharePoint workaround

masterpageeditingdisabledSteps:

1. Open a copy of your master page
2. Make your edits
3. Upload your revised master page

Continue reading ““Master page editing has been disabled for this site” SharePoint workaround”