Infopath 2013 – mandatory lookup fields in provisioned sites

For a current project, I am back to wonderful world of SharePoint 2013 and InfoPath! I was amazed at how easy it all came back and how working and publishing forms could be so easy. Nevertheless, I was confronted with an issue I didn’t know how to resolve.

This title might be slightly cryptic so let me describe the scenario we were in: For a customer, we had a SharePoint 2013 top level site that would create project subsites based on a master list. Every subsite had a specific list that contained mandatory look up values as metadata.

To make matters more difficult, we also had to show the list form in InfoPath.

We had an issue with saving the form because the lookup field never thought it was filled in. Only when we made the field not-mandatory our form would be saved. And this one really had to be mandatory and we started to think on how we could get a workaround for it..

Thankfully a brilliant coworker (Thanks Ward!) could help us out with this one..

The solution is to have the form load without any default values. But wait, I hear you say, I don’t have any default values for this field? I know, but still you have to change it..


So how do you set it up?

Step 1: go to info – Advanced Form options

Step 2: in the Advanced tab , go to default values

Step 3: find the field in the datafields group and deselect the field

Now publish the InfoPath form and it should work.

About: Marijn

Marijn Somers (MVP) has over 14 years experience in the SharePoint world, starting out with SP2007. Over the years the focus has grown to Office 365, with a focus on collaboration and document management. He is a business consultant at Balestra and Principal Content Provider for "Mijn 365 Coach" that offers dutch employee video training. His main work tracks are around user adoption, training and coaching and governance. He is also not afraid to dig deeper in the technicalities with PowerShell, adaptive cards or custom formatting in lists and libraries. You can listen to him on the biweekly "Office 365 Distilled" podcast.

%d bloggers like this: