cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jebelsan
Level: Power Up

Text analyst

I'm trying to create an app and I'm facing the following problem.
I first scan a QR code, from which I get information separated by punctuation marks:
Title1,Information1;Title2,Information2;Title3,Information3;
With this information I want to fill in several information boxes in which the title is already (coincides in both). In other words, I want you to fill in the Title1 box with the Information1.
Could you help me with this problem of how to analyze a complete text?
Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Text analyst

Hi @Jebelsan ,

Do you want to fill in information to corresponding textinput controls by using a long text?

If so, I've made a similar test for your reference:

1)insert a lable named Label1

set it Text: 

"Title1,Information1;Title2,Information2;Title3,Information3;"

2)insert 3 lables named  Label2, Label3, Label4

insert 3 textinputs named textinput1,textinput2,textinput3

Set Lable2's Text: "Title1"

Set textinput1's Default: 

Replace(LookUp(Split(Label1.Text,";"),Label2.Text in Result,Result),1,7,"")

Set Lable3's Text: "Title2"

Set textinput2's Default: 

Replace(LookUp(Split(Label1.Text,";"),Label3.Text in Result,Result),1,7,"")

Set Lable4's Text: "Title3"

Set textinput3's Default: 

Replace(LookUp(Split(Label1.Text,";"),Label4.Text in Result,Result),1,7,"")

 

Then, the corresponding textinput controls will be filled in corresponding information.913.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Text analyst

Hi @Jebelsan ,

Do you want to fill in information to corresponding textinput controls by using a long text?

If so, I've made a similar test for your reference:

1)insert a lable named Label1

set it Text: 

"Title1,Information1;Title2,Information2;Title3,Information3;"

2)insert 3 lables named  Label2, Label3, Label4

insert 3 textinputs named textinput1,textinput2,textinput3

Set Lable2's Text: "Title1"

Set textinput1's Default: 

Replace(LookUp(Split(Label1.Text,";"),Label2.Text in Result,Result),1,7,"")

Set Lable3's Text: "Title2"

Set textinput2's Default: 

Replace(LookUp(Split(Label1.Text,";"),Label3.Text in Result,Result),1,7,"")

Set Lable4's Text: "Title3"

Set textinput3's Default: 

Replace(LookUp(Split(Label1.Text,";"),Label4.Text in Result,Result),1,7,"")

 

Then, the corresponding textinput controls will be filled in corresponding information.913.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 80 members 5,471 guests
Please welcome our newest community members: