Setting up Dynamic Connection Strings based on table value

Thank You for looking, I am not sure exactly how to ask this question.

The situation there are two groups that utilze 2 versions of basically the same tool to enter data. The problem is that they are using the tool fields slightly differently...so initially I setup data connections to both resources and then merged them into a single data set with a source field. That has been more of a headache than you can imagine. I am not going to be able to change how they are using the tools, so end of story for me is I need two seperate dashboards...each pointing to the groups individual data.

I don't want to develop and maintain two dashboards, what I would like to do is develop a single dashboard and then based on a flag, control the data connection properties.

What I would typically have done in sql of vba is have a table of Group and Flag and then toggle the flag depending on which group I want active. I would then have a second table that has Group, Connection and String...which I would lookup teh string value based on the flagged group and connection being requested.

So that is my conundrum, I hope it makes sense. I figure there has to be some way to establish parameters and dynamically control data connections...I am just not sure where to even begin. Below is a quick table of the groups and the connection locations.

Thank  you in advance for any insight you are able to offer...and thank you for looking...