News and Announcements icon

Power Platform CommunityForums Power Pages - Power Apps Portals Fetch data entity form

Power Pages - Power Apps Portals

Unanswered

Fetch data entity form

(0) Share

Report

Report

Posted on by AndKanPA

214

Hello community,

how can I fetch data from entity in a form.

There is one field where is entered a number from parent entity.

Major entity: project

Child entity: order

When a new order is added and project number is entered, should be checked:

- project number exists?

- how many orders already in project? (to create next number for new order)

My idea is, to use a entity form, mode insert and add in its avdanced options some JavaScript code which does the checks in background.

Any help oder other ideas?

PS I know the posibility to add related records ... 😉

Thanks,

AndKan

All responses Img

All responses (1)

Answers Img

Answers (0)

oliver.rodrigues 9,342 Most Valuable Professional on at

Like (0)

Report

Re: Fetch data entity form

hi, maybe I am misunderstanding but:

When a new order is added and project number is entered, should be checked:
- project number exists?
- how many orders already in project? (to create next number for new order)

if you set the Project Number as required, you don't need to verify if it exists
next-number --> I think you should consider auto-number solutions here, you can use the OOB auto-number field (although this would always be a sequential, and not dependent on the Project record).. or you can use custom solutions (plenty of articles online) that would contain a "counter" record and then associating with the records: https://d365goddess.com/custom-auto-numbering/

------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Pages

#1

Lucas001 60 Super User 2025 Season 1

#2

Fubar 55 Super User 2025 Season 1

#3

surya narayanan 35

Last month Overall leaderboard

Featured topics

Updates on Power Apps Portals - PLEASE READ

Product updates

Microsoft Power Platform Community release plans