Multiple Data Sources with same names and switching between them

[Mattw112IG]

I have two SharePoint lists in separate sites with the same name.

I would like to have a dropdown on a form that depending on the selection would use one data source over the other.

Is that possible?

How would I reference that?

Thanks,

Terry

[WarrenBelz]

Hi @Mattw112IG ,

Yes, I actually have six with the same structure on different sub-sites. As long as the lists are identical in field name and field type, you can do it. You will see they will be referenced as SharePointListName and SharePointListName_1.

In the DataSource property of the Form

If(
   DropdownName.Selected.Value = WhateverIsFirstList,
   SharePointListName,
   SharePointListName_1
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Mattw112IG]

ok I have rewritten everything... 

For the most part everything is working fine.  But.. people pickers are not working.  Not sure how to fix.

Here's what I rewrote, incorporating two separate sites with 6 lists.

Switch(

Drp_OfficeSelector.SelectedText.Value,

"Atlanta",
Set(SelectedListAM, AMs_1);
Set(SelectedListTeam,OfficeTeams);
Set(SelectedListReqs,VirtualPZone_1);
Set(SelectedListCandidateNames,Candidates_1);
Set(SelectedListClients,Customers_1);
Set(SelectedListRecruiter,Recruiters_1);
Set(SelectedListInterviewTime,InterviewTimes_1);
Set(SelectedOffice, "Atlanta"),

"Seattle",
Set(SelectedListAM, AMs);
Set(SelectedListTeam,Teams);
Set(SelectedListReqs,VirtualPZone);
Set(SelectedListCandidateNames,Candidates);
Set(SelectedListClients,Customers);
Set(SelectedListRecruiter,Recruiters);
Set(SelectedListInterviewTime,InterviewTimes);
Set(SelectedOffice, "Seattle")

);

ClearCollect(AM,SelectedListAM);
ClearCollect(TeamNames,SelectedListTeam);
ClearCollect(Reqs,SelectedListReqs);
ClearCollect(CandidateNames,SelectedListCandidateNames);
ClearCollect(Clients,SelectedListClients);
ClearCollect(Recruiter,SelectedListRecruiter);
ClearCollect(InterviewTime,SelectedListInterviewTime)

All my dropdowns, and other fields are working.  The only ones that seem broken are my people pickers.

The datasource (like SelectedListAM) is attached to my edit form.

The Items I have tried a million things, but no matter what I put in it says Choices has some errors.

For example

Choices([@SelectedListAM].Name)

Yes, column names are right. Displayfield is ["DisplayName"].. etc.

I have to have the people picker working, but it seems like it cannot deal with using the variable for the datasource?

Thanks,

Terry

[WarrenBelz]

Ok @Mattw112IG ,

A fair bit beyond the scope of the original question - I was assuming from your description you simply wanted to point the form at a variable data source. I would suspect your people picker may work in these circumstances.

Also from your code, it appears one of the fields may not be the same in both (Teams and OfficeTeams) - is this the case?

I did however spot another thing - you reference Choices([@SelectedListAM].Name). Name is a very bad "name" for a field - it is a reserved word. Maybe this is your issue. Also what type of control is your people picker and if applicable, what is the Items property.

[Mattw112IG]

Good eye, yes one of the list accidently got a different name, but it is the exact same list. Copied from a template.

Name is bad.  Lol.  I would agree with you, but one the other people pickers they have better names like 'Candidate Name' and have the same issue.

For items I have tried a million iterations, but something like:

Choices([@SelectedListAM].Name)

I have discovered something interesting.

So if I change the datasource back to the direct SP List name.  I then have the ability to add fields.  If I add the fields a second time... delete the old fields... change the datasource back to my variable... then they still work!

It's weird but... until I find a better way I'm going to have to do it this way and hope there's no unforseen gotchas with that.

Thanks,

Terry

[WarrenBelz]

Hi @Mattw112IG ,

If you have a Person field behind this, be aware that they are a complex field type and have standard components of

• Claims
• Department
• DisplayName
• Email
• JobTitle
• Picture

They all do not need to be complete, but you must refer to them.