Solved: When a New Sharepoint List Item is Created, Create a New List Item in a SharePoint Site Events List

When a New Sharepoint List Item is Created, Create a New List Item in a SharePoint Site Events List - Convert Time

I have one SharePoint List in which items are added from all over the company. The list contains fields called StartTime and EndTime. They are SharePoint Date and Time Columns. I also have a field called Time Zone which helps the conversions work correctly in the first list with the explanation - "choose the time zone in which you'd like the event to occur" since you can add items for others and indicate their time zone.

When a new item is created in that list, I'd like to have Power Automate create a new item in an Events List on specific SharePoint sites and have it show the time for each individual according to their own time zone. I can get everything working except for the time conversion. No matter what I do, the time conversion does not come out correct.

For instance, I am on the East Coast with my computer set to Eastern Standard Time though I think the company default is Pacific time. If I add the item in at 8:00 am on my first list, when it gets to the second list it gives me a time of 5:00 am (if there is no conversion) or 1:00 am no matter what conversion I use. I should see 8:00 am on my computer and someone on the Pacific coast should see 5:00 am.

For my Base time, I'm using StartDateTime and EndDateTime.

My sourceTimeZone would always change since anyone in the world could add an item. But, I don't have a field that I can add as a dynamic value in my PowerApp unless someone here knows how I can get that.

In my destinationTimeZone, I add the Time Zone field as the variable.

Is there anyone that has gotten, or can get, this to work correctly or is there any guidance as to what I'm doing wrong.

I've included some images that may help.

Thanks so much!

No conversion at all.Pacific to Eastern Used field entitled TIMEZONE in all places.jpg