Power Automate Functionality

 There is a requirement for updating SQL Database table with another data source values. We   have achieved the functionality using API in Power automate but some of values are not getting matched with SQL database as compared to that other data source table. Then we used some   conditional formatting in Power Automate and successfully able to match some values in our SQL table.

In Power automate, we have fetched the values from external data source using API calls via adding Client Id’s and Secret Code in API calls from that we got API Token then we shared that token in next API for calling all data and able to sort all details/Values.