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!
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.
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.
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!
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
199 | |
99 | |
59 | |
58 | |
55 |
User | Count |
---|---|
257 | |
161 | |
88 | |
79 | |
68 |