Answered

Split Function in PowerPlatform - Error

(0) Share

Report

Posted on by Peter1991

Hello everyone,

I would like to import the "Eingabe" textbox into my Tabelle2 Excel. The text should be split by the "|" symbol and then inserted into the fields one after the other.

Unfortunately, I always receive the error message with my code.

In the code, "Split" is not recognized in the "Input.Text" namespace.

Code:

Patch(
Tabelle2;
Defaults(Tabelle2);
{
'Sendungs-ID': Value(Eingabe.Text.Split("|").First());
'Anrede': Eingabe.Text.Split("|").Skip(1).First();
'Titel': Eingabe.Text.Split("|").Skip(2).First();
'Firma': Eingabe.Text.Split("|").Skip(3).First();
'Vorname': Eingabe.Text.Split("|").Skip(4).First();
'Nachname': Eingabe.Text.Split("|").Skip(5).First();
'Name_zusatz': Eingabe.Text.Split("|").Skip(6).First();
'STR_': Eingabe.Text.Split("|").Skip(7).First();
'HNR': Eingabe.Text.Split("|").Skip(8).First();
'PLZ': Eingabe.Text.Split("|").Skip(9).First();
'Ort': Eingabe.Text.Split("|").Skip(10).First()
}
)

Can anyone help me with this?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Please try this formula:

Patch(
Tabelle2,
Defaults(Tabelle2),
{
'Sendungs-ID': Value(First(Split(Eingabe.Text,"|")).Value),
'Anrede': Last(FirstN(Split(Eingabe.Text,"|"),2)).Value,
'Titel': Last(FirstN(Split(Eingabe.Text,"|"),3)).Value,
'Firma': Last(FirstN(Split(Eingabe.Text,"|"),4)).Value,
'Vorname': Last(FirstN(Split(Eingabe.Text,"|"),5)).Value,
'Nachname': Last(FirstN(Split(Eingabe.Text,"|"),6)).Value,
'Name_zusatz': Last(FirstN(Split(Eingabe.Text,"|"),7)).Value,
'STR_': Last(FirstN(Split(Eingabe.Text,"|"),8)).Value,
'HNR': Last(FirstN(Split(Eingabe.Text,"|"),9)).Value,
'PLZ': Last(FirstN(Split(Eingabe.Text,"|"),10)).Value,
'Ort': Last(FirstN(Split(Eingabe.Text,"|"),11)).Value
}
)

Please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks
Peter1991 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Thx for your help. It works now.