DropDown fields showing up as blank in Excel upon successfull submission of form

[safifaruqi]

Hey everyone, 

Reaching out for some guidance. 

I have a functioning ticket logging app. with the data being stored in Excel (onedrive, eventually moved out to sharepoint) the app was working fine previously however, after recently sharing the app with another user for testing. I noticed an issue.

The issue is that there are a few data cards within the app that contain dropdowns, the item lists for these dropdowns are populating correctly in the app, but upon submitting the completed form, these fields show up as blanks within the excel sheet where I am capturing data.  Please consider the image below : 

The fields highlighted in yellow in the edit ticket screen show the values selected by the user, the subsequent ticket entry was also entered into the excel sheet but the yellow highlighted fields are showing up as blank in excel. most recently the team input is also blanking out but I do not see any errors in the app itself. I changed the data type of some columns to text but have since changed it back to 'general' but the issue has not been resolved. 

Any guidance here would be supremely appreciated. I am just confuse as to why it would start doing this randomly. 

Secondly, from a best practice perspective. I would like migrate the excel sheet to a sharepoint list does that mean I have to reference all data cards and objects manually to the sharepoint list? even if the list is identical to my excel sheet in structure? 

Thank you for your help

[Drrickryp]

@safifaruqi 

First, check the Update property of the cards that hold controls that are not being saved and make sure that the control in the card is the same one referenced in the Update property.  If you are planning on migrating your data to SharePoint, you should familiarize yourself with how SharePoint works.  @WarrenBelz 's blog is a must read and you will save yourself hours of aggravation by following his recommendations for designing your new lists.  https://www.practicalpowerapps.com/ 

[safifaruqi]

@Drrickryp 

thanks for taking the time out. 

so this is the first screen in my app

It start with a drop down, where the user selects the team he/she belongs to.  once this is selected the person proceed to the next screen by clicking 'initiate new ticket' 

The submit ticket screen is as follows, i have made the team field visible for demo purposes, but this is hidden otherwise. you can see the update property on this data card. 

it seems fine to me, what do you think? 

[safifaruqi]

bump

[Drrickryp]

@safifaruqi 

As a test, make the Update property on the form reflect the selection in the original control in your first screen. I have found Excel to be difficult to work with and now only use it for static tables.  Rather than fool around with it, I suggest you migrate your data to a SharePoint list and work from there since you are going to do it anyway. https://powerusers.microsoft.com/t5/Building-Power-Apps/Migrate-Excel-data-source-file-from-one-driv... .  Your data must be a table and not contain special characters or spaces in the column names. I suggest just using text, number and date type columns in SharePoint. 
https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/The-Ten-Commandments-of-SharePoint-in-... 

[safifaruqi]

@Drrickryp 

Thanks for the tip, I am in the process of migrating, but the udpate property is for the said fields are set to

fore instance :

Dropdown2_InputTeam.Selected.Result

its the same that I am using in other fields, but few fields disappear on form submission, this was working just fine previously. 

[safifaruqi]

@Drrickryp 

 make the Update property on the form reflect the selection in the original control in your first screen,

what do you mean by original control ? I am sorry I am new to powerapps might not catch on the terms immediately. 

the update property is the same across the board for the said datacards, having said that I cant seem to find the update property for the whole form? 

[Drrickryp]

@safifaruqi 

Sorry, I meant to say the Item property of the form should match the selected Item in the gallery.  If you have an ID column in your table, it should be something like Lookup(Table1, ID = Gallery1.Selected.ID) .  If you don't have an ID column in your table you should create one.  Often, Gallery1.Selected is not sufficient as the Item property of a form. Excel tables do not have an automatic ID column like SharePoint lists, SQL tables and Dataverse tables.

[safifaruqi]

@Drrickryp  

thanks I have an ID column in my sheet and its set to auto increment.

as the default property  =
If(EditForm1.Mode = FormMode.New,Last(QMS_Data_Table).'ISSUE ID'+ 1,Parent.Default)

I used the patch code that you provided and applied to the submit button, to the 'On Select' Property of the function. Let me know if it makes sense. 

Did not work but I maybe doing something wrong. 

[safifaruqi]

bump