Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

How to validate a number field on a form using data from a separate table?

(0) ShareShare
ReportReport
Posted on by 5

Hello,

I have a power portal form with a field 'item number delete', the user types a number into this field and the form searches for that number in a separate table. When it finds the number, it then will go to the next row to see if that item number can be deleted (yes or no). If no, the user gets an error message. If yes the user continues as normal. 

so for example there's:

form- #form

form field- #itemnumberdelete

table- #table

table row 1- #itemnumber

table row 2- #delete

My issue is that I can't figure out how to reference the table in the JQuery code. 

I can reference the form field using its id: $(#itemnumberdelete)

but I can't figure out how to reference the separate table. 

Screenshot-_2800_8_2900_.png_2D00_640x480.pngScreenshot-_2800_10_2900_.png

I can also access the table data and table definition where it show the api url. If anyone could tell me what they think might work, I'd really appreciate it! Thanks!

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: How to validate a number field on a form using data from a separate table?

    Hi e.lll,

    You could get the value of 'item number delete' first. Then you can get the separate table's data which is matched through web api.

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

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 181 Super User 2025 Season 1

#2
Siv Sagar Profile Picture

Siv Sagar 149 Super User 2025 Season 1

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 124 Super User 2025 Season 1

Product updates

Dynamics 365 release plans