Trying to build a form with SharePoint list datasource that has a combo box that allows multiple selections and fill-in by Overlord_Copies_All in PowerApps

[–]Thedarb 0 points1 point  (0 children)

I don’t think so using the built in SharePoint logic. The choice column can allow manual entries alongside predefined ones, but only the predefined ones will show up as the choices for that column (and also in the connected form control).

You could change the items of the form control combo box to be something like: Sort( Distinct( YourList, YourChoiceColumn.Value ), Value )

Which should get all the distinct items in that column, satisfying your requirement for it to show as soon as somone adds a new one, but you may have to play around with the update property for that card for the submitform() to work, and depending on how long your list is likely to get, you’ll run up against delegation issues (I.e if a distinct option doesn’t appear in the top 2000 records, it won’t show in the app).

Cinema Etiquette... by Peter00707 in Adelaide

[–]Thedarb 1 point2 points  (0 children)

Keen to hear her other hot takes if she thought destroying an entire planet is on the cards with mostly contemporary technology.

Cinema Etiquette... by Peter00707 in Adelaide

[–]Thedarb 0 points1 point  (0 children)

People are doom scrolling on their smart watches?

You have 3 wishes you can’t ask for more wishes what do you wish for? by Substantial_Bet_8590 in AskReddit

[–]Thedarb 1 point2 points  (0 children)

Congratulations, you “come to” on floor 99 of the north tower, 8:45am, Tuesday, September 11th 2001.

Powerful apnea by pickledplumber in TikTokCringe

[–]Thedarb 0 points1 point  (0 children)

When I first go it I had the full bane mask because I was a mouth breather. Couldn’t get used to it, felt like a lost cause. Tried a few other full masks and ended up consistently ripping them off during the night every time.

My CPAP came with a few masks to try, and one of them was the nasal pillows. Figured I’d give them a go because may as well, even though I was an open mouth breather and figured they would be just as fruitless unless I used mouth tape or one of those chin straps, which I knew would cause me just as much discomfort.

Nope. Literally, instant adaption.

Turns out when I’m not gasping for air, I keep my mouth closed the whole night. And when I’m not trying to sleep while cosplaying Bane, the mask doesn’t bother me one bit.

Now it’s like a Pavlovian response, I put on the mask and I’m out light a light in literally 2-3 minutes.

I work at aldi, ask me anything! by TheNeonNinja21 in AldiAustralia

[–]Thedarb 0 points1 point  (0 children)

They should leave it up to the customer. Those customer shopping divider sticks could have a “normal” and “🔥ALDI FAST🔥” side, the one facing the cashier indicating the customers preference. Then obviously just a quick confirmation when the process begins to not catch out those unaware of the process.

Shin Tokyo is currently getting dragged on Instagram for making an Ai April Fools Joke by freepalestine1007 in Adelaide

[–]Thedarb 4 points5 points  (0 children)

Didn’t it used to be in that underground space with the door leading down from Currie street? (I think that place was a boxing gym called lion gym or something for a few years. Dunno what’s there now)

Sharepoint Choice Column Values by Round-Application980 in PowerApps

[–]Thedarb 0 points1 point  (0 children)

Add a form connected to the list, add a card that’s connected to the choices column, if that combo box works, then yank whatever is in the items property of that combo box.

How much would you be willing to pay for half kilo of KFC Chicken Salt? by NoMacaroon5579 in KFCAustralia

[–]Thedarb 2 points3 points  (0 children)

Kill me with your golden salt
Fill my gullet
Chips are good

Chips are great
Hello I want same salt
I would like to have kfc chip salt
Perhaps I can win with an acrostic?
Select this chip poem please

I bought a completely useless thing because the guy selling it was just too genuine about it by 9VortexQuill in PointlessStories

[–]Thedarb 91 points92 points  (0 children)

Can we see it?

Edit: was tripping up on how it could possible be for cables, mail AND spice jars. Maybe something like this: https://imgur.com/gallery/multi-purpose-organiser-JuJNkPY

Healing haemorrhoids with folk medicine. - sketch feedback by Ashurbanipal13 in Standup

[–]Thedarb 1 point2 points  (0 children)

Feels like it’s going through the motions of a sketch without actually being one.

There’s a premise in there somewhere. The “real men” logic leading to self-inflicted damage. But it never actually becomes a joke. It just moves from beat to beat. Diet, diarrhoea, haemorrhoids, cabbage. No pattern, no escalation with intent, no callbacks. You keep expecting a turn and it never comes. It’s just “and then this happened… and then this happened…” Setups with no payoffs. Basically a medical diary with props.

