cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PytByt
Level 8

How to use IsMatch and BeginWith Correctly

HI all..

I need to make this work:

ClearCollect(BatchColl1, ShowColumns(Filter(ItemBatches,IsMatch(BatchNumber, BeginsWith = ^A & ^B & ^C)),"ItemNumber", "BatchNumber", "BatchExpirationDate"));

I want to create collection where the Batch Number IsMatch Alphabetically from A to Z and also from 0 to 9.

How i should use the formula correctly?
Please help.

Regards.

pytbyt

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to use IsMatch and BeginWith Correctly

Hi @PytByt ,

 

By "from A to Z and also from 0 to 9", may I know how would you like this to be achieved? Please explain with some sample data.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PytByt
Level 8

Re: How to use IsMatch and BeginWith Correctly

Hi @v-monli-msft 

Thank for your reply.

I need to create a collection from my Entity called ItemBatches, which contain all of its data that begin with A through Z and begin with 0 through 1 and store it in column "ItemNumber", "BatchNumber", "BatchExpirationDate".


I dont know how else to explain... 

I thought the formula could explain it self? haha.. 

Regards.

pytbyt

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

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