cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Display partial text from Dynamics in label.

Hi,

 

I am looking to display only part of a field from Dynamics365 in a label in PowerApps, and cannot see a way to do it, so I am assuming it is not possible.

I wonder if anyone out there can suggest a way to do this, or a possible work around. The details required are below.

 

The field in Dynamics365 states "Decrease of n% (nKG) over n day(s)".

I am looking to populate the label in PowerApps with only the percentage figure, and nothing else.

 

Any assistance or ideas are greatly appreciated.

 

Matty

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Display partial text from Dynamics in label.

Hey @MattyH 

 

You extract the percentage using:
Last(Split(First(Split(ReturnedField,"%")).Result," ")).Result
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

2 REPLIES 2
Highlighted
Dual Super User
Dual Super User

Re: Display partial text from Dynamics in label.

Hey @MattyH 

 

You extract the percentage using:
Last(Split(First(Split(ReturnedField,"%")).Result," ")).Result
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Responsive Resident
Responsive Resident

Re: Display partial text from Dynamics in label.

Works perfectly thanks!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,484)