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
Super User
Super User

@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

 

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,129)