cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elll
Helper I
Helper I

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

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.

2 REPLIES 2
ragavanrajan
Super User
Super User

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.

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

 

Screenshot (10).png

 

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 (1,817)