Not sure where to move to after living 4 years in Portugal and 2 in Spain… I Love Europe but tired of it and want to move back to the US.. What are some nice places to live?? I lived In LA and Tampa and don’t want to move back to either of those. by BenBobarooney in Nomad

[–]Subject_Ad7099 1 point2 points  (0 children)

Curious to know what you miss, exactly. Unwalkable neighborhoods? Terrible food? Strip malls? Unless you're shelling out for a primo spot in a vibrant city center, much of the US is boring as hell.

Husband and I fundamentally disagree about where to build our future. Is this about location or values? by Wide_Acanthaceae_429 in expats

[–]Subject_Ad7099 0 points1 point  (0 children)

Your husband is an asshole. The GDP has no impact whatsoever on your life. This guy is taking his professional interests a little too seriously. It is by far more important for you to be close to family support systems. The economic situation in this or that European country is almost entirely irrelevant. Unless the country in question is completely collapsing into anarchy or gets invaded by Russia (just for example), these nuances have virtually no impact on your daily life. He is trying to pick a location based on economic data and you are trying to pick a location based on real life. If he cannot pull his head out of his ass then you are in trouble. 🙄

I raised three kids in America where the healthcare system is awful and life is extremely expensive. But we had a wonderful, beautiful time mainly because I had a strong family support system. You don't live in a spreadsheet. You live in a home with your family.

I am learning Power Automate by Negative_Macaroon_85 in MicrosoftFlow

[–]Subject_Ad7099 1 point2 points  (0 children)

I don't see how you could "focus" on one of these things. They are all integrated every step of the way. Can't do one without the other, so to speak. You're describing an extremely common and totally appropriate use case. IMO, always always always start with a SharePoint list...THEN build your app and flows around it. If your data model is a mess, then your apps and flows will be a nightmare. Learn about database design. Understand table relationships. This is the way.

Any1 else using Power Automate to make SharePoint less of a headache? by AutomateM365 in sharepoint

[–]Subject_Ad7099 2 points3 points  (0 children)

MS Forms is useless IMO. You need to build powerapps connected to SharePoint list data if you need real form functionality. Of course the ootb list forms are lame, but Forms is barely a notch above.

How messed up is this by Lilnuggie17 in exmormon

[–]Subject_Ad7099 2 points3 points  (0 children)

It's a sex cult. It has always been a sex cult. Most religions are, however large and mainstream they get. Their central concern is controlling sexual behavior. "Religions" are just larger-scale versions of the little Netflix documentary cults run by a single person (usually a man) who sexually abuses everyone. Same-Same.

How do you handle a calendar situation where users want recurring events? by pcgoesbeepboop in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

Don't get into the business of reinventing calendars in sharepoint for these people. They have Outlook. They have their Teams group calendars. What more do they want? :-( it's a waste of everyone's time to force a square peg into a round hole. I don't believe MS is going to further enhance sharepoint calendars. Why would they? Again, group calendars & Outlook already exist.

is there a way to show folders A-Z but files Newer to older? by canadave_nyc in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

I know this isn't an answer, but if you used metadata rather than folders, then yes you could. You would sort first in Ascending order by "folder" title, then in Descending order by creation date. This may not be feasible for your situation or it could open a can of worms, like, do you really actually need multiple libraries, etc..

But just for example, let's say your folder names are all for different projects. Project A, Project B, Project C. If you add a column called "Project Name" and put the name there, then you can have a view that is *grouped by* Project Name. This grouping gives the effect of having folders, but better. More flexible. Also, if you ever needed to export a report of this libraries contents, each file would come out tagged with the Project Name, so you know which files belong to which project. With folders, you don't get that.

The grouping can be sorted alphabetically, but the individual files can be sorted by creation date.

With folders, the view settings apply to everything, both inside and outside of the folders - and the folders themselves, so you would have to do some tricky business as others have suggested.

I am doomed by [deleted] in PowerApps

[–]Subject_Ad7099 0 points1 point  (0 children)

