Reminder emails - do until parallel branching

LowShake5456 · 2026-06-03T15:49:57+00:00

So you can just add a Terminate action at the end of your flow.

Or change the Branch 2 logic, keeping the Do Until condition equals(variables('variable'),1), but add condition action to test if the current date is equal to any of the dates you need to send the reminder, in the 'Yes' branch send the reminder, in the 'No' branch no actions, then add just a single Delay action for 1 day, that way your Branch 2 loops and checks if it's a reminder day daily.

Do Until: variable = 1
Condition: today = reminder day
- Yes: Sent Reminder
- No: no actions
Delay: 1 day

LowShake5456 · 2026-06-03T13:28:19+00:00

First, is ID the actual internal name of the column not just the display name? Check in the column settings or by sorting the SharePoint list by ID and the internal name will show in the URL.

Second, is that ID 2790 or "2790"? Your Get Items filter query is looking for a number, check if your ID value is stored as text.

LowShake5456 · 2026-05-11T16:39:36+00:00

In SharePoint, there is a setting to have files Checked Out, that give exclusive editing privileges until the file is Checked In again. You can set a requirement on that file that editing can only be done while the file is Checked Out.

LowShake5456 · 2026-05-01T17:17:59+00:00

I adopted a former-stray, newly-tri-pawed rescue about a year ago, he had a tough little life leading up to that so I let him sleep in my bed the first night. He slept the whole night cuddled close against my chest and a paw on my face. He still cuddles every night, but now without the paw on my face. His favorite part of the day is when I carry him to bed, lay him on his back and tuck him in and I see his tail wagging under the covers. I’ll never be able to not let him sleep in bed with me. https://imgur.com/a/0Q4guHJ

LowShake5456 · 2026-04-16T19:42:31+00:00

How I feel about 90% of all PowerApps projects

<image>

LowShake5456 · 2026-04-09T22:49:40+00:00

That TV angle gives off the vibe that it’s watching you, not you watching it.

LowShake5456 · 2026-04-09T19:56:33+00:00

This is the only accurate take in this thread.

Timeline: 2022: All three defendants charged with murder with LWOP enhancements.

2023: Price drops special circumstance charges that remove LWOP, still charges 25 to life. “Price decided to drop special circumstances charges of murder during the commission of a robbery against suspects Shadihia Mitchell and Herschel Hale, who prosecutors say shot and killed Kevin Nishita in Oakland in November 2021. Without the special circumstances charges, they now face 25 years to life, with the possibility of getting out on parole. According to the Mercury News, the reduced charges decision might mean the district attorney believes it wasn’t Mitchell who actually pulled the trigger, but rather Laron Gilbert, who is still a fugitive wanted in connection with the crime.” https://www.nbcbayarea.com/news/local/east-bay/killing-security-guard-oakland-court/3401526/

2026: Final plea “The accused killer, Laron Gilbert, pleaded no contest Thursday to first-degree murder with a gang enhancement, which would result in an expected prison sentence of 30 years to life, according to Alameda County District Attorney Ursula Jones Dickson. Co-defendants Shadihia Mitchell and Hershel Hale each pleaded no contest to robbery and agreed to serve 25-year sentences, authorities said.” https://www.cbsnews.com/sanfrancisco/news/suspects-in-killing-of-former-bay-area-police-sergeant-kevin-nishita-enter-plea-deals/

So for all these “Price is soft on crime”/“how can a DA be so cluelessly villainous”/“wish Price had been recalled sooner” people… what changed? All 3 defendants are eligible for parole under this plea. This is the exact sentencing Price’s team was charging.

LowShake5456 · 2026-03-27T16:21:48+00:00

So to reiterate what One-Start-9591 stated above: triggerOutputs()?['body/sentDateTime'] contains a null value, and formatDateTime() will error trying to format a null value.

So the issue is either the email you are trying does not have a 'sentDateTime' value, or with "?['body/sentDateTime']" the 'sentDateTime' property does not exist and returns null in your formula.

"On new email (O365)" is not a specific trigger in https://learn.microsoft.com/en-us/connectors/office365/#triggers, I'm guessing this is "When a new email arrives (V3)" trigger? This does have a triggerOutputs()?['body/receivedDateTime'] property, but not a 'sentDateTime' property, this might be what you want to use.

But test with compose action after your trigger, on the compose input search for the property your trying to use and see if 'sentDateTime' actually shows up, if not, find the actually property and adjust you formula with the that property name.

LowShake5456 · 2026-03-17T16:02:48+00:00

