You’re offline. This is a read only version of the page.
I am fairly new to SharePoint online and Power Automate and looking for a solution to do the following:
I have two lists
I'm looking at a way for list one to be updated, with the value from amount on List 2 subtracted based on the expense code used.
For example:
If I input one laptop at £200 using expense code EA4 then List one will update to have that amount removed from the budget name & amount and figure populated in total budget available.
Any suggestions or guidance as I've been looking but can't seem to figure it out or find a way.
Hi,
Would it be possible to get some advice as i understand it works when an item is created but doesn't work then moditifying the amount
@ScottShearer Here is the thread i created and had received some advice on however the problem i'm finding is it's affecting all as opposed to only those with an expense code of EA4 etc
Hi Sorry to follow up on this i'm finding that the figures entered against budget code are not adding up
Hi,
For some reason i now have a slight issue.
When i add the following entries to List 2, it's causing a problem
As you can see it's taken £100 off all rows in list 1 not just the row with BN01
Any advice
Thanks that's worked great and is everything i needed, i really appreciate your help and support with this.
Hi @Anonymous
Please try delete Get Items and create the action again, Then save the flow and run again.
Best Regards
Hiya,
That's brilliant, i think it's almost there just one final thing - Budget name needs to be a word i.e Home Budget. I changed the Sub query from BudgetName to Allowance and tried to change the column of budget name to a single line of text but get the following:
Hi @Anonymous
The full flow screenshot as below:
Best Regards
Hey - Thank you for providing the above, are you able to share a screenshot of the full flow so i can make sure mine alligns up
Hi @Anonymous
Do you want to calculate the sum of all EA4 in list2, then subtract the sum from the name in list1 and fill it in Total Budget available when a new item is created?
If yes, please refer to as below:
Expression: sub(items('Apply_to_each_2')?['Budgetname'],variables('amount'))
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
