For my private project (Key Box), I’ve built a FetchXML statement to group data already during the query, instead of building a logic in Power Automate. For that, I had to set an alias in the query.
When I tried to access the “myOwner” alias, I did not find it in the Dynamics Content list of Power Automate. It only provided me the default Owner choices.
Hoping that this is only a question of visualization, I tried to insert the “Owner (Value)” and got nothing. Therefore, I looked into the result of the Fetch query and found “myOwner”.
tl;dr; How to access now FetchXML aliases in Power Automate?
- Select the original owner (or whatever you have) from the dynamic content list
- Place the cursor inside your action and copy the inserted formula
- Delete the inserted formula
- Paste the copied formula inside the expression area of the dynamics content
- Replace ‘@{‘ at the start and ‘}’ at the end
- Replace the original attribute name with your alias and press “OK”
