I want to fetch the data from multiple Sharepoint Lists in a single New Form...For Example - a dropdown field must contain the options fetched from one list and another input field must contain the data fetched from another list....
Solved! Go to Solution.
Hi@black_28,
Based on the issue that you mentioned, do you want to pull data from SharePoint list to Dropdown and other TextInput?
Could you please share more about your scenario, here are some key questions, please provide more details relative to these questions as below.
First, you should make sure that you have connected several SharePoint lists within PowerApps. I assume that there is a primary key like “ID” among your SP lists. The following is my SP lists.
Based on a few of the requirements you mentioned, I have a test on my side, please take a try as below.
Distinct(TestA,EmployeeID)
ComboBox1.Selected.Result
If(Form1.Mode=FormMode.New,LookUp(TestB,EmployeeId=ComboBox1.Selected.Result,EmName))
Or you can directly set the Items property of every field.
Any screenshots about the issue will be appreciated.
Best Regards,
Qi
Hi @Anonymous
A form can only save data to a single list. However, the items property of the controls in the form can come from any list or even be hard coded ["item1","Item2",etc]. The important point is that the Update property of the card must be set to accept data from the control inside of that card and that the type of data being submitted must match the type required for that field. For example, you can put a dropdown control inside the card and hide the textbox control . Change the Update property of the card to Dropdown1.Selected.Value.
Hi@black_28,
Based on the issue that you mentioned, do you want to pull data from SharePoint list to Dropdown and other TextInput?
Could you please share more about your scenario, here are some key questions, please provide more details relative to these questions as below.
First, you should make sure that you have connected several SharePoint lists within PowerApps. I assume that there is a primary key like “ID” among your SP lists. The following is my SP lists.
Based on a few of the requirements you mentioned, I have a test on my side, please take a try as below.
Distinct(TestA,EmployeeID)
ComboBox1.Selected.Result
If(Form1.Mode=FormMode.New,LookUp(TestB,EmployeeId=ComboBox1.Selected.Result,EmName))
Or you can directly set the Items property of every field.
Any screenshots about the issue will be appreciated.
Best Regards,
Qi
Hi@black_28,
Have you solved your issue?
If it solves your request, Mark it as a Solution to enable other users to find it.
Best Regards,
Qi
User | Count |
---|---|
258 | |
110 | |
90 | |
52 | |
44 |