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
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
183 | |
71 | |
43 | |
34 |
User | Count |
---|---|
338 | |
269 | |
117 | |
67 | |
66 |