Form registration with multiple Sharepoint List

(0) Share

Report

Posted on by RyoIshi731

238

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

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (2)

WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

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?

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

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().

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report

@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??

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (2)

Report
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.

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report

@WarrenBelz

Thank you so much for your kind support. I understood and solved.
Thanks always, really appreciate.

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

Hi @RyoIshi731 ,

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

Was this reply helpful? Yes No
RyoIshi731 238 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

Hi @RyoIshi731 ,

What are the Items of this drop-down? I assume it is writing back to a Choice field?

Was this reply helpful? Yes No