Flow designer Look up record fails even if there is an record in the table step execution

[Pooja58]

Hi Team,

We have a flow designer, when record is inserted into custom table is the trigger condition.

after that we are looking up another custom table, with the email ID and user name(reference field) from the trigger condition.

though the record exist, it is showing as no record found. And strange thing is this flow works fine in Dev instance but failing in test.

Tried adding wait for duration also before look up record. but still not working.

kindly help on this

Best Regards,

Pooja

[Ankur Bawiskar]

@Pooja58 

did you check who is the Run as in flow properties?

Is it failing even with Run as System User?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Viraj Hudlikar]

Hello @Pooja58 

As per your flow, the flow context says the data is searching for empty. Make sure the value are present in when its passed to lookup action. I see you added a log condition did you utilize it to verify if input is proper or not. Also, since the lookup is made to custom table and if flow is having property set as run as user who initiated does user have read access to custom table, if not try to switch to run as system user.

If none of this steps works try to compare user who is doing same action in dev and test having same roles or not. 

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.