Power Platform Community Forum Thread Details

Hi Team,

I am needing a little assistance with my formula. I have made a Collection with a bunch of words all with different word Lengths from 1 all the way to 8. I have two input text fields that show a random word within it once a button is pressed. What I am trying to do is only show the words that are equal to the input number of characters within the word. I am also trying to make it add both Input text boxes together based on the character. Please find an example below of what I have done. I can only get the output to show both words combined and it cuts off the second word if it's longer than the value.

Categories:

Building Power Apps

hi @mholdsworth2022

I dont know if i understand what you asking the right way but you can try this.

Add another Collection

ClearCollect(
 WordlistWithLen,
 AddColumns(
 Wordlist,
 "Length",
 Len(Value)
 )
)

This will give you the word and associated length, i added a wordlist to show the result

You can filter this list based on the length you select. i will do this with a drop down and i will add a label to show the response.

add a label and set the test as follows:

Concat(
 Filter(
 WordlistWithLen,
 Length = Dropdown1.SelectedText.Result // in your case this will be the texy box with the length
 ),
 Value,
 " "
)

(i chose a dropdown so the user do not enter a length that's not in the wordlist.)

Result

Peek 2022-06-17 19-42.gif