Answered

How to save data into lookup column dataverse through powerapps

(0) Share

Report

Posted on by MAM627646

Hi All,

I built two tables in dataverse. One is Surplus table that has different column such as department, date, location and ID(which is autonumber -data type). its linked to the second surplus data which has IDSurplus(lookup column), description of items , quantity and others.

I built an app and want to get to save the information into the two tables . How can i pass the ID (autogenerated number ) from surplus table into surplus data IDsurplus column which is a lookup..

Thank you in advance

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Mahendar Pal 191 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You should be able to set lookup field in your patch like below

{lookupfieldname:LookUp(yoursurplustablename,ID=valueofid)}

You can try to look here: https://devoworx.net/powerapps-lookup-function-examples-complete-tutorial/

Was this reply helpful? Yes No
MAM627646 59 on at

Like (0)

Report
Copy link

Link copied!

@Mahender thank you for your prompt response. My code is as follow
Patch(
'Surplus tables',Defaults('Surplus tables'),
{Department:TxtDepart.Text,
Division:Txtdivision.Text,
Community:TxtCommunity.Text,
Date:Dateapps.SelectedDate,
Location:TxtLocation.Text,
'Orginator ':TxtOrginator.Text,
'Reason for Declaration ':TextReasonforDeclaration.Text
}
);

ForAll(surpluscollection,Patch('Surplus Data',Defaults('Surplus Data'),
{ 'Item No.':TxtItemNo1,
Quantity:TxtQuantity1,
'Description of Items':Txtdescription1,
'Serial Number':TxtSerial1,
'ID Surplus':

}
)
)
So the ID in Surplus table is auto-increment by dataverse. I am trying to patch the information to first table to generate the auto generated number but lacking how to insert /connect it to the IDSurplus in the second table which is a lookup.
Thanks much

Was this reply helpful? Yes No
Verified answer

Mitanshu 1,656 Moderator on at

Like (0)

Report
Copy link

Link copied!
I am going to contribute below the concept that should solve your problem and all such scenarios. You will have to adapt to your specific situation.

LookUp column type in Dataverse expects a Record value and not a Text or AutoNumber value.

When you Patch the ParentTable ('Surplus tables'), it will return you the Record information that you can store as a variable to be used later for the ChildTable ('Surplus Data')

Set( latestRecord, Patch( 'ParentTable', Defaults('ParentTable'), { Department: txtDepartment.Text, ... ,... } ) )

Now, when you are doing Patch for your ChildTable ('Surplus Data'), follow the concept below:

ForAll( surpluscollection, Patch( 'ChildTable', Defaults('ChildTable'), { 'Item No.':TxtItemNo1, 'ID Surplus': latestRecord, ... , ... } ) )

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 this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No