I'm having an issue with an issue with the some of my comboboxes sometimes not keeping its value after navigating to another screen.
Each of my screens are tied to another datasource (different Sharepoint lists), when a user clicks on the button to move to the next screen, the current screen submits the form and on success it moves to the next screen. The default mode for each screen is edit. the comboboxes have defaultsselecteditem set like the following:
LookUp(dd_Activity, Title = ThisItem.Activity_x0020_Code)
When I navigate back to the screen which was submitted at times one or two comboboxes may be missing their values. This doesn't happen all the time. Anyone else experience something similar to this? Any suggestions?
Hi @ContentGroup ,
Are these combo boxes from multiple choices enabled Choice columns in SharePoint list or what? What is the Items property of the combo box control?
About LookUp(dd_Activity, Title = ThisItem.Activity_x0020_Code), is " " the SharePoint list name of current Form? What is "Activity Code" column's data type? Or is this combo box a Lookup column and its source information is from 's Title field?
@v-monli-msft the source for the combobox options are from another Sharepoint list (the name of the list for this combobox is dd_Activity, which the title field contains the drop-down options). When the powerapp is submitted all of the data is stored in a text field in another Sharepoint list (under a field entitled Activity Code).
I have several comboboxes on this form which work the same way connecting to different sharepoint lists for the options.
Thanks in advance for your help.
I've come to the conclusion that Powerapps must have some sort of issue running a LookUp on several comboboxes for the defaultselecteditems on a form.
The form source stores the combobox selected values as text field and the lookup uses the text to lookup a table values different Sharepoint lists. I know the source text is okay, because it outputs correctly to a label. I have a feeling that there is some sort of timeout when loading an edit form and populating 7 comboboxes' with defaultselecteditems. The issue happens only intermittently, and if I replicate it in Powerapps studio, I can go to the combobox which does not receive a value and put a space after the the LookUp statement and the value then populates.
If anyone knows a way to debug this further it would be appreciated.
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Fill out a quick form to claim your user group badge now!
Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities
Features releasing from October 2019 through March 2020
Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications