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
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
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
User | Count |
---|---|
231 | |
109 | |
94 | |
57 | |
30 |
User | Count |
---|---|
291 | |
126 | |
106 | |
62 | |
57 |