On my post from October 30th named " Can I get Cell Data sent in emails? you fixed my problem with sending data in an email and it works great. That Automation in located on the form itself and uses data directly from the submission works as expected. The problem is there is a second automation that happens when the first approver clicks approve and then it goes on to a second approver. That automation then pulls data from the tables themselves and so it breaks things.
Here is the email I am trying to create
Test user has sent you a new purchase request.
Here are the details:
Subject: test of 499
Amount: $499.00
Full Description: This is a test of 499 to figure out what works and what does not.
Department: IT
Summary of budget for this item:
Attributed to which budget: Laptop upgrades
How much money has been used in the budget item: #N/A
How much money is left in that budget item: #N/A
Percentage used for this budget item: #N/A
So 3/4 of it works. It's just the last 3 lines that does not.
The "Attributed to which budget:" points to =[Budget Item] in the A_Purchase_History table and seems to work properly.
The "How much money has been used in the budget item:" should get the data from B_Budget[Budget Used] that corresponds with the line item [Budget Item] that was selected in the form.
Lines 3 and 4 are similar to 2 in that they are grabbing data from B_Budget[Amount Left] and B_Budget[Percentage used]
I assume you have to use FINDROW, but trying to figure out formulas has been very difficult for me.
This was my best guess out of many many tries.
=Findrow(B_Budget,"B_Budget[Budget Used]=%", "[Budget Item][Item Name]")
But I may have it totally messed up and not even close.
Any help you can give me would be very appreciated.