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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
184 | |
47 | |
46 | |
34 | |
33 |
User | Count |
---|---|
256 | |
86 | |
79 | |
68 | |
67 |