cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 III
Dual Super User III

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 III
Dual Super User III

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
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,699)