Save Lookup column in submit form powerapps

(0) Share

Report

Posted on by Ashok2

428

Hi All

I have lookup column which will be having an option "others" now on edit form on choice of other it show textbox and save value in sharepoint in lookup column
It save other values but not the value from textbox

Can anyone guide how to achieve it

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ashok2 ,

Could you please share more details about your scenario? What do you mean by "show textbox"? Do you mean when selecting "others" option a Text Input box will display and let user fill in then update the filled in value to the look up list?

If so, you will need to use another Patch function rather than the SubmitForm function:

//create a new item in the list that the LookUp column look up in. Patch(YourLookUpList, Defaults(YourLookUpList), {ColumnLookedUp: TextInput.Text}); If(Form.Mode = FormMode.New, //in new mode create a new item in this list. Patch(ThisList,Defaults(ThisList),{LookUpColumn: LookUp(YourLookUpList, ColumnLookedUp = TextInput.Text)}), //in other mode edit the selected item of this list. Patch(ThisList, Gallery.Selected ,{LookUpColumn: LookUp(YourLookUpList, ColumnLookedUp = TextInput.Text)}) )

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Ashok2 428 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni

I am trying but getting error Missing a column 'Id' with a type of 'Number' and as well how to save other values of lookup in SharePoint with others

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Ashok2 ,

Am so sorry that I had some mistakes in above formula, please try below:

//create a new item in the list that the LookUp column look up in. Patch(YourLookUpList, Defaults(YourLookUpList), {ColumnLookedUp: TextInput.Text, OtherColumn1: ..., OtherColumn2: ...}); If(Form.Mode = FormMode.New, //in new mode create a new item in this list. Patch(ThisList,Defaults(ThisList),{LookUpColumn: LookUp(Choices(ThisList.LookUpColumn), Value = TextInput.Text)}), //in other mode edit the selected item of this list. Patch(ThisList, Gallery.Selected ,{LookUpColumn: LookUp(Choices(ThisList.LookUpColumn), Value = TextInput.Text)}) ); //save other columns of this list SubmitForm(FormName)

Besides, you will need to modify the formula in the Update property of the LookUp column Data Card:

If(!IsBlank(DataCardValue.Selected.Value),DataCardValue.Selected) //DataCardValue is the name of the Combo box control inside this DataCard

For the second question, what do you mean by "save other values of lookup in SharePoint with others"? Do you want to update items of 2 different lists within 1 Form? You may see other columns have been added into the first Patch function of my updated formula.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
lama1 2 on at

Like
a
(0)

Report
Copy link

Link copied!

i have an textinput and submit bottom and a have two list users and income , the users list is have a title , and the income has a lookup column from title named username_fk , i want to create registration page that save the title and username_fk "lookup" in on submit bottom , any one please help me i am in trouble @Ashok2

Was this reply helpful? Yes No