Power Platform Community Forum Thread Details

I need to get values from my SQL server into Automate Desktop.

I am looking for the Power Automate Desktop Version of LookUp() from Powerapps.

-connected SQL Server

-got an ID

-Value of Column Where ID equals my ID

-Desktop Version of LookUp()

Thanks for the help.

Categories:

Power Automate Desktop

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