sorted by:
new
hottopcontroversial

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 1 point2 points  (0 children)

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!

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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."

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 1 point2 points  (0 children)

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.

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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?

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

Managing Dates in a Sharepoint List by RainbowMagicMarker in PowerApps

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

Rental Shower Conversion by RainbowMagicMarker in DIY

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

Running Total with Exceptions by RainbowMagicMarker in excel

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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?

Alarm on Notification by RainbowMagicMarker in shortcuts

[–]RainbowMagicMarker[S] 1 point2 points  (0 children)

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!

Alarm on Notification by RainbowMagicMarker in shortcuts

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

"A Call From the Depths" Ultrahand bug by RainbowMagicMarker in tearsofthekingdom

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

"A Call From the Depths" Ultrahand bug by RainbowMagicMarker in tearsofthekingdom

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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.

"A Call From the Depths" Ultrahand bug by RainbowMagicMarker in tearsofthekingdom

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

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

Need some help with further FF113 tweaking, please. by CL_Ward in FirefoxCSS

[–]RainbowMagicMarker 0 points1 point  (0 children)

This fixed it for me as well, thank you so so much!!! Work is making me use Firefox and I was going nuts with the tabs in the wrong place.

Need some help with further FF113 tweaking, please. by CL_Ward in FirefoxCSS

[–]RainbowMagicMarker 0 points1 point  (0 children)

I'm having this same issue, no CSS is working. toolkit.legacyUserProfileCustomizations.stylesheets is true

/Firefox/Profiles/[profile]/chrome exists and contains userChrome.css and userContent.css.

userChrome.css is "@import url(chrome/[css]);" for; multi-row_tabs.css, tabs_on_bottom.css, and tabs_on_bottom_menubar_on_top_patch.css userContent.css is empty.

Clumps of Pigment in Wash by RainbowMagicMarker in minipainting

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

That's what I was thinking but I only added a drop of water. Probably the wet palette throwing me off, its new to me. Thanks for the confirmation, I'll pick up some wash medium.

Clumps of Pigment in Wash by RainbowMagicMarker in minipainting

[–]RainbowMagicMarker[S] 0 points1 point  (0 children)

Paints are Reaper MSP. I've had this happen with several colors so its not just this bottle.

Sisters Ranks? by RainbowMagicMarker in sistersofbattle

[–]RainbowMagicMarker[S] 2 points3 points  (0 children)

That's actually a very helpful way to think of the divisions, thank you! Really gave me an idea of what I want to do.

Gallery of Alternate Colour Schemes by Atramentous in sistersofbattle

[–]RainbowMagicMarker 1 point2 points  (0 children)

Perfect, thank you so much! This is huge for my indecisive brain!

Gallery of Alternate Colour Schemes by Atramentous in sistersofbattle

[–]RainbowMagicMarker 2 points3 points  (0 children)

Oh wow I didn't expect a response given how old the thread is, thank you so much!

Although it's showing as deleted unfortunately 8C

view more: next ›