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 Apps
Answered

Duplicating Data

(0) ShareShare
ReportReport
Posted on by 28

So i have a line in my app that is a Number i want that number to automatically be inputted to the number line of a new form when the new form is created. how would i do that?

Categories:
I have the same question (0)
  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Wally0114 

    Assuming you are using a form to create a new record, in the default property of the control inside the card for your number: Coalesce(Parent.Default, yournumber) . 

    The Coalesce() function reads the elements from left to right until a nonBlank one is found. In a new form, the Parent.Default will be blank and yournumber will be inserted.  If the form is in edit mode, there will be a Parent.Default and it will be the one in the control.

    A common use is to assign the next ID number in a series so in that case,

    Coalesce(Parent.Default, First(Sort(table, ID, Descending)).ID+1)  will assign the next ID number regardless of the number of records in a list. 

  • Verified answer
    Wally0114 Profile Picture
    28 on at

    @Drrickryp So the purpose of this app is to sign families up for a non-profit toy give away. each family is given a number called the ( Family Number) in the app. i have a button on the registration form that is to add children's information i want the family number that is given on the parent form to automatically go onto the Childs form when the button is pushed and a new child info form is created.

     

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Wally0114 

    It will work well in this case.  Coalesce(Parent.Default, FamilyNumber)  if the family number is coming from a gallery, you would use Coalesce(Parent.Default, Gallery1.Selected.FamilyNumber)

  • Wally0114 Profile Picture
    28 on at

    @Drrickryp Thank you. 

     

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Wally0114 

    Glad to help a worthy cause.  You should hide this card so a user can't change it. _ToyIgor.jpg

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 335 Most Valuable Professional

#2
11manish Profile Picture

11manish 166

#3
sannavajjala87 Profile Picture

sannavajjala87 71 Super User 2026 Season 1

Last 30 days Overall leaderboard