I have a sharepoint database with 2 colume and it is a choice list
when i connect it to power app , it turn to dropdown list
and I use this code
If(DataCardValue10.Selected.Value = "Marketing",['sharepointdatabase'.Name],DataCardValue10.Selected.Value = "Finance",[ ‘sharepointdatabase '.Colour])
but it doesn't work - It doesn't connect data from sharepoint to this dropdown
Go to Solution.
What are your 2 choices' column name in your?
Could you please share more details of your data source?
Is Name and Color is the second one choice column's items?
I test with 2 choices' columns as next:
2019test(my sp list name)
DataCardValue18.Items=If(DataCardValue16.Selected.Value = "Marketing",Filter(Choices('2019test'.'Na&Color'),Value ="Name"),DataCardValue16.Selected.Value = "Finance",Filter(Choices('2019test'.'Na&Color'),Value ="Color"))
(the green color ones are the datacard name,sp list name, Choice column name on my side, you can change them on your side)
Hope this could be helpful.
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.