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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,357)