Guidance Needed for Consistent Single-Row Lookups in Campaigns
Hello! We have an issue with single-row lookups in tables and would need some guidance. Some context:
Say we have 10 different campaigns in separate workbooks. Each collects people from different places, and need enrichment before we proceed.
We want to enrich these people, but we want to do it consistently across campaigns, so we have a centralized enrichment workbook
So the 10 campaigns first ADD the people to the enrichment workbook, and then LOOKUP these same people from the enrichment table.
The issue: The lookup behaves inconsistently: quite often there’s no match, or the data is incomplete. When we come back later and manually replay the lookup, it works fine. I guess there must be some sort of race condition where the enrichment is not yet ready for us (the row for this person has not fully run yet) when we request it. What’s your take on this ? Is it the right approach to centralize a process across multiple flows ?
If yes, then is there a way to make the lookup wait for the row to be completed before looking it up ? Or a way to “just wait” a couple minutes, and then perform the lookup ?
If not, do you have other architecture recommendation to manage a central process across multiple workbooks ?