Cant display email field from LastSubmit

(0) Share

Report

Posted on by JohnJDB

Hi All,

I think I have found a bug in Power Apps, or perhaps I'm just not using it right.

I submit a form and go to a new screen. The LastSubmit function can return all fields in my submitted form except the Email field. It says that the formula is incorrect.

Here's an example showing two fields being used from the submitted form.

"The last record that you submitted was for: " & NewForm1.LastSubmit.MeetingSubject & " by " & NewForm1.LastSubmit.'Bacon Bap'

But when I add the Email field from the drop down list of fields as below

It then says there's an error

I've tried just putting the email value into a text box by itself and get the same error

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello @JohnJDB

What type of column/field is Email? Is it a text or a person?

Can you confirm that the email value was stored in your database?

Also, what database are you using? SharePoint? Dataverse or Excel

Was this reply helpful? Yes No
JohnJDB 58 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your message.

What type of column/field is Email? Is it a text or a person?
In Sharepoint the SP list column shows as a "Person or Group"
Can you confirm that the email value was stored in your database?
Yes, the email seleted saved in the form shows as the users name (not their email address).
Also, what database are you using? SharePoint? Dataverse or Excel
Sharepoint.

So is the form perhaps saving it as an object, not just text?

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @JohnJDB

Yes, you are right. Can you please try this and see if there are any error:

NewForm1.LastSubmit.Email.Mail

Was this reply helpful? Yes No
JohnJDB 58 on at

Like (0)

Report
Copy link

Link copied!

I get an error "Name isn't valid. 'mail', isnt recognised. Niether is Mail. I tried putting a . after "Email" & NewForm1.LastSubmit.Email and nothing gets auto listed, like it does when you put a . after LastSubmit.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @JohnJDB

Apologies, I gave the wrong keyword, it should have been "Email".

Btw, is the name of your column Email ?

NewForm.LastSubmit.Email.Email

Was this reply helpful? Yes No
JohnJDB 58 on at

Like (0)

Report
Copy link

Link copied!

The display in in the SP list is Email, the system name is field_3. I've tried both but it still says the name isnt valid. field_3 isnt recognised. Again tried with Capital and lower case at the start of the field name. Its like PA wont accept a further dot after "Email" & NewForm1.LastSubmit

Was this reply helpful? Yes No
Verified answer

cha_cha 4,932 Moderator on at

Like (0)

Report
Copy link

Link copied!

How about

(1) recreating the column and updating power apps.

(2) Also, just close/open power apps as it might just be some cache issues.

Earlier, I was gonna suggest storing it first in the last submit to a variable like Set(varXYZ, NewForm1.LastSubmit) but when I tested, it's working on my end using the same logic as yours.

Was this reply helpful? Yes No
JohnJDB 58 on at

Like (0)

Report
Copy link

Link copied!

Hi, I recreated the column in SP. Its called Email in the List view and also called Email in the SP system.
I added it to the PA and removed the old one. I changed the formula too.

I still get an error "Invalid argument type". I think its because its a person field in SP.

Was this reply helpful? Yes No
JohnJDB 58 on at

Like (0)

Report
Copy link

Link copied!

Hold the press! Now when I type in a . i get a list of which email is one. I tried this and it works!
i.e. "Email" & NewForm1.LastSubmit.Email.Email

Thanks for your help. The solution seems to be that the Field is actually a complex object, and its possible to get the attribute email from it. This did not work until I created a new field in SP and relinked it to the PA and then tried adding .email to the end of the field name.

Was this reply helpful? Yes No