cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Number format issue

Hi All,

 

@mdevaney  has helped me a lot with pre-populating a Sharepoint List with times (30 minutes periods fro a full 24hrs) for an app I'm building.

I set up a test app in tablet format to learn how it does it stuff.

The list is populated with 700,730,800,830 etc

The Gallery on the left shows the time slots in a format more pleasing to the eye using Text(ThisItem.Time,"[$-en-US]00:00")

However, when I display the Gallery item in the form on the right, it displays the time as 730 (as the list) rather than 07:30 and I can't seem to get it to repeat the same format. I shall keep plugging away but any suggestions would be greatfully received 🙂

Capture.PNG

13 REPLIES 13

@Anonymous 

Thank you for sending the link Kevin.  I have no idea why that message appears.  I get it too sometimes.  I think its a bug.

@Anonymous 

Yeah... answering specific questions on the forum is very very different from creating a design spec.  I often have to make several assumptions about unknowns and decide whether to answer the exactly the question before or instead answer what I think someone would need.  This 2nd option doesn't always meet with success because of the previously mentioned unknowns.

Anonymous
Not applicable

ry to keep pestering you @mdevaney ,

 

But if I did want to adapt the original formula to populate the column with text, is in "07:00","07:30" etc. How would the second part change?

In my test app It's currently:

ForAll(timeOptions,Patch('Observation Logs',Defaults('Observation Logs'),
{Time: timeOptions[@Value], Title: "Observation Log", Date: Today(), SupportedPerson: "John Smith"
}))

 

But it doesn't work if I change the SP column Time to single line text and simply try to change Time: timeOptions[@text] or Time: timeOption[Text]

 

Kev

Anonymous
Not applicable

@mdevaney 

Ignore that last message. It wasn't working because I had copied the button with the formula to test it out but was using the same variable timeOptions and that was why it didn't like it. As soon as I tried it with a different variable name it worked (Doh!)

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,167)