Got another whole new error just now after entering some data via the preview windowโฆ app will no longer load. Posting for visibility so that if anyone else has seen this they can chime in. Iโm going to try rolling back to the previous version and will update the postโฆ
Edit: Rolling back to the version that worked before the error appeared did not helpโฆ
Edit 2: I emailed support. After doing some Googling this seems like an internal error that Iโm unable to fix. Appears to be related to a function in C#
Solved! Go to Solution.
Per @mfakhreddine
Whatโs failing is this expression in the โMenu Tagsโ virtual column in โShopify_Tableโ:
=sort(unique(select(shopify_sub_menu[tags],count(intersect([_thisrow].[tags],[tags]))>0)))
The reason is that the Tags column in Shopify_Sub_Menu is an EnumList, so when you SELECT several of them you end up with a list of lists. Whatโs happening then is that SORT is failing because it canโt handle a list of lists. Iโm going to work on fixing it on our end.
In the meantime, maybe you can use a different expression. If your intention is to get all the tags (across all rows) from shopify_sub_menu that intersect with the tags in the current row of Shopify_Table, try this:
INTERSECT([tags], SPLIT(CONCATENATE(select(shopify_sub_menu[tags], true)), โ,โ))
After finding the broken expression and replacing the formula as suggested the app started loading again like normal. Problem solved.
Definitely an issue for Support. A developer will have to investigate, I imagine.
Still have this issue with no resolution
Iโve seen internal chatter about this (I believe), so my impression is itโs being worked.
Per @mfakhreddine
Whatโs failing is this expression in the โMenu Tagsโ virtual column in โShopify_Tableโ:
=sort(unique(select(shopify_sub_menu[tags],count(intersect([_thisrow].[tags],[tags]))>0)))
The reason is that the Tags column in Shopify_Sub_Menu is an EnumList, so when you SELECT several of them you end up with a list of lists. Whatโs happening then is that SORT is failing because it canโt handle a list of lists. Iโm going to work on fixing it on our end.
In the meantime, maybe you can use a different expression. If your intention is to get all the tags (across all rows) from shopify_sub_menu that intersect with the tags in the current row of Shopify_Table, try this:
INTERSECT([tags], SPLIT(CONCATENATE(select(shopify_sub_menu[tags], true)), โ,โ))
After finding the broken expression and replacing the formula as suggested the app started loading again like normal. Problem solved.
User | Count |
---|---|
18 | |
9 | |
8 | |
5 | |
5 |