Unanswered

Copying from lookup fields to other lookup fields

(0) Share

Report

Posted on by HelloThereAll

I am supposed to auto-populate certain lookup fields in one form for one SharePoint list with results from lookup fields from the previously submitted form for a different SharePoint list. I am not sure how to do that, since simply copying over the value is not considered a valid default value. Also, I am not sure how to do it for single-entry fields, and how I would do it for multiple-entry fields. I'm rather new to PowerApps, so please make sure to explain accordingly.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HelloThereAll ,

For setting the lookup field the logic is a little different.
Patch( Tbl_SupplierDetails, Defaults(Tbl_SupplierDetails), { Title: LblContractNumber.Text, ContractNumberID: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: LookUp( Tbl_MC, ContractNumber = LblContractNumber.Text, ID ), Value: LblContractNumber.Text } } )

Note: Please change all the variables and data sources as per your need.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
HelloThereAll 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm pretty new to PowerApps, and I'm wondering if you had something simpler.
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HelloThereAll ,

Sorry for the late reply, I was completely arrested with my work today!
Coming to your request, unfortunately, that's the simplest one. Please let me know what is your requirement fully so that I can provide you the complete code block.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.