How can I use Azure App Configuration for QueueTrigger bindings

# Issue Transfer

This issue has been transferred from the Azure SDK for .NET repository, [#38965](https://github.com/Azure/azure-sdk-for-net/issues/38965).

### Please be aware that @gpuchtel is the author of the original issue and include them for any questions or replies.

## Details

### Library name and version

Microsoft.Azure.Functions.Worker 1.19.0

### Query/Question

I've been searching for a way to use Azure 'App Configuration' to store the connection string of an Azure Storage Queue. After hours searching on the Web I'm even more confused--there seems to be conflicting opinions on how to do this. Maybe even using Managed Identity, but that makes debugging locally a nightmare.

What I want is something like this:

[Function("foo")
public void foo([QueueTrigger("bar", Connection = "FooConnection")] QueueMessage message)

Where "FooConnection" is the name of a 'key' in an Azure App Configuration from which the connection string is specified. adly, it seems that Azure only looks in the 'Configuration' of the function (or local settings if running locally).

So, is this even possible?

Note: I do 'AddAzureAppConfiguration(..) in my HostBuilder.

Thanks in advance,

I've tried to surround the name with '%' like "%FooConnection%", but I get an error saying the expression did not evaluate to a value.

I've seen posts that speak so an expression pattern, but there is not much guidance on it.

see: https://stackoverflow.com/q/77180419/8307483

### Environment

_No response_

Start by reproducing the QueueTrigger configuration with Microsoft.Azure.Functions.Worker 1.19.0 and a HostBuilder using AddAzureAppConfiguration. Trace how the host resolves the FooConnection setting for QueueTrigger bindings, then confirm whether Azure App Configuration values are supported and document the working configuration or limitation.

Written by the indexing model from the issue text.