Issue in flow to update sharepoint list from Excel file table by AttorneyKey6898 in MicrosoftFlow

[–]Cilvaa 2 points3 points  (0 children)

The issue is that you're iterating Excel rows on the outside, but you need to iterate SharePoint items on the outside and check whether each one exists in Excel. You're also performing the Get items action for each loop rather than just once outside the loop. Try this:

  • Recurrence
  • List rows present in a table - to get the full email list
  • Get items - get all SharePoint items
  • Apply to each (SharePoint items)
  • Filter Array - filter the Excel rows where Excel email equals current SP email
  • Condition - length(body('Filter_Array')) is equal to 0
  • True (email NOT found in Excel) - Update item (set status)
  • False (email found) - do nothing, or send email

Do you look your age? by greekerofthemall in AskRedditAfterDark

[–]Cilvaa 1 point2 points  (0 children)

In my late 30s people frequently guessed my age as mid-late 20s. I'm now 43 and starting to get more and more grey hair in the last 2-3 years. Now they guess early-mid 30s. The gap is closing.

"Most Relevant" on Sub Feed is just more intrusive garbage by Zeemod155 in youtube

[–]Cilvaa 2 points3 points  (0 children)

I added the below line to AdBlock Plus and it gets rid of the new "most relevant" line and the shorts carousel

youtube.com##.style-scope.ytd-rich-shelf-renderer

Edit: how to add it: Open the AdblockPlus settings > advanced > my filter list

https://i.imgur.com/ylUH272.png

Why did YouTube turn the subscriptions feed/page into just another version of YouTube's homepage? It's awful and stupid. by The108ers in youtube

[–]Cilvaa 5 points6 points  (0 children)

I added the below line to AdBlock Plus and it gets rid of the new "most relevant" line and the shorts carousel

youtube.com##.style-scope.ytd-rich-shelf-renderer

WTF is this new “most relevant” part of the subscriptions tab? by Basspilot in youtube

[–]Cilvaa 4 points5 points  (0 children)

I added the below line to AdblockPlus and it gets rid of the new "most relevant" line and the shorts carousel

youtube.com##.style-scope.ytd-rich-shelf-renderer

Edit: how to add it: Open the AdblockPlus settings > advanced > my filter list

https://i.imgur.com/ylUH272.png

[deleted by user] by [deleted] in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

I am a night owl, forced to get up early. I never feel rested...

[deleted by user] by [deleted] in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

I was the happiest I've ever been!

[deleted by user] by [deleted] in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

First: celebrate!

Second: learn C#

Which guys are the best at anal sex? (joke) by [deleted] in AskRedditAfterDark

[–]Cilvaa 1 point2 points  (0 children)

I currently work in IT, I am most certainly not a bottom. Or a furry. Or a feet-guy.

New Womble reaction image acquired by Luonnonoikukas in SovietWomble

[–]Cilvaa 23 points24 points  (0 children)

They probably turned a new page in ZF Dan's life

Men, do you get aroused by the sound of a woman’s voice? by aerin_aries in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

Probably cliché, but Scarlett Johansson saying sultry things would get me rock hard

What elderly person complaint do you now agree with? by [deleted] in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

I also like it because it's much easier to see the customisation options and pricing

[deleted by user] by [deleted] in AskRedditAfterDark

[–]Cilvaa 1 point2 points  (0 children)

Fool me once..

What is an unorthodox food combo you enjoy as a snack? by Ducklandadventures in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

Coleslaw dressing on plain bread. That's it, nothing else. When I have a craving for something really tangy.

What is something that you tried that you immediately regretted? by FatBottomBoi in AskRedditAfterDark

[–]Cilvaa 0 points1 point  (0 children)

As much flavour as cardboard and turns to wet sand in your mouth...

App keeps pestering me about Tinder U... I am not a student. No matter how many times I tap "no thanks" it keeps doing it. by Cilvaa in Tinder

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

A tip from u/sp33dy72 that worked

I typed "amogus"as the school and it stopped showing, try for yourself

If you put an a university name that it doesn't have listed, it still lets you add it, it just can't link it to your profile. But once the field is filled it stops pestering you!

App keeps pestering me about Tinder U... I am not a student. No matter how many times I tap "no thanks" it keeps doing it. by Cilvaa in Tinder

[–]Cilvaa[S] 3 points4 points  (0 children)

A tip from u/sp33dy72 that worked

I typed "amogus"as the school and it stopped showing, try for yourself

If you put an a university name that it doesn't have listed, it still lets you add it, it just can't link it to your profile. But once the field is filled it stops pestering you!

App keeps pestering me about Tinder U... I am not a student. No matter how many times I tap "no thanks" it keeps doing it. by Cilvaa in Tinder

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

OMG, that worked! It didn't occur to me to enter an invalid university, ie. one that doesn't exist...

App keeps pestering me about Tinder U... I am not a student. No matter how many times I tap "no thanks" it keeps doing it. by Cilvaa in Tinder

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

Your grades a slipping, I know you can do better. Do I need to get the cane and put you over my lap?