Hi @10101 ,
Thanks for trying out Power Automate! Please do share some more details on the scenarios you'd like to automate. I'll try to go through your bullets and suggest something, but please let me know what are your use cases so that we can focus on them:
1. SQL queries are saved in a datatable, so you can go through that table and get all the necessary values you need
2. LookUp in PowerApps finds the first record that satisfies a formula. There is no exact matching functionality in Power Automate, but you could leverage the action "Find and replace cells in Excel worksheet", the find part only, that will save your finding results.
Let me know if you have something more specific, so that we can focus on that.
Thanks,
George