cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
avi2017
Helper I
Helper I

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

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.

 

Question.jpg

 

Regards

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

5 REPLIES 5
v-bofeng-msft
Community Support
Community Support

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

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

 

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

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

 

 

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,616)