Activity
Mon
Wed
Fri
Sun
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
What is this?
Less
More

Memberships

DamoBird365 - Agents & Flows

213 members • Free

Learn Power Apps

2.5k members • Free

3 contributions to Learn Power Apps
Real Time Notifications
I'm building a canvas app that is my group is using to transition away from Microsoft Access. One feature the users really liked from Access was a 'real time' pop up that gave them relevant information. Usually this is centered around an event with a Datetime for either start or end. I believe in Access this was accomplished by running a check every 3 minutes for events (which are now stored in a few different SharePoint list, nothing premium here) which have a Start Time or End Time in the next 3 minutes. I'm trying to accomplish the same thing in Power Apps. I'm thinking of running a timer, but once the user navigates away from the screen the timer is running on, will the time continue to count down? Will the code execute when the timer runs out? I'm also thinking through if 3 minutes is the right amount of time. The timer will start when the user launches the app, and execute every 3 minutes, which means whatever code goes in there will check multiple SharePoint lists 20 times per hour.
1 like • 15h
Thanks for your reply! Interesting point about datetimes not being delagable. The rinse and repeat for each screen is really what I'm trying to avoid. Seems like a lot of juggling to keep track of. My app already has over 10 screens. I'll give it a shot in a test app and see how it functions.
Daily Checklist / Calculated Column
Hey all, Working on building a daily checklist for co-workers on Power Apps. A quick rundown of the SharePoint List setup: List name: Master_Checklist Task (Title Field) StartTime (Date and Time) HoursAvailable (whole Number) EndTime (Calculated Column, =StartTime+(HoursAvailable/24) (this seems to be working as intended) I'm working on making a 'refresh' button which finds all the tasks where the EndTime has past (EndTime<=Now()) and updating their StartTime so that the tasks become available again, with StartTime at the beginning of the shift. First, I've never used a calculated column before, I usually just use a Date and Time field, and set the dates manually. Using this field type in my filter, I have to run EndTime through DateTime(Year(EndTime), Month(EndTime) ect...) which gives me a delegation warning (not worried as it is in a local collection and the task list is less than 100 items) Second, after I build my collection 'TasksToUpdate' I'm using ForAll to lookup each record in the collection and Patch to update the StartDate. I think Filter logic is sound, but I keep getting an error: 'Status: 400, fetching items failed, possible invalid string in filter query' I don't have any errors in my code and App Checker has no errors on this screen. The only kind of sketchy part of my code is: ForAll(TasksToRefresh, Patch(Master_Checklist, LookUp(Master_Checklist, ID=ThisRecord.ID), If(Hour(ThisRecord.EndTime)>Hour(Now()), {StartTime: DateTime(Year(Today)), Month(Today()), Day(Today()), Hour(ThisRecord.StartTime), Minute(ThisRecord.StartTime), 00}) I'm fairly confident in the rest of the code, but I'm not the 'If(Hour(ThisRecord.EndTime)...' portion is working correctly because of some weirdness from calculated columns. Any help is appreciated!
2 likes • Aug '24
Trying a different approach. Moved away from calculated columns, they don't seem to play nice with Power Apps, and just using another TimeandDate field, with which I'm more comfortable. I'm using a ForAll loop to iterate over my collection collTasksToUpdate. Basically I'm iterating over the collection three times, once to patch the StartTimes based on frequency being "Daily" or "Weekly" and once to patch the EndTimes based on DateAdd using HoursAvailable.
Something went wrong...
UPDATE: I attempted to roll my app back to a previous version, but I got an error saying "app is locked by (my account name)". I believe this has something to do with the fact I had to have a new account created the same day this problem started up. I believe I need one of my system admins go into the Power Platform Admin Center and force my old editing session out/offline? Still searching for answers... I have an app that I have been developing, but lately, whenever I launch the app for editing, I keep getting the 'Something went wrong' error message. I can click 'see more info', but it just gives me a session ID. Origionally I thought it was an issue with my App. I rolled back to a previous version, and that seemed to fix things that day but doing the same today has not fixed the problem. Also I fixed the suspect issue in the app, saved, and published that version. I have looked around for a solution and have tried the following: Clearing cookies: I work in a corporate environment so I can't nuke all my cookies, but I have Edge set up to clear cookies from the make.powerapps base URL. I'm not 100% sure this is working, but seems likely this is the issue Try a different browser: Edge and Chrome have the same results. Can't use Edge in Explorer mode... Looking for open editing sessions: It seems like the problem is that I have an 'open' editing session already. I usually get the 'you have this app open in another location/open read only/overwrite' message when I get into my app. Others use this app, but I am the only person working on developing it, and always from my same workstation, so this should not be the case. After restarting my computer and trying to edit again, I am getting a different Session ID that I had previously. Looking in Power Platform admin center, I can see a test environment I made, but this is not where my App is. I cannot see the environment where it lives, and I think my permissions in that environment are something like 'maker with data permissions' or something (I don't usually poke around in the admin center)
0 likes • Jul '24
Found a screenshot on PowerPlatform Help Form. This is the same error message I see. Based on the form post, this was supposed to be fixed on March 22, 2021 "Error Opening file, Something went wrong while opening your app" (powerplatform.com) I am unable/unaware how to run monitor traces while opening the app as the post suggests.
0 likes • Aug '24
Unfortunately, this problem seems to have solved itself. Came in after a long weekend and everything just worked. I still think I had an editing session open somehow, and it finally just expired? Nobody in my organization seems to know how to do anything administratively in Power Platform, they were convinced it was a network error, even though I could edit other apps with no problem. Frustrating. Now I make sure I click the 'Back' button in Power Apps Studio every night.
1-3 of 3
Matt Capp
1
1point to level up
@matt-capp-7075
Pika chuuuuu!

Active 14h ago
Joined Jul 12, 2024
Powered by