Unsupported expression in good old InfoPath

Even though Is been announced that InfoPath is deprecated, but supported until April 2023 you can read more here  the reality is that there is a significant amount of customers that still rely on the InfoPath form based solutions for dealing with data entry challenges in the organization on a daily basis. As a consultant, I currently support multiple clients on InfoPath Form related issues. Today I want to talk about a recent discovery and of course share the solution. This is a custom list with an InfoPath list form used for storing OA’s (Operational Activities) assignment information, of course, … Continue reading Unsupported expression in good old InfoPath

Video

Prevent Document Download in SharePoint Online

Good day colleagues, wanted to share with you all how to configure a document library that doesn’t allow users to download his content. In our scenario here is to expose a document library to a group of people inside the company, but the requirement was that these people shouldn’t be able to download the content, this is just a document library for content consumption, no collaboration at all and of course read only for visitors.

It is simple to achieve the desired outcome because there is a permission already in the system that allows us exactly what we need, but it has some limitations that you should know first before you commit to deliver what business ask us to do.

As general understanding please read the following descriptions about the permissions already available in SharePoint, please read to the end because you will see what permissions makes sense for us to use.

  • Full Control – Has full control.
  • Design – Can view, add, update, delete, approve, and customize.
  • Edit – Can add, edit and delete lists; can view, add, update and delete list items and documents.
  • Contribute – Can view, add, update, and delete list items and documents.
  • Read – Can view pages and list items and download documents.
  • View Only – Can view pages, list items, and documents. Document types with server-side file handlers can be viewed in the browser but not downloaded.

Yes, the View Only permission gives us the required behavior. In other words, this permission allows us to visualize documents inside a browser (of course with the help of Office Web Apps or Office Online Server) and documents cannot be downloaded. The question here is: What are the documents we can visualize in the browser using Office Online Server? The answer is Only Office Documents and what Office Documents are we talking about? Word, PowerPoint, Excel.

This means that:

PDF or any other file type that is not an office document can be downloaded ☹

Let’s explore how to configure this:

  1. Create a security group that has the View Only permission
  2. Create and configure a document library
  3. Test with another user that the download is not possible

Let’s see it in action here in this video, since now, thanks for reading, thanks for watching, thanks for sharing.

Just use a Office 365 based credential when deploying programatically

So all people happy and kind of impress with Office 365 Pattern & Practices components, especially the ones that are related to Office 365, is so much easier and simpler the provision things up to SharePoint Online. Recently had to deploy some assets into SharePoint Online, I did use Office 365 PnP as our deployment approach. Everything work just fine in our Office 365 Dev environment but as soon I got to customer tenant our deployment console app didn’t work as expected. First I notice that customer had ADFS set up and the code when trying to authenticate was throwing … Continue reading Just use a Office 365 based credential when deploying programatically

Formulas to get the first and last row on a repeating table in InfoPath

You know, you wake up knowing that is going to be a wonderful day working for a customer with the software products you love. During today on-site support session, you found out that is needed to write some good old XPath formulas on an InfoPath form. There is a repeating table with the columns necessarily to describe travel information like Departure Date, Return Date, City, you named and the requirement was to expose the initial Departure Date and the last Return Date of the entire trip, so, what do we mean with entire trip? I maybe start a trip from … Continue reading Formulas to get the first and last row on a repeating table in InfoPath

SharePoint pushed to its limits

Have you been interested in knowing how intranets get together? Or what practices teams follows in order to design/build/deploy and support an enterprise intranet? I did had the question too, and one of the resources I have been following for a couple of years now is the Nielsen Normal Group Intranet Design Award. This is a competition conducted by the Nielsen Norman Group called annual intranet design to identify the world’s 10 best intranets. In this report you can see very interesting topics that will definitely give a broader idea on what it takes to build and deploy a top … Continue reading SharePoint pushed to its limits

A quick tale from the SharePoint support trenches

Basically, the customer had a workflow, build in SharePoint Designer 2010 that will use some of the out of the box Actions like the Pause for Duration and Send Email. The issue was that once the workflow paused for a minute it wasn’t able to resume the work, leaving the workflow always running “In Progress”. Doing some research found KB2674684 SharePoint 2010: Workflow failed to run after pause and according to the description made me remember my good old ASP.NET developer days. The bottom line is that SharePoint on premise is ultimately a Microsoft ASP.NET solution that works with multiple … Continue reading A quick tale from the SharePoint support trenches

Fail patching your SharePoint 2010 farm for apparent no reason

Act 1: You notice that health analyzer is warning you that some updates needed to applied on the server X and server Y. Act 2: You download the KB2956080 and properly install on both good old SharePoint 2010 servers Act 3: Run the psconfig -cmd upgrade -inplace b2b -wait command and “Missing installs error is displayed” How the play was called? Fail patching your SharePoint 2010 farm for apparent no reason At some point SharePoint loses track of the CU version information between the registry, windows installer and SharePoint but with just one magic PowerShell command you can force and … Continue reading Fail patching your SharePoint 2010 farm for apparent no reason

Discover SharePoint Web Services methods and parameters and feel nostalgic about it

This is not the first time that a customer has an issue with SharePoint Web Services “. asmx” and InfoPath Forms that I need to quickly spot and fix. Of course SharePoint Web Services work as a charm, but sometimes the problem comes more to InfoPath forms how they consume the services SOAP response and request headers. Yes, I’ve said InfoPath. A lot of customers still work and use InfoPath forms, they created and automated HR or IT process using these wonderful technologies and we, support engineers need to support. A lot of customers still have a dependency on InfoPath. … Continue reading Discover SharePoint Web Services methods and parameters and feel nostalgic about it

Thanks Microsoft & SharePoint Community

MVP for 11 years now, but always feel like the first time. Thanks to Microsoft for the MVP Award this year. Also thanks to my fellow colleagues and SharePoint community for their awesomeness. I am proud and happy to be around another year especially when new version of our favorite product is coming. Thanks.  

Speaking at SharePoint Saturday San Diego

Got approved to participate as speaker in the SharePoint Saturday San Diego event next November 15, 2014. Awesome content, awesome speakers, awesome venue, awesome city. I will share some experiences on how to enhance document collaboration with SharePoint, what out of the box features we can use to simplify how people collaborate en enhance the end user experience. Those little tips & tricks that make the difference for end users. Event Details: Registration Schedule Session Details: Enhance the way people collaborate with documents in SharePoint  Come and learn those extra settings we can turn on to enhance the way people collaborate with … Continue reading Speaking at SharePoint Saturday San Diego