Remove default value from dropdown

[Anonymous]

I'm still struggling to remove a default value for the dropdown. The form is showing default value even in New Mode. Is there a way to fix it.

[Anonymous]

It's a dropdown. Below are images of the default and update property of the datacard on the right hand side and also an image of the Items and Default property of the dropdown on the right.

[RandyHayes]

@Anonymous 

So before offering a suggestion, let me be clear on your requirements.

If a user enters a NEW record, the dropdown should be empty.  If they EDIT a record, the existing value should be there.

Let me know that this is the correct assumption - or please clarify.

[Anonymous]

That's correct, so when they create a new record the dropdown should be empty and when they want to view or edit their entry sheet that existing value should still be visible to the user. 

[Anonymous]

Just got done with a review of the app, so I will be collecting the contracts numbers from a csv file and I'll also use a combo box instead of a dropdown as with the dropdown you can't type to find a certain number but with a combo box I think typing out the number would be possible as the csv file would have up to 2000 contract numbers. Would there be a way to filter it down to just show active contracts? Also how would I connect the csv file to the combo box on my app, would the steps be similar to how I added the contract list to my power apps.

[RandyHayes]

@Anonymous 

So, PowerApps will not be able to consume the CSV file directly.  You will need to either implement it in an Excel file (not recommended), or import it into a SharePoint list and use that as a datasource.

So I noticed in your Default formula for the Dropdown3 that you have a VarDropdown3 in it?  The formula should be similar as Matt had suggested with a couple of changes : If(Form1.Mode = FormMode.New, Blank(), Text(Parent.Default))

This assumes that the value stored in Mon_Contract matches the value that you have in the RHT_Projects.'Contract No.' and we have to convert to text for the match to occur. 

What I don't quite understand is how you have 'Contract No.' for your items, yet you have Title as the value?  That should be the 'Contract No.'

[Anonymous]

@RandyHayes So I've exported the excel table to SharePoint , I'm not connecting the Company contract list to the apps to collect contract no. I've added in the combo box. 

Below I've attached an image that displays what I've put in for the defaultselectedItem for the combo box, I'm not quite sure if lookup is the right one to use as I have several combo box to add to the form and I'm worried about the lookup threshold issue. Also the other image displays the default mode for the datacard, I didn't put anything in for the update property as I'm quite unsure.

[RandyHayes]

@Anonymous 

You might be confusing the Lookup Column limit in SharePoint over the LookUp function usage in your App.  There is no limit to LookUp functions in your app, so you can have them on all the columns if you needed.

I am not sure what you mean by "not connecting the Company contract list" - if that is the datasource that you need to lookup a value in, then you will need to have a connection to it.

So basically (and please correct me if wrong in your scenario), it appears that your Mon_Contract column is a Text Column and you have a CompanyContracts datasource with a Title column that is associated with Mon_Contract.

If the above is correct, then the following should be your formulas:

For Mon_Contract_DataCard1:

   Default - ThisItem.Mon_Contract

   Update - ComboBox.Selected.Title

For ComboBox1:

   Items - CompanyContracts

   DefaultSelectedItems - Lookup(CompanyContracts, Title=Parent.Default)

This should give you what you are looking for if the assumptions are correct.

[Anonymous]

So Mon_Contract is a single line of text column which i situated in the WeeklyTimeSheet List, whereas CompanyContract is another List separate from the WeeklyTimeSheet List, and the contract no that is being pulled out to populate the Mon_contract field is  coming from the contractno column which is in the Company contract list. 

I didn't use a lookup field for any of the daily contract columns as I was previously hit with the lookup threshold issue which led me to use this method

[RandyHayes]

@Anonymous 

Yeah, lookup columns are nice if your primary interface is going to be SharePoint, but in this case you are using SharePoint as your datasource.  And, when you get to that point, there is no need for the Lookup columns as you can just have a (usually numeric) column that references the other record (usually the ID) and PowerApps can do the LookUp itself.  So the method is perfectly fine and more welcome when in PowerApps over SharePoint.

So, the formulas I provided should do exactly what you want.  With the exception of the DataCard Update property which I had a typo, it should be - ComboBox1.Selected.Title

[Anonymous]

I've done what you said but there's no contract numbers being view viewed in the dropdown, then there is also a delegation warning in detailed on the right side. The Company Contract has over 5000 records, I think that's where the issue lies.