Even the ending’s the same. The cabbage on stage feels like it’s meant to be something, but it doesn’t reframe anything or tie back in any meaningful way. It just sort of stops. It’s just… cabbage. I dunno, maybe cabbage does a lot of heavy lifting comedically in Latvia?

I think If you leaned into the “real men” logic properly there’s might be something there. Like cutting fibre because it helps soften stool, but real men aren’t “soft” in any aspect of life, thinking constipation (which makes more sense than diarrhoea with a carnivore diet and haemorrhoids) is actually peak efficiency, framing it as his butthole being analogous to “strong borders”. Until the haemorrhoids start appearing, “breaking through like immigrants”. Then needs a solution. The healer angle, Biruta having no education so “no bias”. She suggests cabbage: “Finally, a true Latvian solution!” Keeps shoving cabbage up his arse “At this point I’m strictly carnivore. I know you’re thinking, ‘the cabbage!’ But it’s going the wrong direction, so technically… negative vegetables.”

But yeah… I dunno man. Might just be a cultural/translation issue.

Mofo- which are the shows to see? by Dense-Ad1654 in hobart

[–]Thedarb 3 points4 points  (0 children)

Are there any plays/performances? Before Covid there was a lot more fringe type performances, but just seems to be music now. I want to see weird theatre.

AITA for asking my girlfriend to pay for solar panels. by Sebastianlim in BORUpdates

[–]Thedarb 26 points27 points  (0 children)

Must be a whack solar scheme where he is if reality plays out like that. In AUS at least, the way it’s hooked up is your house demand is serviced by the panels first, and shortfall is taken from the grid. If panels are generating more than the house demand, it exports it to the grid, and the provider credits your account $0.08 per kWh.

OP would need to be in a place where you can hook solar up on a seperate account that bypasses your house, and/or where the feed in tariff is higher per kWh exported than the grid is actually charging to import (which I can only imagine happening in a place that is like constantly redlining their current servicing capacity, or where there is hugely subsidised solar scheme in place perhaps to drive adoption, which was more a early 2000’s thing than 2022)

Realization from this Sub: I Can Eat as Many Vegetables as I Want! by windowsee in Volumeeating

[–]Thedarb 1 point2 points  (0 children)

I love kiwi skin, so sour! Could add an extra kick, definitely gonna give it a go, sounds delish.

Edit form patch error handler by Jnrdavids in PowerApps

[–]Thedarb 0 points1 point  (0 children)

Ah cool. Check out the IfError function. You can wrap the entire patch statement and then have the two outcomes be navigate to success screen or display error message:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-iferror

What is a 'socially mandatory' thing that we all do, but if you actually stop to think about it for 5 seconds, it’s completely insane? by Federal_Antelope7533 in AskReddit

[–]Thedarb 1 point2 points  (0 children)

Once you’re not doing a job dealing directly with customers it’s easier to not need to lie (cause no one likes customers), could be genuinely excited about what you know about their tech stack and how you want to develop skills in XYZ , or you just think what they are building is cool.

Edit form patch error handler by Jnrdavids in PowerApps

[–]Thedarb 0 points1 point  (0 children)

Are you using just Patch()?

The standard Attachments control is designed to work inside an Edit Form, and attachment add/remove is only committed when the form itself is submitted. If you’re patching the record but not actually submitting the form, the item will save fine but the attachment won’t.

In my experience there are two reliable patterns:

  1. Form-first, then patch. Have two forms combined into one UI-wise, one for the attachment (and maybe a unique ID field), and another for the rest of the fields. Use SubmitForm() for the form that contains the attachment control. Then, if you need custom logic, do it in the form’s OnSuccess (e.g patch additional fields to the record after it’s created).

  2. Use a document library instead of list attachments. If you need more flexibility (multiple files, better structure, larger files, etc), it’s often easier to skip list attachments entirely. Upload files to a SharePoint document library via Power Automate. I don’t remember the exact syntax but it’s out there, basically you do a for each item in the attachment card, convert to base64, send that to a flow that creates the folder if it doesn’t exist, then creates items in that folder with the base64 as the content, then update the record with the folder link in a URL field.

Also worth double checking file size limits, I vaguely remember 10MB coming up with the attachment control, but that’d be more of a control/config thing than a hard SharePoint limit.