cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kuglarz96
Frequent Visitor

Seperatly from form, saved inputdata as collection, in sharepoint form view

Hi,

 

I want to make app which will help lead a project. User first has to answer some questions from form, and then, user has to add expected hours of working on each task in table. Each task should be visible as next row in table.

The point is amount of tasks may vary, so they should be added dynamically by clicking "+" button, and they have to be connected with form responded on beginning.

 

I created collection for it, with textInput, but after submit, when i refresh sharepoint page all data is lost.

Then I created the seperatly form for it with unique identifier of first form, but when I submit responses, it is showing all tasks added in all forms in each form. 

 

Could you tell me any hints or ideas how to solve this problem? I don't need to have added tasks saved as data from form in sharepoint lists columns they have to be only visible for people who want to check each submited form.

 

Thanks in advance, I hope you could help me

1 ACCEPTED SOLUTION

Accepted Solutions

OKAY, I think I found solution:

 

Second form (Form1) had following condition on Item:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
First(Form1ListName),
SharePointIntegration.Selected
)

I understand that is why I was able to make first row correctly, but I overrided every next (I was keeping submitting .selected form becouse form wasn't empty)

 

I changed it to:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
First(Form1ListName),
Last(Form1ListName)
)

And for now everything works as it should.

 

Thank you a lot @Anonymous , I wouldn't find it out without you, I really appreciate your help

View solution in original post

9 REPLIES 9
Anonymous
Not applicable

Hi @kuglarz96 

 

Can you share the code and also let us know if you are using custom form or canvas app.

 

Thanks.

@Anonymous 

 

I'm using custom forms.

My code for "+" button is

Collect(TaskInfo, 
    {Title:  DataCardValue6.Text,
     Days: DataCardValue7.Text,
     Role1: DataCardValue8.Text,
     Role2: DataCardValue9.Text,
     Role3: DataCardValue10.Text,
     ID: uniqueCTR}
);
SubmitForm(Form1);

Where uniqueCTR is automatically generated number with text of each submited form, and Form1 is the second form, where I had idea to store submited rows.

 

My code for gallery on Item:

Filter(Form1ListName, uniqueCTR.Text in CTR)

CTR is a column in second Form1 sharepoint list where uniqueCTR is stored. 

I find out that idk why I cannot add more than 2 rows - first is ok, and then next is always override last one. 

Anonymous
Not applicable

Hi @kuglarz96 

 

What is the form mode when you add a new record. 

 

NewForm(Form1) - to add new record

EditForm(Form1) - to edit existing selected record (from gallery or so)

 

Thanks.

@Anonymous 

Form1 has:

DefaultMode: FormMode.New

OnSucces: FormMode.New

 

I don't uderstand logic behind it:

1) I run my first form, SharePointForm1, and inside it I'm adding rows of Form1 by clicking "+" button

2) I am able to add only 2 rows: first row is okay, then second is always overriding.

3) After submitting SharePointForm1 second row of Form1 in PREVIOUS submitted SharePointForm1 dissapear. 

 

I think my problem is with overriding rows, but I don't know which option and how I should edit to solve it

Anonymous
Not applicable

Hi @kuglarz96 

 

Is this a custom sharepoint form (in powerapps)? If so check the "SharepointIntegration" events if they are set as:

 

OnEdit - EditForm(Form1)

OnNew - NewForm(SharePointForm1); Navigate(FormScreen1)

 

Thanks.

Anonymous
Not applicable

My bad @kuglarz96 

 

on SharepointForm1 > Item property, is the below condition given

 

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First(TestUpload),SharePointIntegration.Selected)

 

Thanks.

@Anonymous 

 

Yes, it had these conditions already, still now working.

Form1 also has the same condition (with diffrent Sharepoint list name in "First()" )

 

 

OKAY, I think I found solution:

 

Second form (Form1) had following condition on Item:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
First(Form1ListName),
SharePointIntegration.Selected
)

I understand that is why I was able to make first row correctly, but I overrided every next (I was keeping submitting .selected form becouse form wasn't empty)

 

I changed it to:

If(
IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),
First(Form1ListName),
Last(Form1ListName)
)

And for now everything works as it should.

 

Thank you a lot @Anonymous , I wouldn't find it out without you, I really appreciate your help

View solution in original post

Hi @kuglarz96 ,

Could you please share a screenshot about your app's configuration?

Could you please share more details about your scenario?

 

If you could provide more details about your scenario, we would provide a proper workaround for you.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (11,938)