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

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
Highlighted

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
Highlighted
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

Highlighted

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

 

Highlighted

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

Highlighted

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

 

 

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,765)