Hello there,
I've a requirement to create a screen flow that captures certain information manually but shall also provide associated data that is been used to pre-fill further fields.
Therefore I've established a data table in a screen that is suppose to display a collection from an external object.
However, the collection returns nothing, hence "failed to find record"
The external object has a lookup to account and I filter the get record variable:
location_c (which is the lookup to account) equals {!getAccountDetails.Id}
The object does hold relevant records for this account but my collection returns non.
Even when I sort them.
The ExternalId is technically useless for my get record variable filter as such, as it is not associated to account and co.
I probably simply miss something very simple but can't get my head around it or better, i am probably blind and stuck. Appreciate some hinds...
Cheers
So, found the little issue.
Cheers @Davis Johnson, sometimes having someone asking questions gets you enough to look deeper.
So basically the lookup I've used to get my records is an indirect lookup.
So I've assumed it is a lookup to account.Id, but it was not, it referenced another externalId on the account record. Don't ask why this has been done like this in the past.
anyway. I've got it working .
Thanks folks
