Hi !
I have an enumlist linked to a collection of files on read-only.
I seems that the list isn’t updated when I add/delete files from Google Drive.
I tried to F5 my tab then sync, but it’s randomly updating the values 
Is there a workaround for this issue ?
I have no idea how is your setup.
The EnumList should have a fixed list of values, or files in this case. Why you expect this list to change? It’s a virtual column?
Thanks for your answer @SkrOYC .
Can you elaborate why the list should be fixed ?
Then I’m using MyCollectionTable[Path] as suggested Values, which should change the values of the enumlist. In fact, it does as you can see when I test the formula :
My goal is to be able to categorize files inserted in Google Drive in app. For that, I am using a using a table with the categories that I want for the files (Quality/Security/etc…) and the user will have to select, for each category the files related.
I’m doing this to avoid the user to have to insert a file one after the other.
While the changes does appear when I try the formula, it doesn’t when I select the enumlist in app.
I can say that I have an app in which the enum files are not fixed. In my app user-generated “tags” (data typed into another column) are parsed and sorted using list expressions in the “data validity” part of the enum column. Please see my “Converting text to unique lists for use as tags” post:
https://www.googlecloudcommunity.com/gc/Tips-Tricks/Converting-text-to-unique-lists-for-use-as-tags/m-p/340575
By the way, I think I experienced that failure to update issue you mentioned. My memory is fuzzy now but I seem to recall that I started out dividing the series of steps needed to make the list into several separate virtual columns and then combining that in the “data validity” spot. That, however, didn’t work well. My solution was to do everything in “data validity,” even if that meant writing a complicated expression.
Hi @Kirk_Masden and thanks for the tip !
Although I already used it, it’s nice to know that a tutorial exist here in the community 
Yep and I tried this one too, but couldn’t make it work, surely because it’s read-only data. I did other few tests today and the issue is obviously the server caching delay :
I timed the delay between file insertion in the drive and it’s always exactly 5 minutes.
I will try getting rid of the server caching and make an update if this worked out !
