web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How do I get a form fi...
Power Pages
Unanswered

How do I get a form field to use data from a table?

(0) ShareShare
ReportReport
Posted on by 36

I have a form field that needs to decide if it let a user continue or show an error message by looking at the information in a dataverse table or dataflow. 

 

The table has number and delete rows. If the user types a number that equals false, then they need an error message. 

 

I have no clue how to connect the table or dataflow to the form field. I have used a lookup column and it connects but I need it in a number column. 

 

Does anyone have any idea how to do this using portal and basic forms with powerapps tables or dataflows? Thanks for the help.

Categories:
I have the same question (0)
  • ragavanrajan Profile Picture
    7,044 Most Valuable Professional on at

    Hi @elll 

     

    At a high level, if you use dataflows then it will actually create a dataverse table for you. 

     

    For your scenario, 

    1. Most likely you need to use jQuery/ javascript in your basic form and check the validation 

    2. Throw an error message as per your condition specified. 

     

    Using OOB error message we can display if the record fails to save or some basic scenarios.  So I presume you need jQuery to achieve this. 

     

    Please post a screenshot to understand better. 

     

    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.

  • e.lll Profile Picture
    36 on at

    I think I need to use JQuery but I don't know how to reference the table.  
    Screenshot (8).png

     

    Screenshot (10).png

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 53

#2
DP_Prabh Profile Picture

DP_Prabh 40

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 28 Most Valuable Professional

Last 30 days Overall leaderboard