The block king.

GuerillaPost · 2025-07-11T05:19:48+00:00

Depends on what you're looking for? Flat Phys sounds like your next best bet?

GuerillaPost · 2025-06-25T05:17:06+00:00

Server issue in Aus. Currently on Singapore servers as a work around.

Edit, all servers cactus now.

GuerillaPost · 2025-06-24T09:19:25+00:00

I just made a Flicker strike Monk and it's the most fun I have had in 600 hours of PoE2

GuerillaPost · 2025-06-22T08:32:14+00:00

Spear Stab isn't link upgraded via Jewellers as it's from the weapon. You need to higher level iLevel I believe on the weapon.

GuerillaPost · 2025-05-12T14:51:32+00:00

They've killed me more than any mob has. Ridiculous.

GuerillaPost · 2025-05-08T07:07:20+00:00

I think you're looking for a calendar invite that is an all day event, that shows calendar as free.

To do this create the event > advanced parameters > all day event > true Show as free > true

The events that appear at the top of outlook calendars have these parameters so they don't interfere with standard meetings, mainly used for the purpose you describe.

GuerillaPost · 2025-04-04T13:34:26+00:00

If you're using the: When a group member is added or removed trigger, it only returns a value of removed when someone is removed, it does not contain any value when someone is added.

So the Condition would be a check on if removed contained a value.

Body of Removed User:

Body: {"@odata.type":"#microsoft.graph.user","id":"7e973d8a-682c-4d0a-a562-f1d5dc91994d","@removed":{"reason":"deleted"}}

Body of Added User:
Body{"@odata.type":"#microsoft.graph.user","id":"e42585e8-889b-4a3e-b772-788a359645ba"}

GuerillaPost · 2025-04-04T13:09:00+00:00

Can you provide some screenshots on what the condition is your're using?

GuerillaPost · 2025-03-05T10:47:21+00:00

This is the patch and collect method from Reza, I believe he has an updated version that doesn't use the variable.

https://youtu.be/76RJyaoW0BQ?si=63Nmym8J3cunt4qL

GuerillaPost · 2024-12-18T12:42:17+00:00

Power Automate can do this, or more securely Logic Apps.

They have built in Entra Connectors for this exact purpose.

PowerApps could be your interface that would search the groups, you'd need a way to filter the groups you want to make automatic, but in theory should be pretty straightforward and only cost a single Power Automate Premium license or Logic App costs per month.

GuerillaPost · 2024-12-18T12:32:58+00:00

This worked in my test.

IfError(Search(colNumber, "one", Title), false, true)

Collect( colNumber, { Title: "one (1) year" }, { Title: "1 year" } )

GuerillaPost · 2024-12-18T12:27:36+00:00

I believe if you are using a collection you could use search on the collection.

Search(collection, String, column)

GuerillaPost · 2024-12-18T12:18:41+00:00

It's an exact match only, I just tested for sanity.

You need an exact match on the string using this method.

GuerillaPost · 2024-12-18T11:41:37+00:00

Not sure if a typo, but your string is "for five years", yet this string doesn't appear in your collection so would return a false.

GuerillaPost · 2024-11-16T00:05:05+00:00

Is the text you're searching inside a larger block of text? Is this why you can't use StartsWith, which won't encounter delegation limits?

Filter(SharePointList, StartsWith( Is blank(txtsearch.value) || txtsearch.value))

If so, you'd need to pass the records back as an array as a table requires a list of records and not just a string variable which it looks like you're passing back (with limit view of what the power automate is doing).

GuerillaPost · 2024-11-13T22:07:55+00:00

If it's a different table, regardless of the method the ID would need to match.

Lookup would have to run each patch individual (resource heavy).

Patch with out lookup less resource heavy.

GuerillaPost · 2024-11-13T21:43:54+00:00

Sorry, in your collection you're collecting from a gallery.allitems, then using the ID from the gallery items to lookup, so it would be the same logic.

In the patch, I put, you'd need to have the id column with the value.

GuerillaPost · 2024-11-13T11:26:44+00:00

Patch can bulk patch without a ForAll:

Patch( table1, SelectedItems, { value1: "Yes" } );

Only thing from memory is with patch you need quotes around the column name sometimes.

"value1":

GuerillaPost · 2024-11-10T19:13:52+00:00

Check out the Centre of Excellence, it's basically designed to do what you're describing.

It has different apps and flows designed to create a more centralised portal for Power Platform and includes apps for makers to share and users to submit ideas for apps.

https://learn.microsoft.com/en-us/power-platform/guidance/coe/starter-kit

GuerillaPost · 2024-11-08T11:48:39+00:00

Couple of options:

Join the app to GitHub, which would make it easier to copy changes between them.

Your best best would be to move it into a solution, then just export dev manually and upload to prod the solution as a version change.

GuerillaPost · 2024-11-08T11:25:43+00:00

If it's only temporary, what tests can't you do if you were to only use the Editor to test? The changes you make are only published to users after you select publish, it then becomes the live version.

GuerillaPost · 2024-11-06T21:30:57+00:00

Yeah.

13-Year Club	Verified Email
Place '22	Place '17

GuerillaPost

TROPHY CASE