2 Gallery from 2 different sharepoint list on same screen . How to derive a calculated column ?

[avi2017]

Hi Gurus

I have a scenario where on the same screen have 2 Gallery from 2 different SharePoint list. Please see the attached image. 

Question 

1) How to Automatically populate Calculated Interest = (Share Point1 @ Galley 1 . Spacing * Share Point2 @ Galley 2 . Interest )

2) Status column is a drop-down list in Sharepoint 2. How to show the values Yes/No as drop-down in Status column.

Regards

[v-bofeng-msft]

Hi @avi2017 :

Could you tell me:

• Is there only one record in SharePoint List1 or Gallery 1?If not, we must know which record in List1 to use the Spacing value to calculate.
• What is the relationship between SharePoint List1 and SharePoint List2?
• What is the relationship between the status in List2 and the status in List1?

Could you please consider providing more details?So that I can provide a more specific solution.

Best Regards,

Bof

[avi2017]

Hi Thanks for the reply 

Consider Gallery1 is header information and Gallery2 is Item information for Employee , Link is Employee number .

Spacing in Gallery 1 is an editable field which user can change . When user enters or changes value in spacing this formula should be triggered and calculated interest to be re calculated in Gallery2

Calculated Interest = (Share Point1 @ Galley 1 . Spacing * Share Point2 @ Galley 2 . Interest ) 

regards

[v-bofeng-msft]

Hi @avi2017 :

Please try this:

1\Set the Gallery1's items property to:

SPList1

2\Set the Gallery2's items property to:

AddColumns(
  ShowColumns(SPList2,"Employee","Name","Type","Seq No","Interset","Status"),
  "Calculated Interest",
  Gallery1.Selected.Spacing*Interest
)

Best Regards,

Bof

[avi2017]

Hi 

Thanks for the reply 

The provided solution almost worked . Only challenge is it is "not" taking Spacing value entered or changed by user on gallery1 instead it is taking the value of spacing from Sharepoint1

[v-bofeng-msft · Accepted solution]

Hi @avi2017 :

Please try this code:

AddColumns(
  ShowColumns(SPList2,"Employee","Name","Type","Seq No","Interset","Status"),
  "Calculated Interest",
  Value(Gallery1.Selected.TextInputControl.Text)*Interest
)

Best Regards,

Bof