cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vincebk
Frequent Visitor

Data from Microsoft Forms to Excel - Help with Incorrect Time Zone and Removing Brackets/Quotes from Multiple Choice Selections

Just as stated in the title. I created a form that captures information and submits it into a table in an excel file. The submission time shows 3 hours off and when someone selects 1 option or multiple options, the data is shown in brackets/quotes. I've read through a few posts and been trying the different solutions but still not getting through.  The function that I used for the Time Zone is

 

addHours(convertTimeZone(item()?['Modified'],'UTC','Eastern Standard Time','f'),20,'f')

 

Could someone please help?Forms Error.PNGFlow1.PNGFlow2.png

1 REPLY 1
Vincebk
Frequent Visitor

Bump

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,008)