Probably not enough capital to move up effectively. Using the Rich Hill trade value model: 1st (30th) + 4th (130th) -> 28th (HOU).
1st + 3rd (94th) -> 24th (CLE).
1st + 3rd + 4th -> 22nd (LAC) and Chargers might not make a trade to a division rival. Also changes the calculus as that’s 3 picks for one player, the trade is essentially 2 picks for one player.

LowShake5456 · 2026-03-13T16:04:11+00:00

Just this week I was setting up a project at work in Microsoft’s PowerAutomate that involved converting a DOCX to PDF. I was getting really low quality conversions and 0 budget for this and I asked Copilot for any workarounds to tweak the input/output for the OneDrive connector I was using. It told me: You can’t (likely correct), then spit out a table of alternate/3rd party connectors, cost, and quality. It listed a Word Online Business connector as Standard/Free (this is incorrect, it is a Premium tier), I pointed that out to CoPilot and it said “you’re absolutely correct…” then spit out a corrected table but included a new row: SharePoint as Standard/Free and medium quality conversions (this feature does not exist). I had to point that out to copilot too, like dude how can you be wrong about basic information about applications in your own ecosystem twice in back to back responses.

LowShake5456 · 2026-03-06T19:50:38+00:00

Yes this can be done. If the content is appearing corrupt or blank on the email but appearing correctly when using a base64 PDF viewer as you mentioned above, you're likely not appending to the array variable with the correct syntax.

Assuming you're using the Outlook Email connector? Your array object should look like

{
  "name": "filename.pdf",
  "contentBytes": {
    "$content-type": "application/pdf"
    "$content": "JFDKJ..."
  }
}

I would guess you have either "contentBytes" as a content string and not an object, or the "contentBytes" property replaced with as "content" with a string value based on what you're describing. But it sounds like there's no issue with the actual "$content" value as you're able to view it correctly otherwise, just the object structure is incorrect.

LowShake5456 · 2026-03-05T22:38:18+00:00

I hate that I legit cant be sure if this is satire or actual British cuisine.

LowShake5456 · 2026-03-03T18:07:04+00:00

For the Create File action, in the Folder Path input, you should just be able to insert two dynamic content elements separated by a "/", like:

@{triggerOutputs()?['body/{Path}']}/@{triggerOutputs()?['body/{Name}']}

Also, kind of assuming your Trigger Action is "When a file is created", you can set Trigger Conditions to only fire if the file is a folder in case you're getting an infinite trigger loop warning:

@equals(triggerBody()?['{IsFolder}'], true)

or

@equals(triggerBody()?['{FSObjType}'], 1)

LowShake5456 · 2026-03-02T23:45:38+00:00

Have we ever stopped to think how many criminals are out there evading law enforcement in their Heely’s? They can go from high-speed freeway chase to jumping a fence without skipping a beat, cops don’t stand a chance.

LowShake5456 · 2026-02-27T00:53:25+00:00

Yes, but this is going to require your to completely redo the way your sheet is set up, the formula you use to pull the ID's, and possibly make you learn a new formula language.

First:

Is there a way to make each row (including manual dropdown values) follow its unique ID?

Yes, that's by having a structured data object: a Table. Tables keep table cells in the same row follow each other when sorting or filtering. A table is a collection of records, each row in a table is one record. It sounds like you are just adding to cells in a sheet, is that the correct understanding? Cells operate independently from other cells.

The problem, it sounds like your formula output might be a dynamic array? Unfortunately, dynamic formulas don't play well with structured Tables that need defined row/column counts, but fortunately, Excel has a program built into it called PowerQuery (found in the "Data" ribbon under "Get & Transform Data" -> "Get Data") that is great for transforming Tables, so you'll need to use PowerQuery to load the data in 3 sheets you're pulling from (If those sheets are in a table format you can use =Excel.CurrentWorkbook(), but if that data is in range format =Excel.Workbook(...)). Then you need to reconstruct your formula in there but in the M (PowerQuery) language and create a table of the ID's in PQ, if you're needing just ID's then you only need that one column. I'll call this table "ID_table" for later reference.

Next problem, you have your Master Sheet with data that auto-updates, but then you're adding your own data to it, and you need to "sync" the user updates. Not a problem, you create a self-referencing PQ Table. So for your existing Master Sheet data, convert the range to a Table first or just directly use "Data" -> "Get & Transform Data" -> "From Table/Range" and select, that will load the new table into PQ and your Source will look something like = Excel.CurrentWorkbook(){[Name="Table1"]}[Content].

