cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New2PA
Helper I
Helper I

lookup field is invisible in my form

Hi experts,

 

In my SharePoint list, I have a lookup column named "Project ID" and it has an additional field named "Project Name" linked to it.

New2PA_0-1638946358215.png

The list is displayed as below.

New2PA_3-1638946437736.png

My requirement: In my new item form, I want to show corresponding "Project ID: Project Name". Now the situation is that "Project ID: Project Name" shows nothing in my form.

demogif1.gif

 It should automatically display for example "Project A" if I select  "P-001" in Project ID field. I didn't modify anything in Power Apps, the "DataCardValue3" is invisible in my form when publishing to SharePoint.

New2PA_4-1638946735106.png

 

I am newbie to Power Apps. Hope any guidance from experts here. Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
v-JessicaG-msft
Community Support
Community Support

Hi @New2PA ,

 

You could set the "DefaultSelectedItems" and "Items" properties of "DataCardValue3" to display the values corresponding to the additional field. I have test for your reference, please try the following workaround:

 

"DefaultSelectedItems" property:

 

LookUp(test1,DataCardValue2.Selected.Value='Project ID')

 

"Items" property:

 

Filter(test1,DataCardValue2.Selected.Value='Project ID')

 

vJessicaGmsft_0-1639130608219.jpeg

vJessicaGmsft_1-1639130618698.jpeg

 

vJessicaGmsft_2-1639130627142.png

vJessicaGmsft_3-1639130633875.png

 

Best Regards,

Jessica Gu

 

View solution in original post

1 REPLY 1
v-JessicaG-msft
Community Support
Community Support

Hi @New2PA ,

 

You could set the "DefaultSelectedItems" and "Items" properties of "DataCardValue3" to display the values corresponding to the additional field. I have test for your reference, please try the following workaround:

 

"DefaultSelectedItems" property:

 

LookUp(test1,DataCardValue2.Selected.Value='Project ID')

 

"Items" property:

 

Filter(test1,DataCardValue2.Selected.Value='Project ID')

 

vJessicaGmsft_0-1639130608219.jpeg

vJessicaGmsft_1-1639130618698.jpeg

 

vJessicaGmsft_2-1639130627142.png

vJessicaGmsft_3-1639130633875.png

 

Best Regards,

Jessica Gu

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,029)