Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Emily Lederer]

I have a basic form on my portal that needs to check two columns in a dataverse table
1. the user types an item number in the form field
2. when they tab out of the field the form either shows an error message or let’s them continue with the form.
3. the form field need to take the users item number and search for it in the table
4. then check the next column to see if that item number can be deleted (yes/no)

I am pretty sure this needs to be done using JQuery, but I can not figure out how to reference the table in the code. I have looked all over and can’t find anything regarding the dataverse table. I can connect tables using the lookup column, but I need it on a normal number column.

I have this http address (can’t show the full address here) :

dynamics.com/api/data/v9.2/$metadata#cr598_positiondatas

I have tried this code:

$(document).ready(function() {
    $("#pn_deactivatepositionnumber").blur(function(){
       $.ajax({
           method: "GET",
           url: "",
            sucess: function(result) {
                console.log(result)
            }
       });
    });
});

I have also tried: 
get element by id (but this only grabs items already in the html file), src() and source: [].
I have also tried using the urls, ids, classes, making a power automate and workflow, business process flow, condition columns, etc. none were able to connect it (or I am just not doing it right. 

Am I supposed to change the table into another file type and then use ajax? Please if anyone even has a guess I would really appreciate it!

——————————
E L
new portal apps user
——————————

[S W]

Hi Emily

I have a similar requirement to this that I’m looking to implement. Were you able to find a way to check data in Dataverse from the portal form prior to submission to a table?

Thanks

——————————
S Worrell
——————————
——————————————-