I have 2 SharePoint Online lists (Visitor List and Data List) that both have a visitor affiliation choice column with the same values. If someone selects a drop down value for the datacard associated with the Visitor List, how can I have PowerApps automatically match and update that value for the datacard associated with the Data List? This spans across two screens in the PowerApp.
Hi @ngreen ,
Could you tell me do the two lists have other relationship, or just have two choice column with the same choice value?
Are they multiple choice or single choice?
Do you want to automatically update the drop down's selection of Visitor Affiliation based on the selection of Affiliations?
If so, I've made a similar test for your reference: (I assume that they are single choice)
1)Set Affiliations drop down's Items:
2)unlock the Visitor Affiliation data card
3)set Visitor Affiliation combo box's DefaultSelectedItems:
LookUp(Data List,Visitor Affiliation.Value=Dropdown1.Selected.Value).Visitor Affiliation
Choice cholumn will display as combo box in PowerApps by default.
If you want to change it to a drop down, please set its Default property, not DefaultSelectedItems.
Hello @v-yutliu-msft ,
To answer your questions:
1. Just two lists that have two choice columns with the same values
2. Single choice
3. Yes I want to automatically update the selection based on the other drop down's selection and then have those choices get posted back to their respective SharePoint lists.
I should have specified in the initial post that I actually want to update Affiliations based on Visitor Affiliation (I know that sounds a bit weird). Based on that, I followed your instructions but reversed:
1. Choices(Data List.Visitor Affiliation) was already set as the Visitor Affiliation datacard Items
2. For this is the "DropDown1" supposed to be the datacard for the Visitor affiliation data card? I tried both but it didn't seem to work. I was using LookUp(Visitor List.Affiliations.Value=Dropdown1.Selected.Value).Affiliations since it was reversed for the other list. Also, will that lookup cause issues for larger lists over 2000 entries?
Hi @yashag2255 ,
The two sharepoint lists are separate lists that just have the same choice column with the same values. I just need this to setup for a Flow, and to keep the Flow from going into a loop. The users would need to select their visitor affiliation on the second page and then it would update the hidden affiliation value on the first page. This data for both would then be submitted to sharepoint with the rest of the data form.
I apologize for the delay on replying. I had a really busy few weeks. I worked on putting in your suggestion, but the Affiliation data card on Screen 1 is getting an error stating "Expected Record Value." Do you know anything about trying to resolve this error?
I had actually tried this and it gets a circular reference error. Maybe I am going about this the wrong way and I should use a Flow to update that list value instead of PowerApps to set it?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.