Hi, I am looking for the best approach to this problem
I have a field that has multiple values separated by a "," I am currently splitting and displaying only the first value with
Last(FirstN(Split(ThisItem.Person,","),1)).Result
I have run into an issue that the data is not tidy and some additional delimiters have been used, such as ";".
I now need to either split on "," OR ":", Or run a substitute command before running the existing command
Substitute( ThisItem.Person, ";", "," )
I am not sure how to achieve either,
run both Last(FirstN(Split(ThisItem.Person,","),1)).Result AND Substitute( ThisItem.Person, ";", "," ) at the same time
OR
append ";" into the list of possible delimiters
Last(FirstN(Split(ThisItem.Person,","),1)).Result
I hope this post makes sense.... And someone can point me in the right direction.
Solved! Go to Solution.
Hi @Destek11 ,
Try
Last(
FirstN(
Split(
Substitute(
ThisItem.Person,
";",
","
),
","
),
1
)
).Result
although in the case above it would simply be
First
Split(
Substitute(
ThisItem.Person,
";",
","
),
","
)
).Result
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hi @Destek11 ,
Try
Last(
FirstN(
Split(
Substitute(
ThisItem.Person,
";",
","
),
","
),
1
)
).Result
although in the case above it would simply be
First
Split(
Substitute(
ThisItem.Person,
";",
","
),
","
)
).Result
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Works perfect, thank you very much.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
190 | |
70 | |
50 | |
38 | |
28 |
User | Count |
---|---|
243 | |
114 | |
91 | |
91 | |
71 |