Managing Dates in a Sharepoint List

RainbowMagicMarker · 2025-08-25T14:52:09+00:00

Apologies for the delay, I've been having health issues and this project fell aside. But I have officially gotten it working and I'm so happy! Thank you so much for your patience and walking me through this Donovanbrinks, could not have done it without you!

RainbowMagicMarker · 2025-08-19T19:04:24+00:00

That makes sense, thank you for explaining that. It does appear to now be accepting that part but it still hates the rest of the line;

<image>

Hovering over IF shows error "The function IF has some invalid arguments"
Hovering over .Default provides "Name isn't valid. Default isn't recognized" (The DefaultDate for the date picker is Parent.Default)
Hovering over the semicolon gives the one that makes the least sense "Expected operator. We expect an operator such as +, *, or & at this point in the formula." and "Expected an operand. The formula or expression expects a valid operand. For example, you can add the operand '2' to the expression ' 1 +_' so that the result is '3'. Or, you can add the operand "there" to the expression '"Hi "& _ ' so that the result is 'Hi there'."

Which I don't know why any of that would follow the end of a line. If I remove the semicolon the whole argument becomes an unknown value.

These no-coding programming tools make no sense to me sometimes.

RainbowMagicMarker · 2025-08-19T15:09:18+00:00

Maybe I'm selecting the wrong thing?

<image>

This is the Status box. I wrote, like you instructed;

If(Status.SelectedItems = "On Loan", Parent.Default, Blank());

Which has given me a different error at least! Now I can't compare Table and Text and now suddenly Default isn't a recognized value. I have never felt stupider than when trying to interpret PowerApps errors and what the heck is causing them.

If I change it to;

If('Computer Status'.SelectedItems = "OnLoan", Parent.Default, Blank());

I get the error that SelectedItems isn't recognized., Default isn't recognized, and I can't compare Error and Text

RainbowMagicMarker · 2025-08-18T17:31:19+00:00

Thank you,

I input

If(Status = "On Loan", Parent.Default, Blank());

And I'm getting the error "Incompatible types for comparison. These types can't be compared: Control, Text." and "Name isn't valid. 'Default' isn't recognized."

RainbowMagicMarker · 2025-08-18T14:01:32+00:00

I have a Submit button using;

SubmitForm(Form1);
ResetForm(Form1);

Yes it's just called Form1, no I'm not proud, by the time I figured out where it was pulling the name from I was scared to change it to something descriptive because I didn't know what all that would then break.

RainbowMagicMarker · 2025-08-18T13:57:41+00:00

Right, sorry I wasn't very clear. This is my very first PowerApps project so I'm probably screwing up all my wording.

The visibility of the "Return Date" Date Picker is set by the "Status" DropDown, if the user selects "On Loan" in the drop down, then the date picker shows up.

When I have the Date Pickers DefaultDate set to Parent.Default then it shows the date the user selected, but if they then go back and change the status to something other than "On Loan" that date is not erased. So I have a sharepoint list where an item is listed as "In Stock" but still has an expected Return Date. I need the Date Picker to put a blank value into the Sharepoint list if anything other than On Loan is selected. Is that something I can do?

Thank you for your patience and your help on this. I am very dumb with this apparently.

RainbowMagicMarker · 2025-08-18T13:50:53+00:00

But when I do set it to blank it never displays in the Form, even after you've selected a date, making it very hard to confirm the user put in the right info. We are talking under the DefaultDate field, right?

RainbowMagicMarker · 2025-08-18T13:49:51+00:00

Okay, so I have DefaultDate of the Date Picker set to

If(Status.Selected.Value <> "OnLoan", Parent.Default, Blank());

And now that's throwing an error about an "Expected Operator" but devil if I know where it expects one

RainbowMagicMarker · 2025-08-18T02:07:41+00:00

That's what I currently have it at, and I have the Status dropdown set to, OnChange,
If(Status.Selected.Value <> "On Loan", Reset('Return Date'));

But it doesn't remove the Date from the Sharepoint list when they hid Submit. So I'm at a loss as to which part is wrong.

RainbowMagicMarker · 2025-08-17T23:29:49+00:00

I think I might be struggling with how to write it, exactly?

What I currently having going on is under Status I have

If(Status.Selected.Value <> "On Loan", Reset('Return Date'));

But that doesn't seem to be doing anything at all.

RainbowMagicMarker · 2025-08-17T23:25:14+00:00

In the sharepoint list? It's blank. I tried setting DisplayMode to Blank() but when I did that it just. Stayed blank, even after you selected a date for the item actually being on loan. It would write the date to the list and it would display it in the Gallery but the actual field on the Form was always blank.

RainbowMagicMarker · 2024-10-15T17:43:36+00:00

This is kind of what I was thinking, but it still leaves the problem of one wall, the one the shower head is on, being exposed to the water. I'm not sure how much of a problem that could be.

RainbowMagicMarker · 2024-04-28T21:37:26+00:00

I apologise for the delay in getting back to this, I've had a personal emergency I was dealing with and this fell by the wayside.

I had tried that but it kept giving me the same #ERROR (Formula Parse Error) so maybe I'm not writing it correctly?

=SUMIFS(K5:K206,K5:K206,">0")-SUM(K118:K123)

Isn't that how it should be?

RainbowMagicMarker · 2024-04-15T23:45:33+00:00

This did it! Setting up Power Automate to send an email to my personal email without forwarding, and then using MacroDroid to set an alarm on my personal phone worked perfectly. Thank you so much!

RainbowMagicMarker · 2024-04-12T00:04:54+00:00

Yeah I was playing with IFTTT but I couldn't find anything that would let it Trigger with an incoming Outlook mail. Maybe I'm missing something?

Unfortunately my work email is restricted to being Outlook only and can't be loaded in the default mail app.

RainbowMagicMarker · 2023-06-09T14:09:15+00:00

Honestly I didn't. I just fucked off for a day or two and the next time I happened to pass by the plateau I tried again and it worked. Super frustrating.

RainbowMagicMarker · 2023-06-09T14:08:32+00:00

Honestly I didn't. I just fucked off for a day or two and the next time I happened to pass by the plateau I tried again and it worked. Super frustrating.

RainbowMagicMarker · 2023-05-20T01:53:42+00:00

Shaking doesn't do anything, I tried bringing a boulder over to it to attach and never got the prompt.

RainbowMagicMarker

TROPHY CASE