NAV IT has a requirement from the client to update the value
of a SQL Database table from another data source through Microsoft Power
Automate. The
functionality has been developed by Microsoft Power Automate experts of NAV IT by
using API. However, some values in the database table are not matching with the
SQL table values. NAV IT Power Automate experts applied some
conditional formatting to SQL table using Power Automate to achieve the
functionality for the client. Microsoft Power Automate has fetched values from
external data sources through API calls. API token
was generated by adding Client ID’s and Secret Code’s to API calls in Microsoft
Power Automate. This token was shared with the next API in Microsoft Power
Automate for calling all data and for sorting all details and values of SQL
tables.
