cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mattw112IG
Impactful Individual
Impactful Individual

Doing Calculations and Patching SharePoint List

I have a SharePoint List

In Power Apps I have a Gallery that was blank and I have added fields to it including "Spread Margin"

I added an Edit Form tied to the selected item in the gallery

In the Edit form I ask three questions:

Bill Rate, Pay Rate, Burden

I have tried multiple ways... but what I want to do is use those three fields to calculate the spreads margin.  Which would then be saved in SP List and the value reflected on the card in the gallery.

 

I have tried doing the calculation on the Spread Margin Field itself

I have tried doing it OnChange/OnSelect of the Billrate/Payrate/Burden fields

Tried using Variables and ClearCollect on the save button...

 

Anyway, the closest I have come is I can get it to reflect in the edit form as changes are made.  But when I try to submit the form and clearcollect the gallery the change is not shown on the card.

 

My question is what is the best way to do calculations from multiple fields and save those so the gallery shows the latest?

 

Thanks,

Terry

1 ACCEPTED SOLUTION

Accepted Solutions
Mattw112IG
Impactful Individual
Impactful Individual

Thanks for this.  Not sure what I did but it is working now?  I made a million changes yesterday trying to get it to work.

I am using this:

ThisItem.'Spread Margin'*100 & "%" in the gallery.

I'm not doing any refresh()?  Will look at that... just submit form and then clearcollect

 

Thanks!

Terry

 

View solution in original post

2 REPLIES 2
Eelman
Community Champion
Community Champion

@Mattw112IG 

Firstly, when you do this " ... closest I have come is I can get it to reflect in the edit form as changes are made. But when I try to submit the form ..." is Spread Margin calc getting added to your SP List?

 

Secondly, is there somewhere in you code, after Form Submit, where you use Refresh(yourSPList)?

 

If the above is all getting done, what is the Items property of the Spread Margin in your Gallery? I assume ThisItem.'Spread Margin', or similar?

 

Lastly, is Spread Margin a field in your main SP List or is it part of a different list?

Mattw112IG
Impactful Individual
Impactful Individual

Thanks for this.  Not sure what I did but it is working now?  I made a million changes yesterday trying to get it to work.

I am using this:

ThisItem.'Spread Margin'*100 & "%" in the gallery.

I'm not doing any refresh()?  Will look at that... just submit form and then clearcollect

 

Thanks!

Terry

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

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