cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Matching concatenated licenses in Sharepoint Column

Hello,

 

I have a text label that displays the result of concatenating multiple licenses from table "A", each license separated by a comma (Example: "ABC, AFR, DUFD-ER,"). I need to search for all of those licenses on list "B" column "Licenses" and return the ID for each license, concatenated. Any idea how I can accomplish this?

 

Thank you so much for your help!

5 REPLIES 5
Highlighted
Community Champion
Community Champion

Re: Matching concatenated licenses in Sharepoint Column

Try in another textbox2 :

LookUp(ListB,Licenses=Textbox1.Text,ID)

 

Change Textbox1 to actual name of the Textbox that display results of concatenate license

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Frequent Visitor

Re: Matching concatenated licenses in Sharepoint Column

@eka24Thanks for replying. It doesn't work with multiple values :(.

Highlighted
Community Champion
Community Champion

Re: Matching concatenated licenses in Sharepoint Column

The structure of the formula is ok. You may have to explain the multiple values further with example 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted
Frequent Visitor

Re: Matching concatenated licenses in Sharepoint Column

This is always false ---> Licenses=Textbox1.Text

 

What I mean is, using the formula you provided I get a blank as a result. The reason is because my licensesLabel is the result of multiple licenses in a column (list "A") concatenated (Example: "ABC, AFR, DUFD-ER,"). 

Column "Licenses" on list "B" has a column with all my licenses and also their IDs, one per row. I am trying to compare the licenses in the licensesLabel to see if any of them are in the column "Licenses" on list "B" so I can retrieve their IDs. The problems are:

1- I am comparing multiple values vs one (licenses label vs "Licenses" column)

2- The values in the licensesLabel are separated by comma.

 

Hope this helps 😕

 

Thanks again!

Highlighted
Community Champion
Community Champion

Re: Matching concatenated licenses in Sharepoint Column

I get the picture now.

In that case concatenate those column in ListB and use that column for comparison, like for like.

 

Create a collection Onvisible or OnStart

ClearCollect (ColListB, Addcolumns (ListB,"ConCatColumn", Concatenate (ListBColumn1,ListBColumn2)))

 

Then revise the formula to

LookUp(ColListB,ConCatColumn=Textbox1.Text,ID)

 

Ensure to use exact same Concatenate formula you used in the Textbox in the collection of different from what I did

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,228)