web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Record User who submit...
Power Pages
Answered

Record User who submitted a form in the same Table of the form

(0) ShareShare
ReportReport
Posted on by 16

Hi there!

I am working in a project where I have a form in a Page that once is submitted create a new record in a PowerApps table that triggers a Power Automate Flow.

How can I record in this same table the user information such as User Name and E-mail (and others information that are in the user profile registered in Power Pages) who submitted the form?



Categories:
I have the same question (0)
  • Fubar Profile Picture
    8,497 Super User 2026 Season 1 on at

    Usually just capture the Contact and their Account (as email addresses etc may change over time) unless there is a specific requirement to capture other details at the time of submission.

     

    Add a Contact Lookup to the Table your form is for.  Then use the Portal/Power Pages Management App and go your your form definition and then do one of:

    • Under "Additional Settings" Tab check the Associate Current Portal User and select the Lookup field; Fubar_1-1714456151416.png

       

    • or Add a form Metadata record (type = attribute) select the Lookup for Attribute Logical Name, then in the Set Value On Save section, for Type select Current Portal User and in Form Attribute select Contact(contactid)Fubar_0-1714456081394.png

       

    Both work the same for capturing the Contact, the Metadata record allows you to populate other values from the Contact record (e.g. can do the same with parent Account into an Account Lookup).

    I usually do 2 Lookups one for Created By and another for Modified By (and populate 1 on the Insert form and the other on the Edit form) and will also do a Modified Date field (so can see what time something was modified from the portal vs a Dataverse user)

    (Similar settings also exist on the Steps in multistep forms)

  • Verified answer
    TayroniHenrikso Profile Picture
    16 on at

    Hello @Fubar !
    Thank you very much, buddy!
    It worked to retrieve the name of the user, but I did not found a way to retrieve the e-mail.
    The email (even changing with time) is one important information to me, since I need to fill a form and the user's email is one of the information and after I need to send the pdf file of this form in his email.
    Since I am not so technical (and luckly no/low code is helping me to put in practice some ideas) I am depending on the foruns to finish this challenge.
    Do you mind helping me with the step by step to retrieve his email data and put it in a power apps table?

  • Verified answer
    Fubar Profile Picture
    8,497 Super User 2026 Season 1 on at

    For Email you would create a single line of text field (not a lookup).  Then do a metadata record the same as for the contact, but select the appropriate field from the list instead of Contact (contactid), the one you would want would be the address1_email (but it may be renamed Email)

  • TayroniHenrikso Profile Picture
    16 on at

    Thank you very much @Fubar 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 42

#2
Valantis Profile Picture

Valantis 24

#3
omkarsupreme Profile Picture

omkarsupreme 23

Last 30 days Overall leaderboard