Guys. I Need to make a Card value that is the formula Lookup, based on a ComboBox value, returning another value, the data is a excel spreadsheet.
When I enter the Edit mode Page, the lookup does not calculate the formula, so I checked that the issue is on the combobox value, when you enter the EditMode Page with a ComboBox value, the value shows on the combobox, but it actually has no value....
let me try to explain in images.
1 - this is happened when I click on my gallery on the edit mode, so the form is editable, but the CB value is wierd, as I said,
the value appears, but is blank...
And this happens when I change the value of the CB to the same value....
Im using on the DefaultSelectedItems property of the CB this formula : {Value:ThisItem.Sintoma}, to bring the value registered.
Solved! Go to Solution.
I think I have your point, I had the same issue with a SharePoint lookup column in a combobox.
I had also an empty collection when trying to get the combobox.selected.
Can you set a variable like Set(sintoma,ThisItem.Sintoma)
Then you compare your variable structure and your collection structure and you'll see they are not the same.
Your combobox expects item with the collection strcstruc whereas your DataSource expects item with your variable structure.
Théo
Hi,
I supposed you have changed your combobox.Items property to put directly a DataSource instead of the default Choice(column).
By doing so you have a difference between your combobox control items structure and you DataSource column structure.
That resolve of being enble to use ThisItem.column as a DefaultSelectedItem property of the combobox .
You have to put in DefaultSelectedItem property an item that match the combobox structure, by doing a lookup() or first(filter()).
Let say
Combobox.Items : mylist
ThisItem.colLookUp.value : "test"
Combobox.defaultselecteditems : lookup(mylist,value=ThisItem.colLookUp.value)
If you have a doubt on the structure of your combobox items you can add a button that : ClearCollect(mycb,combobox.Selected)
Then you check the structure of the collection and make sure the item you out in DefaultSelectedItem has the same .
Théo
HI @tchin-nin..
Thanks for the reply.
I dont think I get your point or you didnt get mine, let me try to explain it again.
The problem is that when I click to edit my form for the first time, the CB.Value is showed, until that it is OK.
But when I did a text box to show me the CB.Value, it shows blank, and also the lookup formula didn't bring any result, before that I assume that the CB shows the value but it is actually with no value(?)...This is confusing me...
After I change the CB value to anything the formula calculates OK...
I have tried to do your example doing an collection showing the items of the CB, and I got the same result.
WHen I Click to edit the record I want, the CB shows a value, but the gallery is empty, when I change the CB value to anything, the collection collects the result...
I need to when click on the edit form, the lookup calculates based on the CB value, so I dont need to change it everytime to calculate...
I think I have your point, I had the same issue with a SharePoint lookup column in a combobox.
I had also an empty collection when trying to get the combobox.selected.
Can you set a variable like Set(sintoma,ThisItem.Sintoma)
Then you compare your variable structure and your collection structure and you'll see they are not the same.
Your combobox expects item with the collection strcstruc whereas your DataSource expects item with your variable structure.
Théo
Actually with the variable worked....Thanks so much @tchin-nin.
Stays as a feedback to microsoft team this as an issue with CB!