Entry form with multiple lookup fields from sharepoint lists

(0) Share

Report

Posted on by Bassma96

Hello,

I have multiple SharePoint lists (Main contracts list - company List - Project Manager lists)

Main list: general information about each contract
Company list: associate each contract with a company name
Project Manager lists: associate each contract with the project manager

I want to use PowerApp to create a new form for the user to issue an invoice by submitting the form to a new SharePoint list called (Invoices). The invoice should contain the contract information from all the previous lists, in addition to new fields (for example, total amount of the invoice).

How could I implement it?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Bassma96 ,

Do you want to populate the form with the corresponding information from multiple lists based on the selected 'Contract Name' and create a new item in another list.
I have made a test for you reference.

1. Here is my SharePoint lists.
2. Here is my Form.
Distinct('Main list'.ContractName,ContractName)
LookUp(ProjectManagerLists,ContractName=DataCardValue13.Selected.Result).ManagerName
LookUp(CompanyLists,ContractName=DataCardValue13.Selected.Result).CompanyName
You can change the control type of the DataCard as follows:

Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Bassma96 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. This worked perfectly!

Was this reply helpful? Yes No