Combo lookup fields not populating SharePoint

[joshieboy]

Hello,

I have a form with multiple combo boxes on it that are actually referencing SharePoint Lists.  When I populate the fields in the form and submit, the text fields update the record in SharePoint but the combo box fields in SharePoint are blank.  Further to this, when I edit the saved record from PowerApps, all combo box fields are blank on the form so its as if its not even saving it in the PowerApps form.  I have other combo boxes that are just Yes/No and other text boxes on the form - all of which update the SharePoint list and all of which when I reopen the saved form the values are there.  I am not sure how to troubleshoot this, but am thinking it has to do with combo boxes connected to SharePoint lists as a data source as the other yes/no boxes are not data sources.  However, I have a Division/Department field on the form which are also connected to data sources and they update the SharePoint list and their values remain when I reopen the form.  Hope my explanation above can help narrow down the issue.  Any feedback appreciated.

[WarrenBelz]

Hi @joshieboy ,

Please supply

• The Items of the Combo Box and its name
• The Update of the Data Card it is in
• The name and type of field it is writing back to

[joshieboy]

Hi @WarrenBelz 

There are multiple combo boxes:

1. Name:  "Impact Level" contains values 1-5
2. Name:  "Likelihood"  contains values 1-5  (When a user selects the Impact Level and the Likelihood, the system calculates Outcome and Investigation Level which are both text fields and which both update in SharePoint.  However, when the form is saved and reopened, all of those fields are blank on the form (Impact Level, Likelihood, Outcome, Investigation Level) as if they were never updated, yet the results are shown in the SharePoint list as a record.
3. Name:  "Incident type" contains values - Accident, Environmental, First Aid, Health, Medical Treatment, Security Incident, Safety Critical Equipment etc. 
4. Name:  "Incident type Sub Category" contains values - Equipment Failure, Indoor Air Quality, Chemical Spill, Vehicular, Tier 1, Tier 2, Tier 3, Tier 4, Loss of Asset, Damage to Property etc.  Its quite a lot but also note:  Incident type and Incident Type - Sub Category are cascading drop down menus that reference a SharePoint list

The Datacards include:

1. Impact Level:  Impact Level_DataCard1 and the actual combo is ImpactLeveldropdown updating a choice field in SharePoint named Impact Level
2. Likelihood:  Likelihood_Datacard1 and the actual combo box is Likelihooddropdown updating a choice field in SharePoint named Likelihood
3. Outcome:  Outcome_Datacard1 and the actual field is Outcometext updating a single line text field in SharePoint named Outcome
4. Investigation Level:  Investigation Level_Datacard1 and the actual field is Investigation_Level updating a single line text field in SharePoint named Investigation Level
   Note:  Only Outcome and Investigation Level are updated in their SharePoint list fields but when you reopen the edit form, all of the 4 fields above are blank
5. Incident type:  Incident type_Datacard3 and name of the combo box is Incident_Type updating a choice field in SharePoint called Incident type
6. Incident type - Sub Category:  Incident type - Sub Category_Datacard1 and name of the combo box is IncidentType_SubCategory updating a choice field in SharePoint called Incident type Sub Category

[WarrenBelz]

@joshieboy ,

The two most important items are what I asked and you have given me neither.

• The Items (the actual code in Items of the Combo Box).
• The Update of the Data Card (the actual code in Update) .

There will be different solutions for the different field types you are writing back to. Before you respond, can you please have a read of this blog of mine on Controls and their references.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[joshieboy]

Hi @WarrenBelz  -I'm sorry I misinterpreted what you were asking for.  Thanks for the article.  Its very clear and understandable.  I think the disconnect for me is that other combo boxes are writing back to SharePoint and also saving the results in the fields when I reopen the form, and they are also connected to SharePoint lists.

The code is as follows:

• Impact Level code in Items:  Distinct('Risk Matrix','Impact Level')
• Impact Level code in Update:  ImpactLeveldropdown.Selected
• Likelihood code in Items:  Distinct('Risk Matrix',Likelihood)
• Likelihood code in Update: Likelihooddropdown.Selected 
• Investigation Status code in Items:  Choices([@'Initial Incident Notification'].Investigation_x0020_Status)
• Investigation Status code in Update:  DataCardValue10.Selected
• Incident type code in Items:  Distinct('Incident type','Incident type')
• Incident type code in Update:  Incident_Type.Selected
• Incident type sub category code in Items:  Filter('Incident type','Incident type'=Incident_Type.Selected.Result).'Sub Category'
• Incident type sub category code in Update:  IncidentType_SubCategory.Selected

[WarrenBelz]

Ok @joshieboy ,

Assuming all the fields you are writing back to are Choice fields, try these in the Update of the Data Cards.

{Value:ImpactLevelDropdown.Selected.Result}

{Value:LikelihoodDropdown.Selected.Result}

{Value:DataCardValue10.Selected.Value}

{Value:IncidentType.Selected.Result}

{Value:IncidentType_SubCategory.Selected.'Sub category'}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[joshieboy]

@WarrenBelz  - this works really well thank you.  

I was also able to follow what you did and apply to a couple other fields, whilst also reading over your blog post which is clearer now.  Strangely enough there are three text fields based on the impact x likelihood value and those are lookup fields from a SharePoint list.  The list is being updated on submit, but those fields remain blank when reopening the form.  In this instance these are text fields so I initially had Name.text for the update property.  This is like a never ending story.

One such example is an Outcometext text field whose default value is LookUp('Risk Matrix','Impact Level'=ImpactLeveldropdown.Selected.Result && Likelihood = Likelihooddropdown.Selected.Result).Outcome and the Update property Datacard name:  Outcome_DataCard1 is Outcometext.Text - this works and submits the values to the SharePoint list but they do not remain in the form when you reopen the form.

I tried using a similar approach above {Value:  OutcomeText.Text} for the update property instead, but that is giving the property control expects text values error.

[WarrenBelz]

Thanks @joshieboy 

Did you say Lookup in SharePoint or Power Apps? If the latter, you are writing back to a single value and just need

YourDDName.Selected.Outcome

This is all covered in the blog - once you get your mind around the "two sides" - the syntax has to match the expectation from the destination as well as output the result of the source (the control).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[joshieboy]

@WarrenBelz 

Still trying to wrap my mind around this, but this is my very first PowerApp and I have learnt quite a lot in the last few weeks and am very grateful for all your guidance thus far.  My lookup is in SharePoint and I also only recently noticed another strange behavior.  As per attached "RiskRankSample.jpg" - the Impact Level, Likelihood, Outcome, Grade, Investigation Level and Impact x Likelihood are all pulling from a custom SharePoint list.  Once the Impact and Likelihood are populated, the other fields automatically populate.  The issue last week was that the data is not being saved in the form, but with the formulas you showed me above - this part works well and upon reopening a saved form the Impact and Likelihood are there.  What is strange is that when the form is in edit mode and Impact and Likelihood values entered, the other four fields are automatically populated, but when saved and reopened, only the Impact and Likelihood are saved.  What I don't understand is, as per the attached, Impact is 2 and Likelihood is 4 which should give the outcome as 8 based on the thumbnail of the risk matrix also in the attached, and also the Grade field should be yellow ad Investigation level and Impact x Likelihood populated based on the SharePoint list.  All of this is very accurate upon completion, even storing the values in the SharePoint List, but it seems as if when reopened the system is not even seeing the 2x4 as the Grade is still on green and green is for values 6 and lower.  I am not even sure how to go about troubleshooting this part

[WarrenBelz]

Hi @joshieboy ,

I was afraid you were going to say that (LookUp in SharePoint).

Please have a read of my blog on initial SharePoint setup and my comment on Lookup columns. Please make these fields plain text and do the Lookup in Power Apps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.