ClearCollect(myCol ; Filter( 'My Document Library' ; IsMatch('Path' ; Concatenate(Trim(DataCardValue1.Text); "/" ; DataCardValue2.Text); MatchOptions.Contains & IgnoreCase))
This indicates an error in the IsMatch function saying there are invalid arguments (it's the format/regex part).
Replacing Concatenate(Trim(DataCardValue1.Text); "/" ; DataCardValue2.Text) with "<An Example String>" makes the whole thing return what i want it to but i need to use my DataCardValues to calculate the filter.
Is there something im missing to how you can reformat the Text to be accepted as a Regex argument to IsMatch?
Any other possible solutions to the thing i am trying to achieve, which is to filter out only the files under a certain folder in a document library?
Thanks In Advance
Marcus

Report
All responses (
Answers (