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
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.
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
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.
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.
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.
When an item is created or modified and the publish field value equals "Publish" then get the item and send field values to Drupal and create a job posting for the public to view.
First we need to build the API so PowerAutomate can talk to Drupal.
I am developing this for a School Distrct HR Power Platform. This piece is for the Job Board where HR can get a staffing request from a supervisor. From there they can create a job posting from with in the Power Platform. That posting will go public on a Drupal 9 site.
I choose to use Drupal instead of Power Portal cause it's cheaper.