cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RKnighton88
Advocate II
Advocate II

Unable to submit form due to 'Title' field required, but is not there

Hi,

 

I have created a form via my sharepoint and as many of you will know it always adds a 'Title' field. I have removed this from the Form, connected the data on my app arranged the icons and all other aspect seem to be working. However, when I am submitting the form after completing, I get an error saying that data is missing - this is due to that little annoying 'Title' field. 

 

How to I prevent this from happen? Is there anything I can do to bypass it? Or how do I find it? I cannot seem to see it anywhere on my my form on my application. Quite a confusing one, I didn't have this issue last time. 

 

Thanks in advance. 

17 REPLIES 17

Hi @Pstork1 

Yes this has always been an problem with SharePoint for years since about 2001 !

 

But until recently, you could ignore the "Title" field. - You could set it to "Optional" and PowerApps / SHarePoint would respect that.  Now whatever you set the "Title" column to, PowerApps / SharePoint bounces any Submits - Title: Field Required.  (Patches still work though !) This is very annoying as there has been no announcements made saying this was going to change.  CAn we not go back to the old way of PowerApps / SharePoint respecting what you have the column set to - Required or Optional.

 

Thanks

 

Nigel

View solution in original post

Microuts
Frequent Visitor

As long as you make the Title field optional BEFORE you create your PowerApp, you won't have any errors.

 

If you create the PowerApp first and then go into the list settings and make the title field optional, you'll continue to receive errors. 

 

 

Hi @Microuts 

 

Thats Interesting !

 

So once the PowerApps has been created you can NEVER change the Title field to optional in the SharePoint List ?

 

Thanks

 

Nigel

Hi @NigelP @Microuts ,

 

This is definitely not the case, I am happy to explain what the issue you are both facing is.

 

You can definitely change the Title field to 'not required' after you have created the PowerApp - I have done this multiple times.

 

What I will say to this, is that once you have created the App, if you change ANY field to 'required'/'not required' in the SharePoint list, this setting does NOT update within the App's forms when you refresh the DataSource if you ONLY update the data source. These DataCards then need to be manually set to 'Not Required'/'Required' as they are static cards, or the datacards need to be replaced entirely.

 

I'll demonstrate:

 

I make a List in SharePoint, the Title field is required and I've set the Personfield to Required:

image.png

 

Add in some test data via the List itself:

 

image.png

 

Create the App using Create from DataSource (this applies all the default values, and no human error):

 

image.png

 

Now we set Title to 'Not Required' in SharePoint, and then Refresh the Data Source in PowerApps:

image.png

image.png

 

Now we can see that even after refreshing, the Required field has not changed on the DataCard:

image.png

 

Now we have two options.

  1. Unlock the Card and set Required to false
    image.png

    OR

  2. Change the DataSource to anything else (making the form invalid), then choosing that data source again to recreate all of the cards:
    image.png

    image.png
    image.png

 

Using Method 1 - we set it to Required: false and try submit a new item, which we can see it has successfully done:

image.png

 

Using method 2 of recreating the datacards, we can see that it's now picked up the correct Required status for Title:

image.png

 

So there's proof that it works!

 

If you're having any issues please let me know what you are having issues with so that I can help you find a solution 🙂

 

Cheers,

@iAm_ManCat 

@iAm_ManCat


Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


@Pstork1 , @iAm_ManCat 

I know this is an old post, but I am a fairly new student of the Power Platform.

I am trying to build a flow that inputs Microsoft Form (quiz) information into a SharePoint list.  Under the "Create Item" action of my Flow, it of course wants Title.  I would like the Title to be the name of the Quiz.  It is not available in the Dynamic Fields, so is there a function I can use to pull this information?

 

Thanks.

Pstork1
Dual Super User III
Dual Super User III

The Trigger for the flow is specific to a particular Microsoft Form.  So although the dynamic content doesn't contain the name of the quiz, you'll know what the name of the quiz is based on the form you use for the trigger. I would just create a variable and hard code the name of the quiz in the flow.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

@Pstork1 

Can you provide me step by step how to do that?

 

MShelnutt_0-1617201963083.png

 

Pstork1
Dual Super User III
Dual Super User III

Here's a screenshot of a form being filled out in the browser.  You can see the FormID I've highlighted in the URL.

image.png

So here is a Flow that Triggers off that Form.  You can see the FormID in the trigger. I've added a variable right after that where I set the name of the Form that matches the ID.  Then when you create the item use that variable for the Title.

image.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,938)