web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Parse text

Power Apps

Answered

Parse text

(0) Share

Report

Report

Posted on by pengwei

139

Hi,

I need help to parse text.

The text was obtained as below. How can i obtain only the Document Name column and show in Text label in Power Apps?

```
| No. | Document ID | Document Name |
| -------- | -------- | -------- |
| 1 | ac5a956a3657 |file1.pdf |
| 2 | aa750aaef02f | Test2.pdf |
| 3 | 9e36e0868e74 | file3.pdf |
| 4 | f75cc33b1644 | file.pdf |
| 5 | f083f89d3a0e | file.pdf |
| 6 | f95bd41ca060 | file.pdf |
| 7 | ae113527b13d | file.pdf |
```

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Throw the text into a text box or label.
Drop a button on the screen - In the OnSelect property of the button:
Clear(col_DocNames); ForAll( Split( TextInput1.Text, Char(10) ), Collect( col_DocNames, { index: Value(Last(FirstN(Split(Value,"|"), 2)).Value), identifier: Last(FirstN(Split(Value,"|"), 3)).Value, docName: Last(FirstN(Split(Value,"|"), 4)).Value } ) );

Now you can get a document name via it's id:

LookUp(col_DocNames, index = 2, docName)
Verified answer

pengwei 139 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @DJ_Jamba , it helped me a lot.

Join the conversation