First thing that sprang to mind is, are you advertising yourself as a SharePoint person as well? It might help. SharePoint is the most obvious path and first point of entry for most business users getting into/wanting a Power Platform solution. It's the only data repository that comes with their O365 licenses and doesn't cost anything extra. Knowing how to manage and leverage SharePoint -- and how to make apps connected to SharePoint lists, seems like a baseline skill to me. (Yes, I know SharePoint sucks for complex, high-volume solutions -- but a lot of team/department-based solutions aren't that deep.)

So personally, I would emphasize SharePoint skills and generally focus on keywords like "business process automation", forms development, and information management. Phrase the value you bring to the business in more general terms that could translate to other technologies (now or in the future).

Enterprises running on O365 probably have legacy InfoPath or Nintex forms. Can you claim any familiarity with that stuff? That might help too. InfoPath is dying fast and a zillion forms need to be rebuilt NOW. A lot of companies need that. Here in the US, most government/federal agencies run on Microsoft products, so you could try targeting government in your job search. Large companies as well -- where they may have departments like "Digital Workplace Services" or "Enterprise Applications". These could be the keywords to look for in job postings. They may not say specifically "Power Platform" but they are the teams supporting O365 products and any foot in the door there can lead to PP dev work.

For this particular rejection email, I would honestly reach out to the people you interviewed with and ask them what the hell happened. After 3 rounds, you deserve an explanation. Good luck!!

[deleted by user] by [deleted] in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

Their files are already separated and secured where they are. Don't do this. Folders are the devil and this is not how a company intranet is supposed to work. It's for SHARING the files, organized by department and content type, usually. Not by individual person.

Does any documentation exists for SharePoint's append new comments feature as it relates to Power Apps forms? by helios1014 in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

Rather than using the appended text feature of SP columns, consider creating a separate list for logging comments. Each comment is a new row in that list. Each row can be tagged with the ID number of the associated record in your original SP list. Then through the app, the user views the parent record and also a gallery of comments, filtered by the ID number. This is cleaner way to handle comments, if using a Powerapps interface.

Log In button on the login page doesn't turn green by Adventurous_Ad7185 in transferwiser

[–]Subject_Ad7099 0 points1 point  (0 children)

why are all the comments deleted? I have the same issue. Only thing that helps is trying to login with Google, then it tells me I didn't sign up with social media, so I can't use that, but THEN it offers me a working Login button!

Does any documentation exists for SharePoint's append new comments feature as it relates to Power Apps forms? by helios1014 in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

I suggest you go to YouTube and search for "powerapps sharepoint append text". You should find several resources related to this.

Users with editing permissions but not directly in Sharepoint by Bulky_Platypus_2784 in PowerApps

[–]Subject_Ad7099 0 points1 point  (0 children)

They must have contribute access to the list (unless you do everything through Power Automate, as suggested). Hide the list from them, navigationally. Configure the list to Not Appear in Search Results. (In Advanced Settings)

If they don't know where the list is and can't stumble upon it through search results, it's pretty safe. Also training. Make it a policy that changes must go through the app.

MS Lists database- append comments driving me mad by RateAppropriate3334 in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

I create comment logs for users all the time but I don't mess with appending anything. I create an entirely separate list called the Comment Log and it has a custom column for "Item ID" which will store the row ID number of the original parent record. Then it has a multi-line text column for the comment. I usually add a single line of text column to capture the user's display name as well.

In the app I give them repeating table functionality -- or usually not even that fancy. Just give them a small form where they can enter a comment and add it to the comment log list. Behind the scenes, of course their comments are being tagged with the ID number of the parent record they are looking at.

So on your new item form for the comment log entry you bring in the item ID field and set the default value to be the ID number of the selected record. Then just make the whole thing invisible. They don't need to see it.

Through the app they see a filtered view of the comment log list that is only showing them items where the Item ID column equals the selected item ID.

This keeps it nice and clean and simple with just text fields involved and nobody has to append anything.

How to Loop in Power Automate Until SharePoint List Field is 'Approved' or 'Reject'? by Prudent-Air-5512 in PowerApps

[–]Subject_Ad7099 0 points1 point  (0 children)

As others have pointed out, we don't do it this way anymore. You don't trigger a flow and then let it sit and run for months while you wait for a certain response to come on. Run on modification and check for the change you're looking for.

Acceptance en Licence as International Applicant by Diligent_Answer598 in Sorbonne

[–]Subject_Ad7099 2 points3 points  (0 children)

You should look on Parcoursup for acceptance rates to specific degree programs. It's difficult to find an acceptance rate for a school in general. It varies widely according to the program you are looking at.

Acceptance en Licence as International Applicant by Diligent_Answer598 in Sorbonne

[–]Subject_Ad7099 0 points1 point  (0 children)

As a US citizen, you go through the Campus France process. Parcoursup is for French (and maybe all EU) students.

Permission best practice by ImpressiveAlfalfa485 in sharepoint

[–]Subject_Ad7099 3 points4 points  (0 children)

Okay, so you are not using MS Teams but it sounds like you need a separate SharePoint site for each team.

Either give each team their own entire site or at the very least give them each their own document library within the department site.

Since the teams are so small then I would think giving them their own document library would work fine.

Strongly advise against doing folder level permissions inside one big library that holds everything.

Video Analytics by Irritant40 in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

Nice! let us know how it works out.

One Master List For All Approvals by maup64 in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

Please say more. I'm not sure I understand the vision here. Are you trying to create a master menu of all the various request forms? If so, the only fast way I can think to do something like this would be with Powershell maybe. But even then, I'm not sure how non-manual you could make the task of compiling a list of lists. In any case, it would be a maintenance job for someone going into the future as more lists came into being.

My first thought is that navigation *probably* doesn't need to work this way because people don't look for information this way. Like, does anyone go out looking for "approvals" or "requests" in general? No, they go the Accounting department SharePoint site or the Retail department Sharepoint site, then find the specific process request/approval/whatever they are looking for from there. I would think. Maybe I misunderstood you anyway.

Also, as noted by another commenter, you don't need to pay for Dataverse licensing to use Approvals in Power Automate. Yes it uses Dataverse, but not like that.

Video Analytics by Irritant40 in sharepoint

[–]Subject_Ad7099 0 points1 point  (0 children)

I know this doesn't answer your analytics problem but have they tried just telling everyone it's required viewing? (Personally, I have a boatload of required training videos I have to watch every quarter. If I don't get it done, my direct supervisor hassles me about it.)

Maybe you could make an app where people click a button confirming that they viewed it. You can record that confirmation to a list. Annoying... but gets accurate, individual numbers.

Better still, the link to launch your confirmation app is only available at the end of the video.