cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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
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
News & Announcements

Community Blog

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

Power Apps Community Call

Power Apps Community Call- January

Check out the Power Apps Community Call for January 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (9,443)