cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALP2
Helper III
Helper III

Autopopulate fields after input values

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ragavanrajan
Super User
Super User

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.

View solution in original post

2 REPLIES 2
ragavanrajan
Super User
Super User

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
Helper III
Helper III

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

Helpful resources

Announcements
Carousel Community Blog

Check out the Community Blog

Read all about the most recent blogs in the community!

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Carousel News & Announcements

What's New in the Community?

Check out the latest News & Events in the community!

Users online (4,493)