![]() We are excited to announce the Summer of Solutions Challenge! Who will be our Week 2 Top Entries? Check out more information on the Summer of Solutions Challenge in the News & Announcements: Power Apps, Power Automate, Power Virtual Agents, Power Pages.Ĭommunity MembersSuper Tip: If you see an (open) spot these are great communities to participate in to earn entries for the challenge. Each of the following users will receive an entry for each Authored Solution that they provided within 24 hours of a forum question during Week 1 August 8-14. The Summer Challenge is off to a great start!Ĭheck out the Top 5 Members and Top 5 Super Users in each of the communities. It has been an exciting week in the Power Users Communities. Note all apps and sites are set for the same region for formatting (New Zealand).Īny insight or help is greatly appreciated!! Really confused how to get consistency with the formatting here, i'd really like to not have it as a string as being filterable as a date value is required. However, once I check on the excel document generated, the time format has changed? And not only that but it changes the data, so when I format it as required (dd/MM/yyyy hh:mm tt) it swaps the day and month?Įxcel online (opening directly from Sharepoint online) Later in the flow, I then add the data above to the table in my excel document, here you can see it's passed the formatted date/time "11/02/22 9:01 AM" and reports the same as the output. Using the convertFromUTC() function and formatting (to dd/MM/yyyy hh:mm tt", it's output as "11/02/22 9:01 AM". ![]() ![]() ![]() As you can see it pulls "PolicyBoundDate" value from the Sharepoint list as UTC ISO date/time - in this case "". Select maps the data from a "Get Items" action. I've got the data flowing nicely, but for some reason the dates act funky when exporting. Currently trying to build an excel doc that takes Sharepoint list data and puts relevant data into a table in an excel file. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |