Answered

Look up function

(0) Share

Report

Posted on by LA-07111402-0

I've created a lookup function to set a variant. I want to set the variable to the first letter placed in a text box if it does not contain a P or the first 2 letters in the variable if it does. This is my formula:

Set(varEventCode, If(IsBlank('EventSiteCode-TotalContact'),"", 'EventDate-TotalContact'.Text = Left("P",2),Left(Upper('EventSiteCode-TotalContact'.Text),2), Left(Upper('EventSiteCode-TotalContact'.Text),1)))

It doesn't seem to work with the else value asking for the number of characters set to 1. What am I missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Lisea123

Not sure of the value the variable will bring to you, but in general, your formula should be the following:

With({_val:Left(Upper('EventSiteCode-TotalContact'.Text),2)}, If(StartsWith(_val, "P"), Left(_val, 1), _val) )

I hope this is helpful for you.

Was this reply helpful? Yes No
LA-07111402-0 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this. I need my variable to be 2 characters if the text in EventSiteCode starts with a P and only 1 character if it starts with anything else.
So do I just flip your formula?
With({_val:Left(Upper('EventSiteCode-TotalContact'.Text),1)},If(StartsWith(_val,"P",Left(_val,2),_val))
I tried this and it didn't work. 😞

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Lisea123

The formula already accounted for that.

With({_val:Left(Upper('EventSiteCode-TotalContact'.Text),2)}, If(StartsWith(_val, "P"), Left(_val, 1), _val) )

In general it reads like this:

First, get the first 2 characters of the EventSiteCode-TotalContact (we only ever care about 2 characters).

Then if the result (_val) starts with "P", then return just the first character, otherwise return the 2 characters.

So, unless I am completely misunderstanding what you are saying, the provided formula should be giving you what you want.

Was this reply helpful? Yes No
LA-07111402-0 on at

Like (0)

Report
Copy link

Link copied!

This is they way I need it.
(if the result (_val) starts with "P", then return just the 2 character, otherwise return the 1 characters.)
So can I just change the 1 to a 2? But that won't help with the ones that I only need 1 character. I need 2 characters if it's a P otherwise just 1 character.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Lisea123

Yes, got it...so change to:

With({_val:Left(Upper('EventSiteCode-TotalContact'.Text),2)}, If(StartsWith(_val, "P"), _val, Left(_val, 1)) )

Was this reply helpful? Yes No
LA-07111402-0 on at

Like (0)

Report
Copy link

Link copied!

THANK YOU!!!! Life saver!

Was this reply helpful? Yes No