I have a Flow that writes data to DB2 tables. After a write is successful, I want to send out a report that shows ONLY the new records written to the database.
I have a variable called varObjectIDs that is set earlier in the Flow. Its a string variable that looks like: "1,2,3" etc. and holds the ID's of the new tables.
I think the answer lies with the "Filter Query" or "Select Query" paramenters but I don't understand them enough to use them.
I tried putting OBJECTID eq varObjectIDs in the Filter Query, but Flow didn't accept that.
Any other ideas?
I am no DB2 expert but if your variable contains the ids in string format
OBJECTID eq varObjectIDs will not work
you might have to loop through each varObjectIDs and test the query and check if record exists
one option would be to hardcode the id and check first if it works
example : OBJECTID eq '1'
or OBJECTID eq 1
based on response you can set your query accordingly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
If you use Filter array, you need to put the current item into the left or right blank, and the other side you need to put the value you want find.
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Keep up to date with current events and community announcements in the Power Automate community.
Check out the latest Community Blog from the community!