Adding another row in Data Table

[freshyshreya]

Hi,

In the pic below:

I want to add an option so that when I select any of the row in Data Table(2) and click on Add Project(1),I should be able to open a new form(shown in the pic below) where opportunity ID remains the same but Project ID get incremented by 1 and at the same time a new row also gets created in the Data Table(2).

Please Help!

[PriyankaGeethik]

Hi @freshyshreya ,

If the gallery items is having  a collection you can use below formula on click of Add. 

I am assuming the Project ID should be incremented by 1 from the maximum value of the Project present for the selected Opportunity. You will have to update the below code as per your datasource and column names.

Collect(galleryCollectionname,{ColumnNameOfOpportunity: dropdownName.Selected.OpportunityID,ColumnNameOfProjectID: Max(Filter(galleryCollectionname,ColumnNameOfOpportunity=dropdownName.Selected.OpportunityID) + 1})

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[freshyshreya]

Hi @PriyankaGeethik ,

Just for clarification,I am using Data Table,so can I use the same formula?

[PriyankaGeethik]

Hi @freshyshreya 

What is the source of this datatable collection of direct datasource ? 

[freshyshreya]

Hi @PriyankaGeethik ,

For the whole form and Data Table also I am using only one SharePoint List(marked in the pic below) as the Data Source.

[PriyankaGeethik]

Hi @freshyshreya ,

If you can try below code. Let me know if there is any issue.

[freshyshreya]

Hi @PriyankaGeethik ,

According to the formula,what I understand is that project ID will be +1 of the opportunity Id that is selected.

If that is true,then let me try to make you understand what I need:

In the pic below:

Upon the click of Add Project(marked),I am directed to a new form which the user should fill(as shown in the pic below),but what I want is in the form same Opportunity ID should appear as the one which has been selected in the data table(shown in the above pic) but Project ID should be auto generated for that particular Opportunity ID.

That means its like Parent-Child Relationship between Opportunity ID and Project ID.One Opportunity ID can have several Project ID.

[PriyankaGeethik]

Hi @freshyshreya 

So project ID is autogenerated ?

If Project ID is autogenerated than please Patch the record instead of collecting. That way for the selected Opportunity ID you will get autogenerated project ID.

[freshyshreya]

Hi @PriyankaGeethik ,

I tried implementing the below formula for my use case

Collect(galleryCollectionname,{ColumnNameOfOpportunity: dropdownName.Selected.OpportunityID,ColumnNameOfProjectID: Max(Filter(galleryCollectionname,ColumnNameOfOpportunity=dropdownName.Selected.OpportunityID) + 1})

 Its showing the following error:

Please Note-

Datatable2-its the name of the Data Table

Opportunity ID2_Column4 - Name of the Opportunity ID column in Data Table

Opportunity ID2 - Name of the Opportunity ID in the SharePoint List

[PriyankaGeethik · Accepted solution]

Hi @freshyshreya ,

Would you pass column required in Filter using .

Something like below ?

Filter(galleryCollectionname,ColumnNameOfOpportunity=dropdownName.Selected.OpportunityID).ColumnNameOfOpportunity