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

All responses (6)

Answers (2)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(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
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(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)
Verified answer

Ethan_009 4,840 Moderator on at

Like
a
(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
timl 37,287 Super User 2026 Season 2 on at

Like
a
(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?
lucalo 10 on at

Like
a
(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
Emanshu 30 on at

Like
a
(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.