Hi All,
I encountered pretty odd issue. In the canvas app I have a gallery. Within the gallery I have a modern combobox (cmb_SIC4Number) with DefaultSelectedItems property = LookUp(SIC4CodesInd, SIC4 = ThisItem.'SIC 4').
The source for the gallery is SharePoint List SearchCompany, where I have 'SIC 4' column (integer). To the canvas app there is also additional source loaded which is SharePoint List SIC4CodesInd where the "Primary Key" between these two are SIC4 codes.
Until yesterday it was working perfectly for few months. However, today morning it stopped working and the default properties do not show in the combobox (cmb_SIC4Number) anymore. There is also a warning/notification (not sure if it was before) "ThisItem = This formula uses scope, which is not presently suported for evaluation.".
What is even more odd, when I open the app as a user (not in the studio), it works fine. When I open in studio and either want to edit or run a preview - cmb_SIC4Number is blank (i.e. it shows the default "Find items" text).
Does anyone know what could be the reason and how to fix it?
If I use text label item with a formula ThisItem.'SIC 4' - it shows the value as expected. Additionally, when I use classic combobox (not modern), and the DefaultSelectedItems property = {Value:ThisItem.'SIC 4'} - it works. However, I would prefer to keep the modern one if that's possible.