Skip to main content

Posts

Showing posts from September, 2021

D365 Solution Import failed. The dependent component SavedQuery (Id='View Id' does not exists. Failure trying to associated it with SystemForm (Id='Form Id') as a dependency. Missing dependency lookup type = PrimaryKeyLookup.

Another day, another error while importing managed solution to production. The error suggests that the view (saved query) behind the sub grid which is placed on the form (Form Id) is not present in the solution. " The dependent component SavedQuery (Id="View Id") does not exist. Failure trying to associate it with SystemForm (Id="Form Id") as a dependency.  Missing dependency lookup type = PrimaryKeyLookup. " Here is this can be fixed: Open customization xml in notepad (I recommend notepad++ ) and search with "View Id". Identify the form where this sub grid is placed. Open form -> Open sub grid properties. Set view selector to "Show All Views", save and publish the form. Open the same form again and set view selector to Off, save and publish the form. Now you can export and import the solution again. I will work! How it happened? I believe, when we do customization (place sub grid in this case) on the form from power platform and pu...

Get host (environment) url in power automate

We often get a requirement to send notification to a user with the record url. User can click on the link and quickly navigate to the record he has been notified about. This requires a dynamic host url (environment specific url) to be pulled out within power automate action. When we use Get row action, we also get an oData url of the record. We can utilize this field to extract host url out of it.

Power Automate - Add dynamic url with html tag in teams/email notification

Recently, I was looking to add dynamic url having values coming from the output of some of actions from the top of my power automate to be sent out as teams/email notification.  I was building dynamic url directly in the message section of teams post message action, but for some reason it wasn't working. After that point, I figured out that the html tags with dynamic values does not work directly in the message. To make it work, I have initialize and set variable with the dynamic url and used this variable in the message. This is how the notification received in my teams.