Help me figure out how to put all of the creation and updates of a tracker into two lists, or help figuring out a better method to have an internal and external tracker.

So here is the weird issue.

I have a team telling me they need help automating, cleaning up, and organizing an onboarding tracker.

But of course everyone wants something different.

The people that do the onboarding want to focus on making a sharepoint list that works, doesnt crash(like excel), and automates tasks like sending emails and such.

Their boss, wants a sharepoint list specifically so outside people can view and see their status.

Now how I did this on my project was I have a sharepoint list for my use, then a power bi dashboard for external viewing, this allowed me to cut out what I dont want people to see, be it personal information or sausage casings(so to speak)

Their boss however is hyper focused on the sharepoint list.

The team that showed their sharepoint list does it one specific way I am not sure I understand.

Basically the hide the columns they dont need so the onboarding team uses edit to see all the columns instead of using edit in grid view and everyone else just has a view only link. But I am not entirely sure how to do this properly.

I worry that while this would work, wouldnt be as secure as it could be.

I can use just about anything, I have access to power automate, power apps, power bi, etc.

So I cam here to brain storm ways I could have an external facing tracker that people can see onboarding statuses without PII.

I already created a tracker on the onboarding teams site, there is a second site that is for external use as well.

So far my plans

A) Do what their boss wants and figure out a way to hide the PII and pray someone doesnt accidentally unhide it.

B)I made a test power app that displays all the names on the left you click on or search a name to find out details on a pain on the right.

C)Make a dashboard like I did for my team

D) Use power automate to feed any new entries into both trackers and then create a second power automate that updates the external tracker whenever the private tracker is updated.

So I came to you guys to brains storm which would be best.

I technically already have B and just need some tweaks before I can show it.
I mostly no how to make C (will have to rejog my memory on certain bits.

A and D I might need help in how to do it though D I am decently knowledgeable about automate so I know I can do it just might need advice on how.

Repost to another community

reddit.com
u/trollsong — 8 hours ago

Help me figure out how to put all of the creation and updates of a tracker into two lists, or help figuring out a better method to have an internal and external tracker.

So here is the weird issue.

I have a team telling me they need help automating, cleaning up, and organizing an onboarding tracker.

But of course everyone wants something different.

The people that do the onboarding want to focus on making a sharepoint list that works, doesnt crash(like excel), and automates tasks like sending emails and such.

Their boss, wants a sharepoint list specifically for outside people can view and see their status.

Now how I did this on my project was I have a sharepoint list for my use, then a power bi dashboard for external viewing, this allowed me to cut out what I dont want people to see, be it personal information or sausage casings(so to speak)

Their boss however is hyper focused on the sharepoint list.

The team that showed their sharepoint list does it one specific way I am not sure I understand.

Basically the hide the columns they dont need so the onboarding team uses edit to see all the columns instead of using edit in grid view and everyone else just has a view only link. But I am not entirely sure how to do this properly.

I worry that while this would work, wouldnt be as secure as it could be.

I can use just about anything, I have access to power automate, power apps, power bi, etc.

So I cam here to brain storm ways I could have an external facing tracker that people can see onboarding statuses without PII.

I already created a tracker on the onboarding teams site, there is a second site that is for external use as well.

So far my plans

A) Do what their boss wants and figure out a way to hide the PII and pray someone doesnt accidentally unhide it.

B)I made a test power app that displays all the names on the left you click on or search a name to find out details on a pain on the right.

C)Make a dashboard like I did for my team

D) Use power automate to feed any new entries into both trackers and then create a second power automate that updates the external tracker whenever the private tracker is updated.

So I came to you guys to brains storm which would be best.

