How can I use Azure App Configuration for QueueTrigger bindings?

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

Start with Microsoft.Azure.Functions.Worker 1.19.0 and the QueueTrigger binding, then inspect how AddAzureAppConfiguration in HostBuilder is read versus Function configuration and local settings. Reproduce the %FooConnection% failure locally; done should establish whether this configuration source is supported and document the supported setup or limitation.

Written by the indexing model from the issue text.