Time and date issues SharePoint, Sharepoint calendar, Power Apps, and beyond

Issues and solutions for Date and Time fields for Power Apps and Power Automate

1. Time zone issues-

If you find that you have converted your time zones in your flow and they are still not dislaying correct in SharePoint. Make sure the time zone in your SharePoint site is correct. It could be default to the wrong time zone no matter where you live and set it up.
Check your site's time zone at: Site information>View all site settings>Regional settings

Two Parameters for StartScreen Navigation to screens with URLs (No Ors) for custom Links to Power App Screens

Add two params to StartScreen If statement, Or Statement. (Sort of)

If(Param("ScreenName") = "Admin", AdminBuildingTripPending, Param("ScreenName") = "BM", DisclosureScreen, WelcomeScreen)

Formula:

StartScreen messing around with PowerApps Deep Linking to screens

So yes, Microsoft decided to change things up on us to keep us on our toes.

To add links that will direct users to specifics screens, here is the new way to do it.

 

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

Pages

Subscribe to Melinda Cozza - Power Platform and CMS Developer RSS