Form registration with multiple Sharepoint List

[RyoIshi731]

Hi I would like to register form using 2 Sharepoint Lists belonging to different sharepoint sites.

There are 2 lists

  1. "Client List" in Master Site

  2. "Maintenance Report List" in Maintenance Site

      #these 2 lists belongs to different sharepoint site

When I Open Edit form in PowerApps screen,  the Edit form connects to "Maintenance Report List"

However only below this yellow part data should be extract from "Clinet List".  

Is it possible?

Regards

[WarrenBelz]

Hi @RyoIshi731 ,

A form can only have one data source, but you can certainly have the Items of a dropdown/combo box from another data source - is this what you are asking?

[RyoIshi731]

Yes

basically the form is for "Maintenance Report List" in Maintenance Site,  but only customer List, I would like to get data from  "Client List" in Master Site.

Thank you for understanding.

[WarrenBelz]

Hi @RyoIshi731 ,

As I mentioned, the Items of the drop-down can refer to a field in the other list, however the data must write back to the list the form is based on if you use SubmitForm().

[RyoIshi731]

@WarrenBelz Thank you.

Yes, your understanding is correct. 

> the Items of the drop-down can refer to a field in the other list
Could you tell me how I can do this?   In this example, the form connect to "ProjectList" in Maintenance Site, and I want to select CustomerName drop-down (Yellow part in the picture) from "CustomerList" in Master Site.  

I tried to edit this, however error happens. Error message is Invalid argument in 'Choices' function.  However CustomerList and Title column surely exists.  I don't know why error happens.
The Items value is:  Choices([@CustomerList].Title)   

What's wrong with this??

[WarrenBelz · Accepted solution]

Hi @RyoIshi731 ,

It is not a Choices column - you need

Sort(
   ProjectList,
   Title
).Title

and the Update of the DataCard

YourDDName.Selected.Title

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.

[RyoIshi731]

@WarrenBelz 

Thank  you so much for your kind support. I understood and solved.  

Thanks always, really appreciate.

[RyoIshi731]

@WarrenBelz   

Sorry for late response,  as you told, I can select the combobox from Customer List. (sorry for confusing, it is not project list but customer list). Thank you so much.

However there is 1 problem, problem is I cannot update sharepoint list with selected value.

# Other fileds like Telephone or Address can be saved properly.

For example,

1. original data is "test" in Customer List. 

2. modify in PowerApps "013432" in Customer List.

3. push save botton.

4. In Sharepoint List, the data in Customer List is still "test"

Property of data card "Customer Name"

Property of save button. 

# Please ignore   "Set(varBlob,JSON(PenInput1.Image,IncludeBinaryData));Set(varBlob2,JSON(PenInput2.Image,IncludeBinaryData));"

Customer List Sharepoint List setting

Please tell me if some setting is wrong or missed.

[WarrenBelz]

Hi @RyoIshi731 ,

Where are you submitting the form - your save code does not do that.

[RyoIshi731]

@WarrenBelz  

Thank you so much for your reply.

I defined like below. 

With this configuration, Other column such as "Requested by" can be updated properly, however Customer Name are not updated properly.  I want to update Customer Name and all other datacard in "Maintenance Report List in Sharepoint".  

Could you advice what is wrong with below configuration?

I define save button, 

 SubmitForm(Form1_1)

For Customer Name data card, I defined "CustomerValue.Selected", in update propertly.

Regards