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.
So the delegation warning is something you will always get if you have your combobox set to searchable. More in a little bit...
So if you are not seeing anything there in the combobox selected, then we need to validate that there indeed does exist two things:
1) Based on the fact that you say you have over 5000 records in the Contract list, is the item that *should* be displayed past record 2000 (assuming you have your record limit set to 2000)?
2) Is there an exact match of the Title in the Contract list and the Mon_Contract?
Now, back to delegation. What I would recommend...
1) Does your Contract list have some identification or an "owner" i.e. a company, client, etc.? For the purpose of this recommendation, let's say that you do, and I will call it CustomerID
2) Add a Customer selection to your form. Here the user can select the Customer that they are reporting time for. Then your ComboBox Items can filter the contracts by the CustomerID Filter(CompanyContracts, CustomerID=selectedCustomerID)
This way you will only see Contracts relevant to that Customer in the ComboBox. It will be less than the record limit. You will STILL get a delegation warning on the control for the search capability, but you can ignore it.
The goal in this recommendation is to determine a narrowing criteria to filter your CompanyContracts where the end result of records will be less than the record limit in PowerApps. In this case I used CustomerID, but you might have something else more relevant.
Sometimes even filtering out "inactive" contracts, or contracts that do not pertain to certain users are all narrowing criteria.
I hope this is clear.
I've narrowed it down to just show the completed contracts but they are still over 5000. There isn't an exact match on both contract list and weeklytimesheet list.
There is a customer column but I've noticed that the customer is being repeated in the list with different contract numbers.
Yeah, you're going to need to find a way to narrow the list in the combobox. Or you will need to collect all of the contracts into a collection (still will need some delegable column to do this).
So, the questions that would remain:
1) Does your combobox need to be searchable? It sounds like this is a list of contract numbers....if the person already knows a particular contract number, perhaps just having them enter them into a text box rather than providing a combobox that simply shows them a list of thousands of values would be more appropriate? If you were searching on other meaningful columns, then a combobox would be good, but you're just searching title to title.
2) If #1 is not viable, then what kind of columns do you have in the contract list that would allow you to narrow or delegate? (this is more of a "thought" question for you and not so much a direct question) If you can find that way to narrow, then you will be able to escape delegation.
I think I've narrowed it down a bit by editing the view page to just completed contracts in the SharePoint list. Is there a way to take what I've done on SharePoint to Power apps, to just sow contracts that have been completed. So on the the list I filtered it to that 0=to complete how would I replicate this in power apps
Yes, you can filter with whatever you are doing in the view. What are you using to filter there? That is what you would bring over to PowerApps and build a filter statement from that criteria.
@RandyHayes I'm still struggling with filtering the contract column and displaying the selected value on the view screen. Anytime I click on a contract number and save it, it doesn't save at all and display on the edit and view page.
So this is sort of two different issues.
If you are having problems displaying selected values when viewing an existing record, then you need to look at your Default property on your datacard (what is it?) and the DefaultSelectedItems on the ComboBox (what is it?)
If you're having problems Saving the selected item in the ComboBox, then you need to look at the Update property of your Datacard (what is it?).
Now I say "what is it" above in several places because I am curious to know if the properties have changed.
Before I have suggested the following property formulas for Mon_Contract_DataCard1:
Default : ThisItem.Mon_Contract
Update: Combobox1.Selected.Title (still assuming that the Title column in your CompanyContracts list is the contract number you want to store)
For Combobox 1 you should have:
Items: CompanyContracts (and this should now be changed with your narrowing filter)
DefaultSelectedItems: Lookup(CompanyContracts, Title=Parent.Default) (again assuming that Title has the value of your contract)
Let me know where you are on the differences with the above formulas.
Sorry on the delay...So what is Column1?
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks