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 🙂
Solved! Go to Solution.
@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.
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
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!)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
167 | |
94 | |
64 | |
63 | |
60 |
User | Count |
---|---|
238 | |
162 | |
95 | |
85 | |
81 |