web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calculate zipcode rang...

Power Apps

Answered

Calculate zipcode ranges available

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

I am making an app where admins can enter postcoderanges between 1000-9999. To make it easy for them i would like to show them which ranges are still available.

In the screenshot below you can see there is a range available between 2531 and 2599. This is the only range that is still available between 1000-9999.

How would i be able to display it like this:

Available zip ranges:

2531 - 2599

The datasource "Custom Entity [dbo].[PostcodeRange]" looks like this:
(There are duplicates because companies are related to the ranges)

I would need some kind of forall loop that checks for available ranges between start and end zip codes.

Best Regards,

Anthony

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

How do you determine if a range is available?
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AnthonyDo ,

I did a test for you.

I assume the range is 1-20.

Add a button control and set its onselect property to:

ClearCollect(Col,{Value:1});Clear(Col);ForAll(LIST168 As A,If(CountRows(Filter(ForAll(LIST168 As B,If(A.PostcodeStart>B.PostcodeStart&&A.PostcodeStart<B.PostcodeEinde,{Value2:1})),!IsBlank(Value2)))=0,Collect(Col,{Value:A.PostcodeStart})));ForAll(LIST168 As A,If(CountRows(Filter(ForAll(LIST168 As B,If(A.PostcodeEinde>B.PostcodeStart&&A.PostcodeEinde<B.PostcodeEinde,{Value2:1})),!IsBlank(Value2)))=0,Collect(Col,{Value:A.PostcodeEinde})))

Add a combo box control and set its Items property to:

SortByColumns(Distinct(Col,Value),"Result")

The result is as follows:

Best Regards,

Wearsky

Join the conversation