User Profile
eahbxecrfash3q
Brass Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Support Needed: Streamlining ID Comparison Process
Hi everyone, About once a month, the Workday (WD) team posts updates to the cost center hierarchy, which are documented in the WD Report spreadsheet. This spreadsheet contains two tables on different sheets: "Changes" and "Deletions." Both tables have "ID" as the first column. We maintain our own spreadsheet, called the Master List, which includes a table named "AllClaims." This table lists all our security groups that might be impacted by these changes. The "AllClaims" table has "Group Name" as the first column, with cells containing values in the format "ID Name." I need to identify rows in the "AllClaims" table where the "ID" part of the "ID Name" value matches an "ID" in either the "Changes" or "Deletions" tables. I am trying to accomplish this with a flow, but I haven't found a simple and efficient method yet. Below is a screenshot of my current flow. Could someone please guide me on where I might be going wrong and how I can achieve this? Thank you!How to hide "Updated 1 item" in SP Online Document Library Web Part.
Hi, I added a Document library web part to a page and selected the folder that I needed for that web part. I also selected the "Video Gallery" view which was formatted using JSON. However, when someone clicks the Like/Unlike button, a notification appears saying "Updated 1 item" as shown below. Is there a way to hide this notification?File created from SharePoint list via Power Automate cannot be opened
I have a Power Automate flow that is supposed run once a day at 7:45AM EST. Then Get items from a SharePoint list where the filter query is: ReminderOne column is less than or equal to the date when the flow was triggered and field_4 (Date and Time) is null. Next it should get the following columns and values from Get items: Site (Single line of text), PageURL (Single line of text), the email from Requestor (Person or Group with multi-select disabled), the emails from SiteOwners (Person or Group with multi-select enabled), and field_3 (Date and Time). From the values of those columns it should create an Excel file in https://xxx.com/teams/xxx/Shared%20Documents/xxx/xxx/. Lastly it should take that Excel file and attach it to an email- not as a link but as a file to download. The flow runs successfully, however, when I try to open the file in the folder its in or in the email attachment, I get an error that the file can't be opened.How to add new fields to Events UI
I'm trying to get new fields, Region, Country, Virtual/In-person, and Topic added to the events UI: If I go to the list directly, for example: https://xxxxx/sites/xxxxx/Lists/Events/calendar.aspx, then add an event from there I can see the new fields. However, is there a way to add the new fields to the UI when someone uses the events web part to create an event? I found a similar question, though it was posted 4 years ago, so I'm not sure if anything has changed since then: https://answers.microsoft.com/en-us/msoffice/forum/all/add-fields-to-sp-365-modern-site-event-new-item/3b2b72a6-209b-4a0b-95bf-3e94b63b5d9dPower Apps and Okta Verification
Hi, We use Okta for identity management for our O365 accounts and I'm interested in using it from within my apps as an additional level of authentication - perhaps an Okta login or MFA screen before a user can interact with the app: I've seen other posts asking this but haven't seen any recent ones. Does anyone know if this is possible? Could this be accomplished by using creating a custom connector in Power Automate?Need help with HTML/CSS for PnP Search Results Web Part
I have a PnP Search Results Web Part and I'm trying to change the style so that it looks like the news web part with the tile or list layout. This is what I have so far by using the Card layout: I removed a few fields so that only the news title shows: Is it possible to adjust the HTML/CSS of the results so that it has one of the layouts below. If so, can someone please share the code? Tile layout: List layout:How to set up notifications for Republished pages
If a user only has read access to a page or site, is there a way for them to create a notification so that they get an email when a page is republished? I know users can follow a site, but that only seems to act as a quick link and prioritize content from that site when they do a search from SharePoint.Images in Power Apps Rich Text Editor
There is an issue where the app's rich text fields no longer save images. If an image is pasted into one of the rich text fields in edit mode the image will appear in the text box. However, after saving the image disappears. The Power App is integrated with a SharePoint list. The app also has a Power Automate flow that runs when the user clicks a button which creates an HTML file for the item in the list: Does anyone know if Microsoft changed how the rich text field for Power Apps handles images? Or is it possible that a setting in the app or list was changed by mistake so that images are no longer allowed in the rich text field? The columns with rich text all have enhanced rich text enabled so I'm not sure what's causing the issue. The flow has also not been modified since February and the issue started about 2 weeks ago.Bookmarks
Based on my understanding when a Bookmark is added, deleted, or edited from the M365 admin center the changes are updated immediately after publishing. However, I updated ~20 bookmarks and the updates were not visible until more than 24 hours later. Can anyone please explain what the expected behavior is for when the suggestions get updated with changes to the bookmarks list?How to embed a Microsoft Form into an Outlook email?
I know it's possible to go to the Insert tab > select Poll > create a poll and add it to the email. However, I need to embed a Microsoft Form that was already created into an email, is this possible? Polls are powered by Microsoft Forms so I would think there is a way to embed a form instead of a poll but I can't find a way to do it. Below is an image of a poll that was created and added to an email then sent to a recipient. This is the result I'm looking for if I embed a form into an email and send it out:PNP Filters and Microsoft Forms
I have a PNP web part which is connected to a SharePoint list. The list is populated automatically via Power Automate when a Microsoft Form is submitted. Two of the questions in the form allow multi-values and these questions are being used as filters in the PNP. Because of this, the PNP filter is grouping up any individual's combinations of choices into a separate distinct option. Screenshots are below. Is there a way to combine the choices in the filter without changing the form? Current values: Desired Values:PNP Web Part Filter and Multi-values
I have a PNP web part which is connected to a SharePoint list. The list is populated automatically via Power Automate when a Microsoft Form is submitted. Two of the questions in the form allow multi-values and these questions are being used as filters in the PNP. Because of this, the PNP filter is grouping up any individual's combinations of choices into a separate distinct option. Screenshots are below. Is there a way to combine the choices in the filter without changing the form? Current values: Desired Values:Reindexed SharePoint Communication Site
Hi, I reindexed a SharePoint communication site and after doing so, it appeared to have edited the site's navigation. An entire drop-down with 3 pages as sub-links was removed. However, I'm not sure if it was the reindex that changed the navigation, or if it was a coincidence and a site member made the change. Can anyone please explain how a site reindex could effect a site's navigation? Also, do site navigations have version history, similar to items in a SharePoint list? If so, where can this be accessed? Would it be somewhere in the site settings?Discrepancy with PNP web parts and SharePoint List
I have a PNP filter and PNP search results web parts set up to use a SharePoint list as the source. After doing a bulk update to the list, the PNP web parts now have discrepancies with a few of the columns in the list. The options highlighted in yellow in the screenshot below are not supposed to be there, and do not show up if I filter the same column in the SharePoint list: All items in the list needed updated and since at the time, the list had over 5k items, all items were deleted and then added back in by importing data from a CSV file into the SharePoint List. I used Reza Dorrani's solution which can be found here: https://www.youtube.com/watch?v=b3aQf17ptAs All of the columns in the list are site columns and have been mapped to a refinablestring in the search schema. I've tried re-indexing the list after importing the CSV data and manually re-adding the items that had the discrepancies but that didn't help. I am completely stumped as to why the PNP no longer matches the SharePoint list.Execute Flow while viewing a list item
I've configured the layout for the list item header to use the JSON below: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "button", "txtContent": "Generate PDF", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"************************************\"}" }, "attributes": { "class": "ms-fontColor-themePrimary ms-fontColor-themeDarker--hover" }, "style": { "background-color": "#008082", "border":"1px solid #008082", "color":"white", "cursor": "pointer", "margin-top":"15px" } } However, when I click on an item to view it then click on the "Generate PDF" button it will not run the flow: I've also tried to go into the list's settings and applied the same JSON to a "Generate PDF" single line of text column that I created. The flow will run if I click on the "Generate PDF" button while in the All Items view, but I'm looking to have the flow run while viewing a single item in the list like in the screenshot above. Is this possible? If so, what am I doing wrong? I know it's possible to accomplish this with a Power App, however, Power Apps does not support the table formatting added to rich-text enabled columns.