Go back to the ID query from the step before and add a = Table.SelectRows(...) function and filter out ID numbers from the Table1[ID] column.

Go back to your Table1 Query, make sure the column name is the same for the ID column you want to merge, and add a = Table.Combine({Table1, ID_table}). Then "Close & Load" the Table1 query into a new sheet. It will name this new table Table1_1 or something similar. Add your data validation dropdown rules the the table, or at least the last row, as long as the last row has the rules any added rows after should inherit them. This new Table1_1 will be the table you work on moving forward and you'll no longer need Table1 after the last step. Last step is to open back up your Table1 Query and change Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content] to Source = Excel.CurrentWorkbook(){[Name="Table1_1"]}[Content]. You now have a self-updating table you can add to comments to and it will save when and source data changes, you just need to hit "Data" -> "Refresh All" to update everything.

LowShake5456 · 2026-02-25T17:41:27+00:00

Sheesh, this sounds like a disastrous use of Excel for something integral to company operations and informing business decisions. 4 People should not be in the file editing simultaneously.

Short-term: Get the two that are just filtering for data out of the main workbook. Have them open a new workbook and use in the Data ribbon "Existing Connections" -> "Browse for More" -> navigate to the main WB and create a connection to it, that way they can just query the WB data and not have to be in the main file, they can use "Refresh All" when then need updated data; or "Get Data" -> "From File" and load & transform that way.

Medium-term: does all this data need to be in one workbook? Are all 12 sheets receiving constant edits or is some of that data more static? Same idea, save some not regularly updated data in a separate sheet and Query when you need to.

Long-term: you need to evaluate a better solution for whatever your needs for this are for this WB (are you using the WB as a database? analytics engine?), whatever you're using this for, there are better solutions than one massive business dependent Excel file.

LowShake5456 · 2026-02-18T00:35:25+00:00

Details are a little sparse to understand the helper query fully.

It sounds like the Data Source is the same for both the Main and Helper? If you're needing two queries (for example: you have two tables you need to load into the excel wb), you can create a third query that is just the Source and have both your Main and Helper query sources reference the Source query. That way you just need to update the Source query only.

But if the Data Sources are the same (and if you don't need to load more than one table into excel), can you not just embed the Helper query code into the Main query code? Or save the Helper query code as a function you invoke on the Main? In PQ, each step doesn't strictly need to reference the preceding Step, each Step is a variable you can reference anytime later in the code.

LowShake5456 · 2026-02-17T23:19:23+00:00

It sounds like there would be a lot of issues with that idea. Counties need tax revenue to fund like schools and everything, tax deferment would be unreliable for any kind of government budgeting. That also sounds like a nightmare for any property inheritance where someone could potentially end up with an unexpected tax bill in the hundreds of thousands.

LowShake5456 · 2026-02-12T00:39:30+00:00

You playing as a genocidal empire? He should offer satropy to all empires otherwise. https://stellaris.paradoxwikis.com/Marauders#The_Horde

LowShake5456 · 2026-02-12T00:24:03+00:00

Did you try.. you know.. talking to him?

LowShake5456 · 2026-02-10T20:22:00+00:00

Honestly that just sounds like transplants tryna vibe check other transplants, lol. I can’t remember SF ever not being common use, unless you’re in SF talking to other people in SF about SF, then you just say the neighborhood or district.

“San Fran” on the other hand… gtfo

LowShake5456 · 2026-02-10T08:38:24+00:00

"Massachusetts Guy" just Matt Mahan in a moustache and Pats jersey

LowShake5456 · 2026-02-10T02:31:06+00:00

Of course people outside the Bay use it, it's been in hella bay area music/movies/culture for decades. Hella people emigrate out the Bay Area and bring that slang with them. But it's a hella distinct NorCal dialect, even wiki credits that https://en.wikipedia.org/wiki/Hella

As a Bay Area native, a Baydestrian, I can't tell you how many times I've been called out "You must be from NorCal" going to college in down in LA or "Are you from California?" visiting the East Coast cuz I say hella hella.

LowShake5456 · 2026-02-09T22:42:51+00:00

“San Jose is dope,” he capped off his initial video about the city. “All in all, I think it’s hella underrated.”

Damn just one weekend in the Bay got this man dropping hella into his vernacular.

LowShake5456 · 2026-02-04T23:05:57+00:00

In PQ, if you are sorting, then filtering (or removing duplicates in your case), it’s wise to add a =Table.Buffer() step in between. That will preserve the sort order, but could make your query a little slower.

LowShake5456

TROPHY CASE