03-06-2018 12:14 PM
Here you can learn about some of the more advanced things you can do with collections. Including email. Fun stuff.
Content includes:
Video on getting started with PowerApps collections
Video on getting started with PowerApps emails
Link to ascii codes:
For information or PowerApps consulting check out Bold Zebras
watch?v=DF4KX1oSrVI
How would you go about adding that total count into the email?
What have you tried? You should be able to just add the Count function to the body of your email.
Should have specified sorry.
I have the formula for my cart and the email is functioning.
Where would I place the sum statement so that it is placed at the botttom of the email.
Hi, great info. I was wondering if it was possible to take it a little further? Based on your example I have the following in the email body based on each line of the collection
Contract :C3618 - KIRKCALDY Unit : 1 No Unit A Volume : 0.5m³ Contract :C3618 - KIRKCALDY Unit : 1 No Unit B Volume : 0.67m³ Contract :C3615 - THANCKES CULVERT Unit : 1 No Culvert 1A Volume : 2.658m³ Contract :C3600 - DUNBAR SLABS Unit : 4 No Slab Volume : 0.79m³
Is it possible I could summarise it more and turn it into something like.....
C3618 - KIRKCALDY 1 No Unit A, 0.5m³ 1 No Unit B, 0.67m³ C3615 - THANCKES CULVERT 1 No Culvert 1A, 2.658m³ C3600 - DUNBAR SLABS 4 No Slab, 0.79m³
i.e. bold headers for the contract name, and then summarised per contract rather than individual lines for each?