We have a button that integrates with an external system using Named Credentials. We are using per-user authentication here and every user authenticates themselves with their external system username and password beforehand itself. Now the requirement is that certain salesforce users could have multiple credentials in the external system and they should be allowed to choose their credentials while clicking the button. Additionally, the users who have single credentials should bypass this step and be able to directly connect.
My plan was to have additional named credentials created and assign those to required users alone and query them in a screen flow. I am stuck with this as even though I was able to query the named credentials for admins, this is getting restricted for other profiles.
Is this a feasible approach or do we have a better design for these?