Powerapp Portal Curd Operation with Java Script/Web API

[Rakesh26]

Hi There!

I am working on portals am facing a problem while working on these.

1) I create an HTML form and want to make submit data using javascript or a web API to my entity. but I am not able to do so.

2) I want to create a Sharepoint web page to display all of the data from the entity to this page using CDS. but not able to do this.

Can anybody give me a solution for this?

Thanks

Rakesh

[v-xida-msft]

Hi @Rakesh26 ,

For your first question, do you want to submit your HTML form data using JavaScript within your PowerApps Portal?

Based on the needs that you mentioned, I think JavaScript code could achieve your needs. Firstly, you need to embed your HTML form into a web page in your Portal using JavaScript code.

After that, you could use the JavaScript (jQuery) code to submit your form data:

$('#form_Id').submit()

Please check and see if the following blog would help in your scenario:

https://debajmecrm.com/2020/03/11/quick-tip-save-a-record-in-powerapps-portals-using-custom-button-o...

More details about using JavaScript code in Portal, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/add-custom-javascript

In addition, if the HTML form data would be saved to your own server, I think  $.ajax() function would achieve your needs. Please take a try with the following function in your PowerApps Portal Web Page:

$.ajax({
     url: 'Type your Target Server URL Here',
     method: 'POST',
     data: {
            property1: "xxxx",
            property2: "xxx",
            ....
     },
     dataType: 'json',
     success: function(data, status, xhr){
               console.log("Ajax request successfully: " + data)
             },
     error: function(error){
              console.log("Ajax request fail: " + error)
         }
})

For your second question, do you want to create SP Site Page, then display data from your CDS Entity? Based on the needs that you mentioned, I afraid that there is no direct way to achieve your needs. There is no Web Part supported in SP Site Page to retrieve data from CDS Entity.

As an alternative solution, you could consider generate a canvas app (Tablet Lauout) based on your CDS Entity, then you could embed your canvas app into your SP Site Page through "Microsoft PowerApps" Web part or <Embed> web part. You could preview these records from your CDS Entity through the embedded canvas app in your SP Site Page.

Please check and see if the following article would help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/embed-apps-dev

Best regards,

[Rakesh26]

Hi

Thanks for reply 

But this is not working for me.

Here what I am looking is 

Suppose  I HTML Page  where I am inputting  following data on the Power app portal
Name, Address, Date of birth and Phone no

A  button on Page "Save" When I click on the save button it should take my data and insert the data in CDS  Entity. Using Java script  or any API which can do this function for me 

Thanks

Rakesh

[OOlashyn]

Hi @Rakesh26 ,

For now, there is no web API available in the Portal for CRUD operation. It should be available in preview somewhere in June, but there is no date when it will be GA. To save the data to CDS you should create an entity form (see here) or a web form (for multiple steps process - see here). You should have an entity in CDS that will have all the fields that you want to populate (or multiple entities that you can relate them). Then you just create an insert entity form or web form with all the necessary fields, configure proper entity permissions (if necessary for security) and then add it to a web page. Then user will be able to go to the web page, populate data and submit it to CDS.