Power Automate Time only string for Microsoft Template or sharepoint list or email body. :)

My job loves to keep me on my toes.

They required to see the time in a different area than the date on a reservation form.  They did not want them in the same line... Sigh

The Flow:

When an event is cancelled in PowerApps/ Dataverse, delete the event from SharePoint Calendar list with Power Automate

Here's is my flow

When a user modifies their trip record and the "Would you like to cancel" field/choice column is equal to "Yes" (really field value: 115650000) then delete that record from SharePoint Calendar and the dataverse. This flow also send a email notification to the user and the person in charge of trip reservations.

 

Display User's Full Name from Created By field Dataverse column to use in PowerAutomate

Add a "Get Row ID" action to your flow and with the table name "Users" in "Row ID" add the created by field from your trigger step, "When a row is added, modified or deleted". See below

 

 

Get the Label property of Dataverse choice Column for PowerAutomate- PowerPlatform

I am using the "label" of a choice value column for PowerAutomate to create an item to a sharepoint list. I want the column to display the "Label" of the field and not the boolean number.

Expression based on your action step

outputs('TransRequests')['body']['crd1d_trippurpose@OData.Community.Display.V1.FormattedValue']

Breaking down the expression

Change visible property based on datacardvalue via Dataverse colunm value selected- PowerApps

 

In the DataCard's "Visible" Property.

Based on Dataverse Choice Column:

If(DataCardValue.Selected.Value in "Your Colulm Value",true,false)

IE: If(DataCardValue34.Selected.Value in "New location",true,false)

When your newly created Dataverse column does not show up in your "Add Record" form

This drives me crazy because I can never remember why this happens and I have to search for the answer. Make sure to Save then Publish! The new column will not show up on the form unless you publish the form.

 

Style daily Power Automate email in a HTML Table

To add on to one of my previous posts, here is how you style your daily email in a nice HTML table.

1. set up the trigger are "Recurrence"

Power Automate- Twitter sign in/ connection issues - the account being added is already logged in

Just a problem I ran into and the solution that fixed it.

I am creating a Social Media Hub so our admistrators can create the content for social media posts and post them to our various social media platform accounts in one place. (Instead of needing to go to each social media site and post them individually)

So my problem was, I created a test twitter account to use for testing purposes through my gmail account.

Pages

Subscribe to Melinda Cozza - Power Platform and CMS Developer RSS