cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hockeyman9474
Helper III
Helper III

Casting string to integer

I am extracing a number from a text string and need to convert it to integer so that I can compare it in a filter. It appears as though @int is the way to go but I am having trouble figuring out how to format. Here is what the filter looks like before it's casted:

 

Filter(dailySales,Mid(Retailer,9,1)=ThisItem.Result))

 

the number being extracted from the Retailer column is bewteen 1 and 6 and thisitem.result is definately a number because I have checked this.

1 ACCEPTED SOLUTION

Accepted Solutions
AndyPennell
Power Apps
Power Apps

Use the Value function to turn a string into a number. (PA makes no distinction betweeen doubles and integers). So if I understand your example:

Filter(dailySales,Value(Mid(Retailer,9.1))=ThisItem.Result))

View solution in original post

2 REPLIES 2
AndyPennell
Power Apps
Power Apps

Use the Value function to turn a string into a number. (PA makes no distinction betweeen doubles and integers). So if I understand your example:

Filter(dailySales,Value(Mid(Retailer,9.1))=ThisItem.Result))
Hockeyman9474
Helper III
Helper III

actually figured that out on my own, but yes value worked...thanks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,147)