Skip to content

Tag: FetchXML

22.04.2023
Ben
6 Comments

KeyBox – A Dataverse solution to govern credentials

Posted in Power Platform, and Dynamics 365

Most of the time, I create solutions based on customer requirements. Sometimes, I create solutions to learn something new and “KeyBox” was my last personal project to learn some new skills.

KeyBox – The features

It is a solution to store and govern credentials (stand alone or in regard to a customer) in Dataverse. You can store usernames & passwords or client IDs & client secrets. It reminds you when the “valid until” or “remind me on” date is reached. Additionally, a note can be placed at the MFA switch and a URL.

KeyBox Record

Additionally, you can create new passwords, based on the rules of the organization.

KeyBox Config

I’ve learned in my KeyBox project:

Get your KeyBox!

Sounds like I try to sell you something, but I don’t. I put it on GitHub under MIT licence. Means you can use and modify it in any way you want.

KeyBox

22.04.2023
Ben
Leave a Comment

Working with FetchXML aliases in Power Automate

Posted in Power Automation, Dynamics 365, and Power Platform

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.

KeyBox

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.

KeyBox

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”.

FetchXML aliases in Power Automate

tl;dr; How to access now FetchXML aliases in Power Automate?

  1. Select the original owner (or whatever you have) from the dynamic content list
  2. Place the cursor inside your action and copy the inserted formula
  3. Delete the inserted formula
  4. Paste the copied formula inside the expression area of the dynamics content
  5. Replace ‘@{‘ at the start and ‘}’ at the end
  6. Replace the original attribute name with your alias and press “OK”
KeyBox