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

Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Autopopulate fields af...
Power Pages
Answered

Autopopulate fields after input values

(0) ShareShare
ReportReport
Posted on by ALP2 242

Hi,

 

I am a beginner on power pages (portal). I'm trying to create a form like this.  The form must be accessible to anonymous users.

I have a contact table into which I imported customer data from a SQL database).

I would like that when the anonymous user enters his ID + email address, that his customer information contained in the contact table is displayed

Is that possible?

 

 

ALP2_1-1667957508348.png

 

 

Categories:
General topics
I have the same question (0)
  • Verified answer
    ragavanrajan Profile Picture
    ragavanrajan 7,044 Most Valuable Professional on at

    Hi @ALP2 

     

    There are few approaches you can take 

     

    1. Let's say they enter their id and email address and hit the Submit button. Then you can call the Power Automate Dataverse trigger and retrieve the information from the contact table and display it in relevant fields. 

     

    2.  you can use portal web API and call the contact table. Official reference here 

     


    Hope it helps. 
    ------------

    If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

  • ALP2 Profile Picture
    ALP2 242 on at

    sorry for the delay.

    I was doing some tests. It seems to be working. 

    I m avoiding the API Call because i'm not a developer. it's too technical for my brain 😄

     

    Thanks again

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

News and Announcements

Welcome to the Power Platform Communities
Sign Up for Ask a Community Pro Today!
Share your business problems and get Power Platform leaders' perspectives!

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 December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Suriyanarayanan V Profile Picture

Suriyanarayanan V 39

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 28 Most Valuable Professional

#3
Fubar Profile Picture

Fubar 18 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans