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

[kuglarz96]

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

[Anonymous]

Hi @kuglarz96 

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

Thanks.

[kuglarz96]

@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]

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.

[kuglarz96]

@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]

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]

My bad @kuglarz96 

on SharepointForm1 > Item property, is the below condition given

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

Thanks.

[kuglarz96]

@Anonymous 

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

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

[kuglarz96 · Accepted solution]

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

[v-xida-msft]

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,