Connecting PowerApps Dropdown to SharePoint list

Question

Hi,

I have customised a SharePoint Online list form with PowerApps. I have changed the control of one of the SharePoint single line of text fields to a drop down control and I am trying to make the drop down options pull from a separate list on the same SharePoint site.

I have put the formula in the datacard 'Items' field: Choices([@'MySPList'].ChoiceField) but it is returning an error (Invalid Arguments).

Does anyone have any advice on how to troubleshoot this please?

Many thanks,

Alex.

Answer 1

Hi Cliff,

The answer to my question was painfully simple in the end - I had created two separate SharePoint forms within my App (SharePointForm1 & SharePointForm2). 

I forgot to add SharePointForm2 to the OnSave/OnEdit/OnNew etc. functions. Hence anything within SharePointForm2 wasn’t saving. 

Many thanks for your input. 

Alex.

Answer 2

Dear Alex,

I create two lists List E and List F. From your description, you first create a single-text line column Single to Choice and customize the form. Then you update the column type to Choice and you want to update the column type in Power Apps and want the choice values got from the Choice1 column in List F.

If yes, you need to first add the data source List F by click on Data, change the data source to List F and add the Choice 1 field in the form. it's better to remove the existing Single to Choice field and add it again after changing the data source back to List E. Then click on Single to Choice_DataCard1, leave blank in Default and type DataCardValue5.Selected (DataCardValue5 is the value for the Choice1 column in List F) in Update and hide the column. click on Choice1_DataCard2, type Choices('List F'.Choice1) in Items and save the form and publish it to SharePoint Online.

When you select values from Choice1, the values can be saved in the Single to Choice column in List E.

Best Regards,

Cliff

Answer 3

Dear Alex,

Welcome to share any updates when you have time if you need further help on this issue.

Best Regards,

Cliff