I technically already have B and just need some tweaks before I can show it.
I mostly no how to make C (will have to rejog my memory on certain bits.

A and D I might need help in how to do it though D I am decently knowledgeable about automate so I know I can do it just might need advice on how.

reddit.com
u/trollsong — 8 hours ago

Is there a way to do this without using conditions or switch? Get the first avialbale date from a microsoft form between two questions

Sadly I cant update the microsoft form and remove the question no matter how redundent it feels.

I was basically asked to make it so the form feeds into a sharepoint list, easy right?
One hitch.
One and only one response askes for a "projected start date"

How the form works

  1. What is your role? choose from a list, if you choose contractor it branches to

  2. Contractor type? B puts you back on the same path as the roles above, A asks your projected start date then puts you back on the same path.

Eventually everyone gets asked for a start and end date later again as well.

So of course all of my tests failed so far for the error " field_6 should be type string/date. the runtime value "" is not string/date

If I use a condition that means every time they make a change to the form I will need to edit two Create item steps.

I could just bipass it and make it do start date no matter what but of course there is a chance it is different and that causes problems.

Is there a way I can use compose or some other option that basically says if projected start date returns "" use Start Date instead?

reddit.com
u/trollsong — 1 day ago

17 dollar meal, missing half of the meal, they refund me 1.59 because that was the upgrade price for a premium version of the sandwhich.

So wife wanted the choose 2 deal can choose half a sandwhich, half potato, cup of soup, etc

We chose half a potato and half a sandwhich, upgrading to the reuban for an addition 1.59

The reuban didnt come try and get a refund and Uber says nope its non refundable here's 2 bucks.

I contact customer service who explains that the reuban only cost 1.59 so no refund.

What the hell.

So yea 16 dollars for half a potato.

So now waiting "6 to 12 hours" for a human that can do math.

u/trollsong — 3 days ago

Steam the killa boss have options now or is it purely cosmetic?

I mean between the shield and flail, I was messing on new recruit and I didnt see any but I figure i should ask.

Edit: how badly did I misspelled does where autocorrect changed it to steam?!

reddit.com
u/trollsong — 5 days ago
▲ 102 r/Shaboozey

Not where I was expecting to see jesse.

If they paid you, we'll get that bag.

Just wasnt expecting to see you in a reddit add XD

Edit: also didnt realize how epic the first screenshot I took was XD

u/trollsong — 5 days ago

Is this a decent 1k?

I was thinking of getting the battleforce, huron's box and maybe some warptalons to get to 1k. Wasn't sure how well this would work without rhinos.

Also for future does the lord discordant on hellstaller work decently in a red corsairs army?

+++++++++++++++++++++++++++++++++++++++++++++++

+ FACTION KEYWORD: Chaos - Chaos Space Marines

+ DETACHMENT: Huron's Marauders (Tyrannical Motivation)

+ FORCE DISPOSITION: Disruption

+ TOTAL ARMY POINTS: 995pts

+

+ WARLORD: Char1: Huron Blackheart

+ ENHANCEMENT:

+ NUMBER OF UNITS: 9

+ SECONDARY: - Assassination: 2 Characters

+++++++++++++++++++++++++++++++++++++++++++++++

Char1: 1x Huron Blackheart (130 pts): Warlord, Tyrant's Claw and exalted power weapon, Tyrant's Claw heavy flamer

5x Masters of the Maelstrom (145 pts)

• 1x Captain Sargotta: Laspistol, Power sabre

• 1x Garlon Souleater: Force stave, Mind Wrench

• 1x Garreon the Corpsemaster: Absolver bolt pistol, Reductor array

• 1x Katar Garrix: Axe of Ending, Bolt pistol

• 1x The Enforcer: Bionic gauntlet, Londaxi maimer

Char2: 1x Red Corsairs Reave-captain (60 pts): Power maul, Plasma pistol, Bolt pistol

5x Legionaries (90 pts)

• 4x Legionary

2 with Astartes chainsword, Bolt pistol, Close combat weapon

1 with Bolt pistol, Close combat weapon, Heavy melee weapon

1 with Bolt pistol, Close combat weapon, Astartes chainsword, Plasma pistol

• 1x Aspiring Champion: Chaos icon, Close combat weapon, Bolt pistol, Boltgun

5x Legionaries (90 pts)

• 4x Legionary

2 with Astartes chainsword, Bolt pistol, Close combat weapon

1 with Bolt pistol, Close combat weapon, Heavy melee weapon

1 with Bolt pistol, Close combat weapon, Astartes chainsword, Plasma pistol

• 1x Aspiring Champion: Chaos icon, Close combat weapon, Bolt pistol, Boltgun

5x Chaos Terminator Squad (175 pts)

• 1x Terminator Champion: Power fist, Combi-weapon

• 1x Accursed weapon and combi-weapon: Accursed weapon, Combi-weapon

• 1x Heavy weapon: Chainfist, Reaper autocannon

• 2x Power fist and combi-weapon: 2 with Combi-weapon, Power fist

5x Red Corsairs Raiders (110 pts)

• 4x Red Corsairs Raider

2 with Bolt pistol, Boltgun, Reaver's blade

1 with Bolt pistol, Meltagun, Reaver's blade

1 with Bolt pistol, Boltgun, Power fist

• 1x Red Corsairs Raider Champion: Boltgun, Reaver's blade, Hand flamer

10x Traitor Guardsmen Squad (70 pts)

• 9x Guardsman

7 with Close combat weapon, Lasgun

1 with Close combat weapon, Cultist sniper rifle

1 with Close combat weapon, Flamer

• 1x Traitor Sergeant: Power weapon, Corrupted pistol

5x Warp Talons (125 pts)

• 4x Warp Talon: 4 with Warp claws

• 1x Warp Talon Champion: Warp claws

reddit.com
u/trollsong — 6 days ago

Stabgrot companion question

So the little dude has crit mortal but he's also a companion which means trophy finger gives him crit 2 hits.

Does that mean if the little dude crits he does two mortal wounds?

reddit.com
u/trollsong — 8 days ago

Any places in Tampa bay with a regular necromunda group?

Wasn't sure if this question was allowed or this is the right flair.

Anyways I know Tampa has a big blood bowl community but any stores have frequent necromunda games? I have been tempted to start playing.

Also just in case does the death maiden and wild hunter box work as a start.....I like the lizard doggos

reddit.com
u/trollsong — 8 days ago

I dont really know what ti do with what I own, kruleboyz 2k

So I don't iwn the terrain piece but everything else is what I own, kind of thrown together higglety pigglety cause I dont understand drops now, mostly just collected stuff lol but I realized that of all the random miniatures I own, kruleboyz is what I am closest to a full army with. (Ko is second runner up at like 1.5k)

So I know my drops probably aren't the best as I dont know what inam doing but here is what I own essentially(plus kragnos) I am 180 points from 2k

Kruleboyz (1820 points) - ✦ General's Handbook 2026-27

Kruleboyz

Light Finga

Auxiliaries: 1

Drops: 5

Battle Tactic Cards - Blazing Onslaught

• Flanking Firestorm

Manifestation Lore -

Spell Lore - Lore of the Swamp

General's Regiment

Gobsprakk, the Mouth of Mork (240)

• General

Killaboss on Great Gnashtoof (130)

Regiment 1

Breaka-boss on Mirebrute Troggoth (180)

Gutrippaz (300)

• Reinforced

• 1x Champion

• 2x Musician

• 2x Standard Bearer

Kruleboyz Monsta-killaz (120)

• 1x Champion

• 1x Musician

Regiment 2

Murknob with Belcha-banna (80)

Man-skewer Boltboyz (200)

• Reinforced

• 1x Champion

Beast-skewer Killbow (130)

Regiment 3

Snatchaboss on Sludgeraker Beast (180)

Hobgrot Slittaz (70)

• 1x Champion

• 1x Musician

• 1x Standard Bearer

Hobgrot Slittaz (70)

• 1x Champion

• 1x Musician

• 1x Standard Bearer

Auxiliary

Swampcalla Shaman with Pot-grot (120)

Auxiliary

Faction Terrain

Skaregob Totem

Created with New Recruit

Data Version: v42

reddit.com
u/trollsong — 11 days ago

Does this 3k list look okay?

Edit 2k not 3k dang uneditable titles

I couldnt really decided which battle formation or upgrades to take. And I am still unsure of drops so who drops with who is probably all messed up

Ko (1970 points) - ✦ General's Handbook 2026-27

Kharadron Overlords

Rapid Redeployment Squadron

Auxiliaries: 0

Drops: 3

Battle Tactic Cards - Blazing Onslaught

• Burning for Vengeance

Manifestation Lore -

General's Regiment

Arkanaut Admiral (130)

• General

• Bold as Brass

Aether-Khemist (100)

Arkanaut Company (160)

• Reinforced

• 1x Champion

• 4x Privateer Heavy Weapon

• 2x Skypike

Arkanaut Ironclad (450)

• Grandiose Fuselage

Regiment 1

Aetheric Navigator (120)

• Voidstone Orb

Vongrim Salvagers (110)

Grundstok Gunhauler (140)

Regiment 2

Endrinmaster with Dirigible Suit (140)

Endrinriggers (200)

• Reinforced

• 1x Champion

• 2x Aethermatic Volley Gun and Gun Butt

• 2x Skyrigger Heavy Weapon and Gun Butt

Grundstok Thunderers (260)

• Reinforced

• 1x Champion

• 1x Standard Bearer

• 2x Aetheric Fumigator or Decksweeper, Standard Bearer

• 2x Aetheric Fumigator or Decksweeper

• 4x Grundstok Mortar or Aethercannon

Grundstok Gunhauler (140)

Faction Terrain

Zontari Endrin Dock

Created with New Recruit

Data Version: v39

reddit.com
u/trollsong — 11 days ago
▲ 3 r/pools

How often should I sue a stainless steel brush over a nylon brush?

I have a pebbletech pool and after my pump died and it took a week to get it fixed my pool was pretty green, it is clear now but there are quite a few green algae spots that wont come off without a steel brush but I worry using the steel brush to much will damage the pool

I have a very small steel brush for the occasional algae bloom spot but was thinking of getting s bigger one as these spots are much bigger.

Not sure how well these came out cause it was bright as hell but pics included

u/trollsong — 11 days ago

I dont really know what ti do with what I own, kruleboyz 2k

So I don't iwn the terrain piece but everything else is what I own, kind of thrown together higglety pigglety cause I dont understand drops now, mostly just collected stuff lol but I realized that of all the random miniatures I own, kruleboyz is what I am closest to a full army with. (Ko is second runner up at like 1.5k)

So I know my drops probably aren't the best as I dont know what inam doing but here is what I own essentially(plus kragnos) I am 180 points from 2k

Kruleboyz (1820 points) - ✦ General's Handbook 2026-27

Kruleboyz

Light Finga

Auxiliaries: 1

Drops: 5

Battle Tactic Cards - Blazing Onslaught

• Flanking Firestorm

Manifestation Lore -

Spell Lore - Lore of the Swamp

General's Regiment

Gobsprakk, the Mouth of Mork (240)

• General

Killaboss on Great Gnashtoof (130)

Regiment 1

Breaka-boss on Mirebrute Troggoth (180)

Gutrippaz (300)

• Reinforced

• 1x Champion

• 2x Musician

• 2x Standard Bearer

Kruleboyz Monsta-killaz (120)

• 1x Champion

• 1x Musician

Regiment 2

Murknob with Belcha-banna (80)

Man-skewer Boltboyz (200)

• Reinforced

• 1x Champion

Beast-skewer Killbow (130)

Regiment 3

Snatchaboss on Sludgeraker Beast (180)

Hobgrot Slittaz (70)

• 1x Champion

• 1x Musician

• 1x Standard Bearer

Hobgrot Slittaz (70)

• 1x Champion

• 1x Musician

• 1x Standard Bearer

Auxiliary

Swampcalla Shaman with Pot-grot (120)

Auxiliary

Faction Terrain

Skaregob Totem

Created with New Recruit

Data Version: v42

reddit.com
u/trollsong — 12 days ago

What can we do, rocket mortage is saying that processing the wire transfer will take longer so we will owe more.

So we request a pay off statement, got it today. Which the instructions said if they dont receive it by 6pm est we will owe more, 21 dollars a day.

We took time off work to rush to our banke and do the wire transfer we did is around 3:30.

My wife called them to make sure they got it. They said "no wire transfers take 24-48 hours so you will owe for each day it takes, we will call you back Wed or Thurs to confirm everything. And it will require another wire transfer to pay off the new amount"

Im sorry but what?!

What can we do cause this is stupid.

A domestic wire transfer should take 2 days and we use chase, which owns rocket mortage it should lnt even take a couple hours.

And they are trying to say even though you paid it off and have proof you owe us more.

Is there anything we can do?

reddit.com
u/trollsong — 12 days ago
▲ 0 r/excel

Power query changing the size of columns

I am trying to help a coworker diagnose an issue, they are usign power query and whenever they refresh the data it resizes all of the columns, making some huge width wise.

I even tried going in and manually setting it to a 30 width but the second they refreshed, boom back to large columns again.

Any idea what is causing this and how to fix it?

reddit.com
u/trollsong — 13 days ago
▲ 5 r/HHN

Have there been no food announcements?

Everything else has been revealed but I haven't hear anything about food menus

reddit.com
u/trollsong — 14 days ago

Vampires or underworld for my first team that can throw?

So I mainly play shambling undead but i figure i should get a team that can do passing as well.

I picked up a box of goblins and snotlings, but I never used the goblins because at the time affording special weapons teams minis was not in the books(dang forgeworld premiums) But I did get two trolls.

But Vampires are also tempting but I heard they are difficult and random....though stupid rolls are also kind of random so eh.

reddit.com
u/trollsong — 14 days ago
▲ 22 r/Adblock

Weird issue with youtube and ublock origin on both opera gx and firefox. Videos stuck in a stop and start loop.

I am not getting any like anti adblock warning but what is happening is the video is constantly stopping and starting as if the page is refreshing. Almost like it tries to skip the ad and gets kicked back to the beginning of the ad and stuck in a loop of that.

On firefox refreshing the page actually fixes it on Opera GX it doesnt. But I have to do it everytime for every video.

Has anyone run into this and fixed it by chance?

reddit.com
u/trollsong — 15 days ago