web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Apps
Answered

Find minimum qty

(0) ShareShare
ReportReport
Posted on by

Im starting with a comma delimited label. 

 

I take that label and put it through a ForAll loop, using the split function. 

For each value I do a conditional and it spits out a number.. 

 

This works great in a drop down control. 

 

My end goal is to take the above at get the minimum calculated value and put that into a different label. 

 

The Forall command fails as it expect a text string

The Min command expects a value, 

The Value command to change the string to a number doesnt work. 

 

What am I doing wrong?

Categories:
I have the same question (0)
  • Verified answer
    jimi_hendrix Profile Picture
    on at

    resolved....

     

    Min(

    ForAll(
    Split('Label Control'.Text, ", "),
    If( CountIf('List'.AllItems, Result in 'Area'.Value) * (10/3) >= 10,
    Value(10),
    Value(CountIf('List'.AllItems, Result in 'Area'.Value) * (10/3))
    )
    ),Value)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 405 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 280 Super User 2025 Season 2

#3
Kalathiya Profile Picture

Kalathiya 272

Last 30 days Overall leaderboard