I want to be able to be able to get the environement settings of an app service in azure and display the values in an excel spreadsheet using powershell .

So basically if one setting is let say serviceName and the value is servicetest.com,another setting is connectionstring and value is “Data Source=myServer;Initial Catalog=myDB;Integrated Security=true;Column Encryption Setting=enabled;” then in excel I want it to display as follows

      serviceName         servicetest.com     
      connectionstring    Data Source=myServer;Initial Catalog=myDB;....

and so on and so forth for all the retrieved values from tyhe environment settings.

How can i do this using Powershell ?

Having some trouble putting into excel but can get the app settings using this ,

az webapp config appsettings list –name <app_name> –resource-group <resource_group_name> –query “[].{Name:name, Value:value}” –output table > appservice_env_variables.txt

Is that correct ?
How can i do this ?

Can i do a loop to get it for every app in the subscription ?