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.
Can u help me by providing screenshots of the issue if u can ??
Thanks for your input. However, it's the same error + delegation warning.
Try This :
LookUp(SIC4CodesInd, Value(SIC4) = ThisItem.'SIC 4').
Let me know if it works.
Thank You
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1