Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Re: Concatenate with Conditional Statement


Well, you can treat this list a datasource at this point, so you can do a lookup on myTeamRegistrationCollection (or whatever you call it).

So, I believe you want to look up one value in the list to see if it exist elsewhere.  There is a slight flaw to this logic in that you (in your sample data) had an "Exists!" on one of the records.  The flaw is...which record determines the problem?  Theoretically, the first experience of it in your list "Exists!" also.  

But, I don't believe that is your issue as much as you just want to look to see if a value about to be submitted exists already.  For that you can do a simple lookup.

   Lookup(myTeamRegistrationCollection, ConcatenatedColumn = whatYouAreComparing, true)

Would return true if the lookup has a result.  And thus...exists.


Hope that helps.

Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Level 8

Re: Concatenate with Conditional Statement

Perfect! Thanks for the awesome explanation and the support! In the true environment there will and should not be any duplicated record (that's why we're catching it during the submit stage). 

Helpful resources

New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,878)