Hey guys,
I am trying to achieve that when a week is not yet in my collection, an entry from a gallery should be added to the collection. However, if the week is already in the collection, the entry should be updated. I noticed that it will always add to the collection. After some testing, I realized that
IsBlank(LookUp(colUpload, week = WeekCom.Selected.Value))
is always false, no matter if there is an item in the collection with this week or not.
Do you have any recommendations?
Thanks a lot!

Report
All responses (
Answers (