Splitting a concatenated value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello - can anyone tell me what is wrong in my approach here? I am getting errors of incompatible

type of comparison on this formula but im not sure how else i can achieve this? Need to update sharepoint list records based on a selection that had a concatenated applied to it. I though i could use Split to find the value after the spitting value and have it work that way? I'm sure i am over-simplyfing maybe what i need to code for.

UpdateIf('Trailer Tracking',Trailer.Value = ThisRecord.Trailer.Value, Dock.Value = Last(Split('374B1Choice'.Selected.Result, " - ")));

374B1Choice code

Distinct(Filter('Trailer Tracking',Trailer.Value="OPEN"),Concatenate(Building.Value," - ", Dock.Value))

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Your UpdateIf function requires a record with the changes you want to make.

Please consider changing your Formula to the following:

UpdateIf('Trailer Tracking', Trailer.Value = ThisRecord.Trailer.Value, {Dock: {Value: Last(Split('374B1Choice'.Selected.Result, " - ")).Result}} );

I hope this is helpful for you.

Was this reply helpful? Yes No