Hello! Is there any way to fetch specific values for a temp table or are we inly able to loop through all the records in a temp table? I am trying to check for duplicates before inserting into a temp table and not seeing a method to do that outside of looping through every single record, please let me know if this is possible.
Hello Ellen!
No, there is no way to filter a temp table today outside of looping through every single record.
Behind the scenes, as implemented today, a filter on the Fetch Temp Table action would require us to loop the whole temp table anyways. We decided not to hide that behavior and to require a Fetch + Conditional so that it’s clear what’s happening.
2 Likes