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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,870)