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
Solved! Go to 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
Hi @avi2017 :
Could you tell me:
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
User | Count |
---|---|
157 | |
93 | |
80 | |
74 | |
57 |
User | Count |
---|---|
202 | |
166 | |
98 | |
94 | |
79 |