Hello, I have multiple approval workflows, they are based on o365 send approval email.
As of this/last week (not sure when) o365 send approval email doesnt allow for dynamic content (lookup fields) to be entered into the to field.
To be exact, I have two SHP lists, list A has a Lookup collumn int list B and when this collumn is used it populates 6more collumns in list A based on a selected value from list B.
See screenshot - Settings for the lookup collumn in list A
These additional fields in list B are text based (email adresses) or number based (integers), note that these are not Person collumns!
So based on the Title collumn in list A that is user selectable I populate collumns in list B.
MS Flow WF is running on the list B, trigger is when SHP item is modified.
So o365 send approval email cannot use dynamic content (it just does not show in the sidelist) from these SHP collumns, THEY USED TO BE THERE, and it worked 😞
tried workarounds:
using SHP person collumn into modern approval - internal server error at the start approval action
compose action into a get user info action - bad request error at the get user info
compose action into a o365 send approval email - InternalServerError
Please Help