cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mike29f
Regular Visitor

LookUp one record with multiple number values

Hey Guys,

 

I have a question about LookUp for one record which have more than one ID.

There's two tables.

1.Main table with many information about user. (Now I have limitation for ~8000 chars)

2.Secondary table with ID's and corresponding skills.

Right now I have table with some random values and ID(column3 is only for testing purposes):

Mike29f_0-1616505782554.png

Now, I want to store only IDs in Main table and able to translate(LookUp) it inside powerapps.

Mike29f_1-1616506164144.png

So when someone enters multiple skills in this one record(as text), it will save it as numbers on my Main table. So I think I need some kind of function to read that text and a LookUp.

 

Important think is that I don't want to edit Secondary table from powerapps view, so user will need to enters only specified skills.

 

 

0 REPLIES 0

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

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

Top Solution Authors
Top Kudoed Authors
Users online (1,701)