Hi Powerapps Community,
I have text label in gallery which takes data from a column(sharepoint), I want to extract a specific string from this text label.
For example : the text label can be :
1. Nursery(Level 3):Total Kits:5
-------------------------
Nursery(Level 3):Shorts:Size:11:Qty:5:KitFee:6500
Total Amount:32500
*************************
PlayGroup(Level 2):Total Kits:5
-------------------------
2. PlayGroup(Level 2):Kits:1
3.PlayGroup(Level 2):Kits:1:KitFees:5500:
UKG(Level 5):Kits:7:KitFees:5500:
so I want to extract number of kits from PlayGroup class , there are 3 scenarios from 1st option starting delimitor = "PlayGroup(Level 2):Total Kits:" and last demilitor is "-" . Just like I pick text between two delimitors(5), I want to pick same text from other 2 options because data reside in column in sharepoint is in different manner. The delimiter in other two options are "PlayGroup(Level 2):Kits:" and " "(space) ,from 3rd: "PlayGroup(Level 2):Kits:" and ":".
I used this formula but it works only for one of the option:
With(
{
wFirst:
Last(
FirstN(
Split(
ThisItem.ClassOrdered,
"PlayGroup(Level 2):Total Kits:"
),
2
)
).Value
},
Left(
wFirst,
Find(
"-",
wFirst
)-1
)
)
The above formula is working only for 1st option , I used || operator after 1st with() function but it returned false not a number.
Then I used || for find function but still it returned irregular results.
I would appreciate any response.
Regards,
R
