Collecting Data

[Anonymous]

Hello,

I am new to Power Apps, but have built an inspection form with several drop-Down boxes for data entry.  I have the data linked to a form on a Sharepoint site and added a button at the bottom of the form that will be selected to enter the data once the form is completed.  The button is not working and I am receiving the error message: "Name isn't valid. Text isn't recognized."  I have deleted the button and tried a new button without luck.  I am using the "Collect" syntax on the button.  Can anyone provide an  answer as to why I can't get the collect button to work?

Thank-you!

[Anonymous]

Here is the Code: 

Collect(ScooterInspectionResults,{ShiftLabel:ShiftBox.Text,AssocA:AssocB.Text,DateA:DateB.Text,ScootA:ScootB.Text,InspectionA:InspectionB.Text,StatusA:StatusC.Text,InspectionA:InspectionB.Text,NotesA:NotesB.Text})

Thanks again for your assistance!

[Anonymous]

This is my first App, so I'm trying to follow you. Thanks for hanging in there with me. 

[v-qiaqi-msft]

Hi @Anonymous,

You need to provide more details like column type and how you set the Items property of your drodpown control as I mentioned, how you write this fomrula is not that important now.

[Anonymous]

	Shift:	Date:	Scooter#:	Inspection #:	Inspection Point/Location:
On Change	FALSE	FALSE	FALSE	FALSE	FALSE
On Select	FALSE	FALSE	FALSE	FALSE	FALSE
Accessible Label	""	""	""	""	""
Allow Empty Function	FALSE		FALSE	FALSE	FALSE
Content Language	""	""	""	""	""
Default	"1"		"1"	"1"	"1"
Items			Table 8	Table 8	Table 8
Val			Scooter ID	Inspetion Point	Inspetion Point
Reset		FALSE	FALSE	FALSE	FALSE
Tooltip		""	""	""	""
Language
		If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language))
End Year		2050
Default Date		Today()
Date Time Zone		DateTimeZone.Local

[v-qiaqi-msft]

Hi @Anonymous,

First of all, please believe that I am not deliberately trying to find fault,😂 however, I think you have a Dropdown box corresponding to your Shift column, and you did not mention that how you set the Items property of the Dropdown.

So does the Status dropdown box.

Further more, tell us the column type of each column is the direct way as well...

[Anonymous]

No problems, I'm learning from you.  Based on recommendations yesterday, I now have the following:

	Assoc. ID#	Shift:	Scooter ID#:	Date:	Inspection #:	Status	Enter
On Check							Collect(Data,{AssocID:TextInput1.Text,Shift:Dropdown5.SelectedText.Value,Date:DatePicker.SelectedDate,ScooterID:Dropdown1.SelectedText.Value,Inspection:Dropdown3.SelectedText.Value,Status:Dropdown4.SelectedText.Value})
On Change	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
On Select	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
OnUncheck
Accessible Label	""	""	""	""	""	""
Allow Empty Selction		FALSE	FALSE		FALSE	FALSE
Content Language	""	""	""	""	""	""
Default	"AssocID"	"1"	"1"		"1"	"1"
Delay Output	FALSE
HintText	"(123456)"
Items		Table8	Table8		Table8	Table8
Val		Shift:	Shift:		Inspection Point	OK
Reset	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
Text
Tooltip	""	""	""	""	""	""
Language
Input Text Placeholder				If(IsBlank(Self.SelectedDate), Text(Date(2001,12,31), Self.Format, Self.Language))
End Year				2050
Default Date				Today()
Date Time Zone				DateTimeZone.Local
Format				DateTimeFormat.ShortDate
StartoftheWeek				StartOfWeek.Sunday
StartYear				1970

I sent you all of the settings, what am I missing?  

[VijayTailor]

Hi @Anonymous ,

As per my understanding , if you used above Code then Surely work Perfectly Fine,
but i have doubt , might you are using some condition for collect Data on Different Property like OnChange etc etc.
Please check each and every Property, if you used then verify the Code.

 

[Anonymous]

I have relayed every setting I can think of to you, by am still getting the following error/s.  It look like the "EnterData" button is the problem

:

Thanks very much for your help!

[Anonymous]

I am trying to save the information to a CSV document.  Do I have to set up the document and provide a location for it also somewhere?

[Anonymous]

Here is the Button Code, I am trying to save to a SharePoint list:

SubmitForm(Table2,Defaults(Table2),{SHIFT:Dropdown1.SelectedText,DATE:DatePicker1.SelectedDate,ASSOCIATE:TextInput1,SCOOTER:Dropdown2.SelectedText,POINT:Dropdown3.SelectedText,AREA:TextInput2.SelectedText,RESULTS:Dropdown4.SelectedText,COMMENTS:TextInput2.Text})

These are the errors I am now receiving:

Thank-you for your help on this!