Answered

IsMatch text(datacardvalue) against current user email (lower(users).Email) is not working since authoring version 3.23055.16 - Customize Sharepoint

(1) Share

Report

Posted on by lucalo

Hello,
- Power apps to customize Sharepoint Forms -

we set a field to be shown only if the current user email is contained in another text field and work correctly with the Power Apps release 3.23052.19.

Formula is: IsMatch(Text(DataCardValue304),Lower(User().Email), MatchOptions.Contains and the error we are getting when customizing form is "Regular Expression Must be constant values"

I try to change the powerapps authoring version to 3.23061.17 (the only one i could choose as alternative) but the problem persists.

Have anyone suggestion on how to overcome that problem?

Thank you,

Luca

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @lucalo ,

Do you still face issue if you use following code?
With( { TextToCheck: DataCardValue304.Text, TextToMatch: Lower(User().Email) }, IsMatch(TextToCheck, TextToMatch) )

Hope this helps

Was this reply helpful? Yes No
Verified answer

timl 36,774 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@lucalo

As far as I'm aware, the second part to IsMatch has never been able to accept a dynamic value (eg User().Email) as highlighted in the documention.

https://learn.microsoft.com/en-gb/power-platform/power-fx/reference/function-ismatch

If you want to see if the user name is contained in the text input control, this formula will do it.

(Lower(User().Email) in DataCardValue304.Text)

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @timl ,

Thanks for bringing this, although isn't it possible defining as variable then using it?
Recent Community Post

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Ethan_R

I don't think it's possible to work around this with a variable - the documentation states 'without any variables'.

Does it work for you when you attempt to use a variable?

Was this reply helpful? Yes No
lucalo 10 on at

Like (1)

Report
Copy link

Link copied!

thanks @Ethan_R and @timl ,
Using
If(Lower(User().Email) in Text(DataCardValue304),true)
seems to work correctly.
I didn't aware of the boundaries of ismatch(), and strange things is that is actually working in our customized forms with oldest authoring version created some years ago. I will have to apply correction but at least I know why is in error.

Bye

Was this reply helpful? Yes No
Emanshu 30 on at

Like (0)

Report
Copy link

Link copied!

We have been utilizing the same formula for Years. So I am also not sure why all of sudden an error is being generated. @microsoft ????

Also it only provides the error in Edit mode, if we access the application as a user it works correctly.

(Lower(User().Email) in DataCardValue304.Text)
The above does work as an alternative. So thank you for providing a solution.

Was this reply helpful? Yes No