Member: sterbella | Microsoft Community Hub

Recent Discussions

SharePoint Web Services Issue
SharePoint 2019 server, using InfoPath 2013 form to populate list. using the /_vti_bin/UserProfileService.asmx methods to get group membership, etc. We've been using this solution for several years. A couple weeks ago stopped returning data. The InfoPath, SharePoint site and list have not been changed. The following error is received when querying the web service. When looking at the logs, one of the things that keeps coming up is the message indicating the GetUserMemberships web service can't find the current user (ME). This would seem to indicate either the user doesn't exist in the User Profile Service (My account does exist) or the web services aren't working. I'm at a loss, any help would be appreciated.
Sep 28, 2023 Place SharePoint
developer
Lists
sharepoint server
1.3KViews
0likes
1Comment
Azure AD custom rule to add character to existing attribute
I am migrating off ADFS to Azure AD and the vendor requires an M be added to the start of the employeeid attribute. In ADFS, I just wrote the custom rule Below: c:[Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/employeeID"] => issue(Type = "wfu_id", Value = "M" + c.Value); What the claim then is, is M(and the employeeID) And it worked great. However, I can't figure out how to accomplish this in Azure AD. Any help would be greatly appreciated. I've tried transformations but don't see the way.
Mar 29, 2023 Place Microsoft Entra
Authentication
azure
SSO
573Views
0likes
0Comments
Azure SSO Group claim transformation
Hello, I'm in the process of migrating off AD FS to Azure AD and have a vendor with a difficult claim requirement that I hope someone can help me with. The enterprise application has three groups assigned to it, lets call them GroupA, GroupB and GroupC. Members with access this this application are only ever in one of the three groups. The vendor requires a claim to return a specific value based on group membership as follows. If the member is in GroupA the claim should return "User" If the member is in GroupB the claim should return "Admin" If the member is in GroupC the claim should return "Developer" I've created a group claim that returns only groups assigned to the application but from there I don't know what the next step is. I believe I customize the name of the group claim then Apply regex replace to groups claim content. AM I on the right track? If so, given the group names and the expected return value can anyone help me work this out? Thank you for your consideration
Sep 09, 2022 Place Microsoft Entra
Access Management
Authentication
Azure Active Directory (AAD)
Microsoft Authenticator
SSO
2.8KViews
0likes
1Comment
Re: how to configure dropdownlist to return the Title and not id back to the database
LanHuang Thank you, I've created a question as you've suggested.
Aug 08, 2022 Place Web Development
726Views
0likes
0Comments
how to configure dropdownlist to return the Title and not id back to the database
I have an asp.net mvc using entity framework web app. A specific table in the app has a text column we want to force users to select entries from a dropdown to avoid spelling issues. There are only two selections, Buy Item and Raw Components. We don't want to go through the trouble of creating an actual table and then relate that table with the original. When creating a new record or editing an existing record I would like to have the selected Text and not the selected ID saved in the record. The reason for this is there are many records in the table already AND a report deck associated with the table that would all have to be updated if the ID was saved back to the record. In the examples I've included below, you see I've used the ViewBag method although the Model method (for me) has the same issues. To start I created a class using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace ProdMan4.Models { public class ItemTypes { public int Id { get; set; } public string Title { get; set; } } } Added the following to the controller for this table... private List<ItemTypes> GetITs() { var itemtypes = new List<ItemTypes>(); itemtypes.Add(new ItemTypes() {Id = 1, Title = "Buy Item" }); itemtypes.Add(new ItemTypes() {Id = 2, Title = "Raw Components" }); return itemtypes; } public ActionResult Create() { ViewBag.ItemTypesSelectList = new SelectList(GetITs(),"Id", "Title"); return View(); } Then Added the dropdown on the Create View as follows... <div class="form-group"> @Html.LabelFor(model => model.ItemType, htmlAttributes: new { @class = "control-label col-md-2" }) <div class="col-md-10"> @Html.DropDownList("Title", ViewBag.ItemTypesSelectList as SelectList, "Select Type", new { @class = "form-control" }) @Html.ValidationMessageFor(model => model.ItemType, "", new { @class = "text-danger" }) </div> </div> I have two issues. 1. I can create a new item but it saves the ID to the SQL table 2. The edit view, while setup just like the create view for this column, throws the following error. System.InvalidOperationException: 'The ViewData item that has the key 'Id' is of type 'System.Int32' but must be of type 'IEnumerable<SelectListItem>'.' At this point I'm a bit lost. Any direction would be appreciated.
Aug 06, 2022 Place Web Development
ASP.NET (Classic)
mvc
819Views
0likes
2Comments
2013 Workflows suspending
2019 SharePoint server. A list with a workflow that fires when an item is created or modified and can be started manually. When the workflow is manually started it runs as expected. However, when the workflow is kicked off automatically it is suspended prior to running any of the workflow steps. I get the following error msg. Retrying last request. Next attempt scheduled after 2/22/2022 11:35 PM. Details of last request: HTTP Unauthorized to https://sp.mycompany.com/tools/PositionEvaluation/_api/web/lists(guid'214b96cc-c6f4-4c6f-8c43-d0d062550322') Correlation Id: 3ca90dad-0a2e-5391-b7d7-b11191f79b53 Instance Id: 8da1f3e7-18fb-405e-ab9f-3bdb84cc68e1 Access denied. You do not have permission to perform this action or access this resource. I have an open call with Microsoft, we made sure the application pool service account for the workflow manager had permissions to run the workflow on this list. I've seen others with this issued online but haven't found a solution. Any ideas would be great
Feb 22, 2022 Place SharePoint
sharepoint server
777Views
0likes
0Comments
OData connection to list not returning user data
Our reporting team is trying to use the ListData.svc (https://MySharePoint.domain.com/tools/ProductivityTracking/_vti_bin/ListData.svc/TimeTracking) to access list data for a report. They have no issues accessing the data. Their problem is no user data other than the ID is returned for columns like Created by and Modified by. If someone could show me the ways of the force, it would be much appreciated.
Oct 14, 2021 Place SharePoint
sharepoint server
610Views
0likes
0Comments
Setting ALL DAY status in SharePoint calendar
I'm creating Calendar entries based on a SharePoint list and it works great but I've not found a way to set the calendar event to ALL DAY. Any information as to how to accomplish this would be appreciated.
Jun 07, 2021 Place Power Apps and Power Automate in SharePoint
Microsoft Flow
sharepoint
1.1KViews
0likes
0Comments
Unable to create new site collections
I have a SharePoint 2019 farm. It's a new farm with just 17 site collections. I created two this morning. This afternoon when I try to create a new site collection in CA or via the management shell it fails. Interesting items in the event log. Have you ever seen this behavior before?
Feb 18, 2021 Place SharePoint
sharepoint server
770Views
0likes
0Comments
Re: Job Title missing for "some" people in People web part SharePoint online
sspielmann , I never resolved the issue.
Jan 25, 2021 Place SharePoint
3KViews
0likes
0Comments
Re: Unable to create sites in on premise 2019 farm
In the end Microsoft was unable to resolve this issue. Since this was a new farm with just a handful of test and sandbox sites I then deleted all site collections, content databases and web applications and started anew. The issue is resolved, I do wish I knew what the actual cause was.
Dec 15, 2020 Place SharePoint
1.2KViews
0likes
0Comments
Re: SharePoint 2019 User Profile Service not syncing
sterbella The account running the User Profile Service Application did not have directory sync permission. once granted the issue was resolved.
Dec 08, 2020 Place SharePoint
4.2KViews
0likes
0Comments
SharePoint 2019 User Profile Service not syncing
I've configured the user Profile Service Application in my new farm but I've noticed no profiles are coming in. Looking at the event log I see the following: I'm using the same account I'm using in my SharePoint 2013 User Profile Service and that account is running fine. If you've seen this issue, I'd appreciate some guidance.
Solved
Dec 03, 2020 Place SharePoint
sharepoint server
4.1KViews
0likes
1Comment
Unable to create sites in on premise 2019 farm
I have a 2019 farm with a few site collections. I noticed a few weeks ago I was no longer able to create new site collections. I got the error msg, Sorry, something went wrong. I zipped up the logs and sent them to Microsoft. Three weeks later we still have no solution. Let me give the clues we do know. If I create a new content database I can create sites in that database, but here's the kicker. I can only create sites in the new database for just a short while(we have not determined how long exactly) We decided to update the farm with the latest CU. Once the update was finished I could again create sites in the farm.... For a short period of time. Each time I attempt to create a site collection that fails I get the following errors in the Windows Server Application logs: The content database all check out and seem to be fine. In fact, I can move existing site collections to other existing content databases with out issue. existing site collections can create subsites without issues. If you've seen this issue I would appreciate guidance.
Solved
Nov 23, 2020 Place SharePoint
sharepoint server
1.2KViews
0likes
1Comment
I'm trying to understand Calendars and overlays - HELP
I have a vacation calendar in SharePoint online. When an employee requests vacation they must also select their group as this routes the approval (power automate) to the correct approvers. I have created a view for each team and an overlay for each view(calendar). When I go to the vacation calendar I see nothing. When I go to the view for Team 1, I see the approved requests for team 1. When I go to the view for team 2 I see all the approved requests for Teams 1 & 2. I don't get it. The bottom line is how do I apply these overlays to my vacation calendar so when I view it I see all the teams approved vacation time in there overlay colors?
Sep 09, 2020 Place SharePoint
SharePoint Online
536Views
0likes
0Comments
Re: InfoPath Form (SP2010) migration to SharePoint 2016 help requested
SarahGrzym try right clicking the manifest file, select edit. Once in infopath simply publish the form to the new location
Mar 21, 2020 Place SharePoint Developer
1.2KViews
0likes
0Comments
Re: Infopath not loading data
RobElliott I get it, and thats what we're doing for all net new requests but it's not something I want to do with every form on every site as they are migrated as that would just add to much time to the project. Also, we have many infopath forms publishing to xml forms libraries and for the more complicated data layouts, switching them to Power Apps is going to be an undertaking. What I'm trying to do is supported right? Ken
Mar 21, 2020 Place SharePoint
1.3KViews
0likes
1Comment
Infopath not loading data
I am migrating a SP 2013 on premise site to the SP online. I have a class list and a registration list. To register for a class you select the class on the class list, it opens an infopath form with the class information. The form also contains a hyperlink derived from a calculated column in the class table. =CONCATENATE("https://sp.mydomain.edu/tools/PAS/Lists/Registration/NewForm.aspx?Course=",[Class ID],"&Source=https://sp.mydomain.edu/tools/PAS") So a normal link would look like this: https://sp.mydomain.edu/tools/PAS/Lists/Registration/NewForm.aspx?Course =46&Source=https://sp.mydomain.edu/tools/PAS As you see, it opens the infopath form published to the registration list and populates the form with the data from the current Class ID This was a very easy solution on premise but it doesn't work at all in the cloud. the registration form opens empty. I'm not sure how I would do this in SharePoint online any suggestions would be great. Ken
Mar 20, 2020 Place SharePoint
SharePoint Online
1.4KViews
0likes
3Comments
Re: no Forms libraries and no InfoPath, how do we replace these going forward?
jcgonzalezmartin I get that Microsoft has no plans to replace these things. I'm asking the community what their plans are to deal with these options going away. Specifically, we have many forms that submit to xml forms libraries, if you do what if any ideas are you considering to replace your existing forms?
Mar 09, 2020 Place SharePoint
1.2KViews
0likes
0Comments
Re: Content database shows 0 sites
SteveKnutson , thank you for your reply. I followed your steps but still had no luck. I removed the restored database from the Web Application, created and new content database and created a site collection on the root of the web app(which is where the site collection I need was originally created) I then navigated to the new site and all was well so far. I then removed the newly created content database and mounted the restored database. CA shows no site collection on the database. On examination, I confirmed the restored database does contain a site collection it just isn't picked up in CA. Did I miss something?
Mar 09, 2020 Place SharePoint
879Views
0likes
0Comments

User Profile

sterbella

User Widgets

Recent Discussions

SharePoint Web Services Issue

Azure AD custom rule to add character to existing attribute

Azure SSO Group claim transformation

Re: how to configure dropdownlist to return the Title and not id back to the database

how to configure dropdownlist to return the Title and not id back to the database

2013 Workflows suspending

OData connection to list not returning user data

Setting ALL DAY status in SharePoint calendar

Unable to create new site collections

Re: Job Title missing for "some" people in People web part SharePoint online

Re: Unable to create sites in on premise 2019 farm

Re: SharePoint 2019 User Profile Service not syncing

SharePoint 2019 User Profile Service not syncing

Unable to create sites in on premise 2019 farm

I'm trying to understand Calendars and overlays - HELP

Re: InfoPath Form (SP2010) migration to SharePoint 2016 help requested

Re: Infopath not loading data

Infopath not loading data

Re: no Forms libraries and no InfoPath, how do we replace these going forward?

Re: Content database shows 0 sites

Recent Blog Articles