0

I have two sharepoint lists. Company, and Client Company= ID,Company,address Client: ID, clientname,email,clientID ClientID is a lookup number, and I allowed multiple selection in the lookup. Now on button click, I want to insert into Client sharepoint list using canva apps: here is my patch code onSelect button property:

Patch(Client, Defaults(Client), 
{
    clientname:clientnametxt.Text,
    email:emailtxt.Text,

//the problem stars from the lookup column. the value  is manually inserted in textbox and the id is exists in company
///i tried the following one by one, no luck!

//LookUp(Company,ID= Value(clientidtxt.Text))

                   
//Value(LookUp(Company, ID = Value(clientidtext.text) , ID))

//clientid:Value(clientidtxt.Text)

});

I have a wasted a week to figure out but still goes on, help me please

I have tried the code in comments but so far no solutions

Sebey
  • 1
  • 2

0 Answers0