Answered

copying information from one datacard to another

(0) Share

Report

Posted on by hitty08

Ok I am building an application that involves sprints. I have four separate screens within the power app which represent each sprint. On each page I have a edit form which has the questions for each sprint. Once sprint 0 is filled out, I would like for the redundant data to be filled out for the other sprints and that is where I am running into the issue.

Example of forms on:

(Screen 1 - Sprint 0): Name, Sprint, Information, POC

(Screen 2 - Sprint 1): Name, Sprint, Information, POC, Funding

(Screen 3 - Sprint 2): Name, Sprint, Information, POC, Funding, Date

(Screen 4 - Sprint 3): Name, Sprint, Information, POC, Completed

As you can see a lot of the information would be the same, but I need a new object for each sprint within the share point list. I would like to find a way that the use only has to type "Name" in one time and it autofills to the other forms. Any information or ideas would be greatly appreciated.

I have tried setting a Global Variables a couple different ways to accomplish this with no success, any examples or ideas on how you would accomplish this would be greatly appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (31)

Answers (2)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

I assume you are submitting the Forms on each screen and you start with Sprint 0.

So, set the Default properties of the TextInput DataCardValue controls in your datacard in subsequent forms to :

Coalesce(Parent.Default, yourFirstFormName.LastSubmit.Name)

Change the other controls the same except substitute the column that you want for that for Name above.

I hope this is helpful for you.

Was this reply helpful? Yes No
hitty08 79 on at

Like
a
(0)

Report
Copy link

Link copied!

I input that formula into the default datacard value on the sprint 1 slide, but when I hit the submit button in sprint 0 (Which submits the sprint 1 form also) I get a response of "title is required" on sprint 1.

Form1 is the form where I am imputing the original data. Form1_1 is where I am trying to replicate the data to.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

So why are you submitting the other forms then at the same time as sprint 0 ???

Was this reply helpful? Yes No
hitty08 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Our users will be filling out sprint 0 only, then will edit sprint 1,2,3. Sprints 1,2,3 will have redundant information in it so I am trying to get it so that they do not have to fill out "Name" for example 4 times. Once I submit sprint 0, I need it to create 4 separate items in the sharepoint list. I have set the default sprint values to 0,1,2,3 on each of the forms.

So when you look at the Sharepoint list it is populating you will see

Project Name : Sprint 0
Project Name : Sprint 1
Project Name : Sprint 2
Project Name : Sprint 3

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

I am a bit confused as to why you would want to submit the other forms at the time that you submit the first Print 0 form. The other will be empty at that time, so they will not submit properly.

Can you explain the concept a little more as to why submitting the other forms at the time of the first is needed?

Was this reply helpful? Yes No
hitty08 79 on at

Like
a
(0)

Report
Copy link

Link copied!

User 1 opens Sprint 0 which has an edit form asking multiple questions. Three of those questions are the same on everyone form.

So on Sprint 0, Sprint 1, Sprint 2, Sprint 3 will all contain the questions below.
Project Name
Project POC
Project Description
My goal is once Sprint 0 is submitted, it autofills these three questions on every sprint form and submits them to a sharepoint list. Which will result in the list having 4 objects created resulting in something like this.

Project Name : Project POC : Project Description : Sprint 0
Project Name : Project POC : Project Description : Sprint 1
Project Name : Project POC : Project Description : Sprint 2
Project Name : Project POC : Project Description : Sprint 3

Once that is completed, a user will be able to click the edit button and fill in the "non-redundant" questions for sprint 1,2,3.

Please let me know if this makes sense.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

Yes, I understood all of that, but my question was more about why are you creating the other records at the time of submitting the first form instead of then having the user taken to the next form to complete and submit it, then move to the next and submit and so on?

Was this reply helpful? Yes No
hitty08 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Sprint 0 is filled out during the first month of the project, Sprint 1 is filled out during the second month, Sprint 2 is during the 3rd, Sprint 4 is during the 4th.

Sprint 0 is the only form filled out initially, the reset are filled out as the project progresses.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@hitty08

Gotcha!! Thanks for clarifying that part.

So then, what is the Item property of your other forms? That is going to be key to getting the record you will be creating for sprint 0.

Was this reply helpful? Yes No
hitty08 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Lets just go with the title for now.

(Sprint 0)
NewProjectScreen --> Form1 --> TitleDataCard1 --> DataCardValue1

(Sprint 1)
Sprint_1_Screen --> Form1_1 --> TitleDataCard1_1 --> DataCardValue1_1

Was this reply helpful? Yes No