web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps sharepoint forigen key...

Power Apps - Building Power Apps

Unanswered

sharepoint forigen key column

Like (0) Share

Report

Report

Posted on 1 Feb 2023 09:08:13 by Ayappan

90

Hi team ,

I have 2 Tables .

This is 2nd Table .. Request is from Table 1 Title column .

Now in Table 1 i want the data of title column from Table 2.

Example : In Table 1 i need a column with data SAMP-4,SAMP-5,SAMP-6

Thanks

Categories:

General Questions

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

v-jefferni on 01 Feb 2023 at 09:33:19

Like (0)

Report
Re: sharepoint forigen key column

Hi @Ayappan ,

What type is that column in Table1? If it is a LookUp column and allows multiple selections, in the Form there should be a Combo box. You can edit the Combo box DefaultSelectedItems property as follows:

Filter(Choices(Table1.LookUpColumn), Value in Distinct(Filter(Table2, 'Request ID' = Gallery.Selected.Title),Title))

and set DisplayMode property to DisplayMode.View

Best regards,

Was this reply helpful? Yes No
Ayappan 90 on 01 Feb 2023 at 09:18:58

Like (0)

Report

Re: sharepoint forigen key column

hi @v-jefferni
I am using this table in power apps . The data which is populated in Table 1 i need to pull in power apps form

Was this reply helpful? Yes No
v-jefferni on 01 Feb 2023 at 09:13:19

Like (0)

Report

Re: sharepoint forigen key column

Hi @Ayappan ,

This seems not a PowerApps question, would you like to get it done using an App?

Best regards,

Was this reply helpful? Yes No