Raimundo3D

Thank you for the suggestion @Lisbon!
I will do that.

Obrigado pela ajuda Lisbon.
Here's an use case:
1. create a new .afphoto file
2. add a layer and set it to Linear Burn
3. export it as PSD
4. open the PSD in AP or Photopea (same result)
5. check if the blending mode changed to Normal or if it's still Linear Burn
If I try this, the layer blending mode has changed to Normal. This also happens with any of those blending modes in my original post.
I'm not sure if this is a bug only happening on my machine or if it happens to every one. So if you can try these 5 steps and report back I would appreciate it.

You're able to download previous versions of Affinity from here - https://store.serif.com/update/windows/photo/1/
However I have checked this issue going back to version 1.8.5 (released in August 2020) and the same bug is present, so I don't believe reverting to an old version will change this behaviour for you currently, my apologies.
EDIT -  I've been informed by our team internally that Linear Burn should be retained when exporting, however the other blend modes you've listed here aren't supported by Photoshop and therefore are converted when exporting.
At this time, the bug report with our developers is to fix Linear Burn not being retained when exporting to PSD. I hope this clears things up

Great news everyone! (JK😄)
So, it's probably an exporter bug..
hmmm.. I will report it and see what Affinity guys thinks about it.
Thank you RC-R!

Hey NMF!!
That's what I was doing wrong!
Thank you for the tip.
So, to conclude:
Color layer on top, set blend mode to Multiply.

Rasterize SALE layer

Select the color layer and clip it to the text (Arrange -> Move Inside)

DONE!!!!!

✨🎇🎆✨🎊🎉🎉🎉🥳