Autopopulate fields after input values

[ALP2]

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?

[ragavanrajan · Accepted solution]

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]

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