Firstly: this question probably sounds similar to this one.
But that query could not answer my question as far as I could tell.
I have a table which uses a projectCode column to establish whether a given record is a parent, child or subchild.
Parent entries are denoted as a number, eg 6.
Child entries are denoted as a number, a comma and then another number. Eg 6,8.
Subchild entries follow this theme, with 2 commas. Eg 6,8,3.
It would be useful for me to use 'number of commas in projectCode' logic to establish whether a given item is a parent, child or subchild in powerapps, but I can't figure out how to do this. Ideas? Thanks!
Solved! Go to Solution.
@Anonymous
My suggestion would be to use SPLIT to change the Text data into a single column table and then COUNTA the rows.
CountA(Split(TextInput1.Text,","))-1
It just so happens I responded to a similar question last night so the code was still available in my forum testing app.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@Anonymous
My suggestion would be to use SPLIT to change the Text data into a single column table and then COUNTA the rows.
CountA(Split(TextInput1.Text,","))-1
It just so happens I responded to a similar question last night so the code was still available in my forum testing app.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@Anonymous
No problem at all. If my post solved your issue please mark it as the Solution to close the thread.
Unfortunately I had to re-upload the (static excel) data this afternoon and now each 'split' function is presenting an 'invalid argument' error. I tried formatting all ID_numbers as text in excel but this did not solve the issue. And using text() to wrap the function like below simply meant that the split() function was ignored/not executed:
CountA(Split(Text(TextInput1.Text),","))-1
Also, entering '.text' at the end of textInput1 in your example did not make it a valid argument type. This is just a column of plain text values...do you know what's going on? Thanks.
User | Count |
---|---|
198 | |
105 | |
88 | |
45 | |
43 |
User | Count |
---|---|
245 | |
105 | |
103 | |
65 | |
60 |