Hey Jaap,

is it really necessary to do this directly in the form? Why not implementing a workflow that get's the location for every brand and at the end writes it into a custom column?

Best regards,

Jan

Hi Jan, thanks for your response,

Because it's a large list to lookup against I am not sure if that is working with a workflow and performs in the cloud.

It should be than a separate workflow anyway. Do you have an example of such a type of workflow ?

Regards

Jaap

Hey Jaap,

the performance shouldn't be a problem! I just tried to build the worklfow, which is unfortunatley harder then in an On-Premise environment as the values that we see aren't the values we get when we try to work with them in the workflow. I will try to implement it on Friday and then catch up with you again ;-)

Best regards,

Jan

Thanks Jan, appreciated !

Hey Jaap,

I finally found the time to write a short blog post about it:  

Hope this will help you!

Best regards,

Jan

Hey ‌ does ‌ answer helped you? Is it a correct answer? Or have you found a better solution you could share with us?

Regards,

Tomasz

Hi Tomasz, good hunting happy to see your reminders.