Answered

SharePoint list lookup column in Edit Screen

(0) Share

Report

Posted on by drgicher Microsoft Employee

Hi,

I have Edit screen of sharepoint list. It consists of Lookup Column, Single line of text column and Date column.

My requirement is on submitting the form, i want to concatenate all 3 column values and save it in another column of type single line of text.

So far I'm able to get Values of SIngle Line of text and Date columns in concatenate formula. But I'm not getting the Lookup column value. I have used formula "Concatenate(DataCard10.Update," - ",Text(DataCard14.Update)," - ", StoreNumber.Value)" but the output is not getting lookup column value. It gets other two column values.

Any help would be apperciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Drgicher,

According to your description, I created a similar SharePoint list, it contains Text column, Single line of Text, Lookup column, and Date column.

On the app, I added an Edit Form control, set the Default property of the Single line of Text as:

Concatenate(DataCardValue1.Text,"-",DataCardValue2.Selected.Value,"-",Text(DataCardValue3.SelectedDate))

DataCardValue1 is the text card for Title column.
DataCardValue2 is the text card for Lookup column.
DataCardValue3 is the text card for Date column.

Then I add a button, and set it OnSelect property as SubmitForm(Form2). When I click the button, all the items could be saved to data source.

Hope my steps could be a reference for you. Please try this on your side and let me know if it works.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
drgicher Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey,

it worked. 🙂

Thanks!

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Drgicher,

Glad to know it works for you.
If you have any other issues, please feel free post your issues at here. We are always ready to help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No