Lookup formula, Splitting the Lookup Column on "|"

(0) Share

Report

Posted on by wonka1234

909 Super User 2024 Season 1

Hi all,

I have this formula -

Product descriptions is the list where I am looking up into and brining in a column from that

Product title is the tile of the column from product description I am using as a lookup.

Product Descriptions and Examples is the column I am bringing into my app.

Datacardvalue49 is my card in my app.

LookUp([@'Product Descriptions'],'Product Title' = DataCardValue49.Text,'Product Descriptions and Examples')

So in my datacardvalue49, I may have product - Vaccuum|Lite or Vaccuum|Ultra. How can I split out the "|Lite" or "Ultra" so my lookup is only done on Vacuum.

Thanks.

All responses (3)

Answers (1)

Verified answer

SpongYe 5,580 Super User 2025 Season 1 on at

Like (1)

Report
Re: Lookup formula, Splitting the Lookup Column on "|"

Hi @wonka1234

Just tried it with a LookUp in my case it is working.

First( Split( LookUp('Inventory Managements', Barcode = "1001B8R9", Category), "|" ) ).Value

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
wonka1234 909 Super User 2024 Season 1 on at

Like (0)

Report

Re: Lookup formula, Splitting the Lookup Column on "|"

@SpongYe seems to work in a label but the lookup isnt working!
SpongYe 5,580 Super User 2025 Season 1 on at

Like (0)

Report
Re: Lookup formula, Splitting the Lookup Column on "|"

Hi @wonka1234

The Split function can help you with that. My example blow used it to split from |.

My code is:

First( Split( Label4.Text, "|" ) ).Value

In you case it would be:

First( Split( LookUp([@'Product Descriptions'],'Product Title' = DataCardValue49.Text,'Product Descriptions and Examples'), "|" ) ).Value

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