Errata

Confusing and non functional example in Exercise 4-6
Exercise 4-6. Using the Dynamic content Expression tab

Stork, Paul Papanek. Learning Microsoft Power Automate (p. 181). O'Reilly Media. Kindle Edition.

Click “+ New step” to add a “List rows” action from the Dataverse connector. Select the Accounts table in the Table name field. Click on the “Show advanced options” link to expand the advanced options. Type “accountid eq” in the “Filter rows” field. Select the Expression tab of the Dynamic content dialog. Type coa⁠lesce( in the fx text box. Place your cursor inside the parentheses and switch to the “Dynamic content” tab. Select the Company Name Value dynamic content. Add the following after the dynamic content you just added: ,guid(). This will supply a random GUID if the Company Name field is null. The text box should now contain this : coalesce(triggerOutputs()?['body/_parentcustomerid_value'],guid())

4. Click “+ New step” to add a “Send an email (v2)” action. Type your email address in the To field. Type “A new Contact was added” in the Subject field. Type “A new Contact was added at” followed by a space in the Body field. The Dynamic content dialog will be displayed.
• Select the Expression tab in the dialog (see Figure 4-43).
• Begin typing “format” in the fx text box. Select the formatDateTime function from the list and add parentheses after it if necessary (see Figure 4-44).
• Place your cursor inside the parentheses and switch back to the Dynamic content tab. Select Description from the dynamic content in the trigger group. In the resulting expression, change body/description to body/createdon. Add a comma and 't' just before the closing parentheses. The text box should now contain this: formatDateTime(triggerOutputs()?['body/createdon'],'t')

Nope, ther eis no Body/description, and the text box shows differently.


7) Type for after the FormatDateTime() function in the Body of the email.
a. Type first() into the fx text box in the Expressions tab.
b. Select the “Dynamic content” tab and insert the value Dynamic content from the List rows section.
This will get the first row of the output from the “List rows” action we added previously. What we really want is the Name field from that first row. But that isn’t available. Move to the end of the first() function and type ?['Name'] after the close of the function. The text box should now contain the following: first(outputs('List_rows')?['body/value'])?['Name']
Nope, this is what is there


9 Select Tables from the Data drop-down on the left side of the screen. Open the Contact table and select Edit from the Edit drop-down menu. Click “+New row” from the “+New row” drop-down to add a new Contact to the table (see Figure 4-48). Type the following values into the form: First Name: John Last Name: Doe Account Name: Acme Manufacturing Click Save & Close. Click Done.

There is no “Account Name” in the list.
Email never arrives,