Face the fear of $expand and get the lookup values you deserve in Power Automate
Power Automate Amey Holden Power Automate Amey Holden

Face the fear of $expand and get the lookup values you deserve in Power Automate

Power Automate and lookup fields are problematic - especially when you are trying to send notifications which include information about records which includes lookup fields.

For example - sending an email about a contact who works at a company called ‘ Vegemite’ comes back as ‘eca9ea6f-c96b-ea11-a811-000d3a58d840‘. I’m not sure about you, but me and most my customers don’t speak '“GUID”.

You can use the ‘Get Records’ action but its not so friendly of the API calls nor so efficient. Come with me on a journey to understand the power of the ‘Expand Query’ to solve all your lookup GUID issues!

Read More