Power Automate Flow moving Attachments in Email to MS List - can it get a Email as an attachment?
Created a Flow to get Emails from Outlook using Graph API to extract all metadata into columns in a MS List including attachments of the Email into a column in the MS List with the name as a hyperlink in the same site as the list; but when there is another Email as an attachment it does not come into the MS List. Is there such a limitation in MS Flow where it cannot get the Email attached in an Email as an Attachment?
SharePoint List View Restrictions not working
I have created a SharePoint list to track individual attendance for an organization. The organization has 2 ways to track and manage attendance: In-Office and Alternative Office We have created a list with 2 forms where individuals can use either or to log their attendance. The In-Office form is only available on a tablet set up in the office. Because of how this was set up it has it's own Log-In, so I cannot filter by Created By (Only) as it will not show the person, but the ID of the tablet. I have filters in place to Filter for Created By = Tablet ID or Created By = [Me]. To my understanding and testing this will show me any items created by Me or the Tablet ID (or if someone else is logged in the Tablet ID and Them). I added an "AND" filter as well for Name = [Me], again to restrict the items to: Only Items that I OR the Tablet has created AND my name is listed. This is working for me but I'm an admin, Other users (View Only) are not able to see anything. Any idea why this is not showing the other users the same view as me (except with their own personal information)?Copilot Studio - Access SharePoint List
Hi There, for a testing prupose, I want to create an agent with Copilot Studio. I want to access SharePoint List via action="Get items" from SharePoint. I selected/entered in "Inputs" section: Site Address = http:// .... List Name = Employee List Top Count = 5000 Filter Query = Dynamically The list has employee information, around 10 columns, and 150 rows. When I submit such "Who is Jasmin?" or any other similar question such "Who is Jasmin Tailor?" Overall: I am searching about existing employee and not existisng in the list, ... I get always this error message: Error Message: The connector 'SharePoint' returned an HTTP error with code 400. Error Code: ConnectorRequestFailure Conversation Id: 3c0377a0-83c1-412b-9d1a-761f8202203a Time (UTC): 2025-04-15T16:49:08.414Z First time I run this agent with this action, I was asked to connect, which worked fine. However I still get this error message. I am the creator of the agent and I am also the owner of this sharepoint list. Any idea, what am I doing wrong? Or can I somewhere check if this "Get itrems" action or other actions are temporarily not working? THANKS ! Regards, Aykut
Dynamically fill Execute Flow - Flow ID from column value
I'm hoping to have a Microsoft List that has a list of Flows with a button to launch the flow. I have a column where I would enter the ID of the flow to then be able to input the value dynamically into the JSON on the button column. Then formatting the JSON on the button launch column to include the following. "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"[$FlowID]\"}" FlowID being the sharepoint name of the column storing the Flow ID. When I click the button to launch I get the following error - "The provided flow name '[$FlowID]' contains invalid characters.". If I enter the ID value into the JSON then the flow triggers fine. Is this possible? What am I doing wrong?
Creating a Form from a List
The Forms link at the top of a Microsoft List is awesome -- it lets me create a Form for the current list. I can use all of the great features of Forms to make the list be exactly what I want. What's really disappointing, though, is that there's no way (at least that I can find) to connect my beautiful form to the New button for the list. In the Forms section of the List settings, I can opt for the default form, a Power App form, or an Info Path form. It would be fantastic if I could choose the form that I just created -- FROM THE LIST -- to the list. It seems like an obvious and confusing disconnect. The very presence of a link to Forms suggests that this is the way to customize an intake form for the list. But alas, no. I assume I'm not the first person to fall into this pit! Is it on the roadmap?
How to connect SharePoint site access user details via Google Analytics data studio
Hi Experts, Good day, I would like to create new reports in Google data studio (Google Analytics), with the data source coming from SharePoint. I need to import site access user counts, including the number of views and counts. I know that we can export this data via the Microsoft 365 Compliance Center, but my client does not allow tenant access due to data privacy concerns. Could you please advise on how we can achieve this? Specifically, I need to collect SharePoint document and file access user details daily and connect this data to Google Analytics on daily basis. If you have step by step instruction details or if you have alternate way to achieve this let me know. Regards, Gokul
Pb with formating column
Hello, 🙂 I would like to format a column in a list. This column displays the name of a person in our AD along with their email address. I found the JSON code in this community. When the column doesn't correspond to an AD user, I would like to display text located in another column. To do this, I included a condition in the code. But it doesn't work. The field remains empty when the person is not associated with the column. The portion of code that is probably problematic : "txtContent": "=if([$person.title] == '', [$FullName], [$person.title])" $FullName is the name of an other column : { "CellPhone": "XX XX XX XX XX", "ContentType": "Contact", "ContentTypeId": "0x01060062E91085FE5F6C468F33BBF1D871B1F7", "FileRef": "/sites/dsnb/it/Lists/Phones/1_.000", "FirstName": "", "FolderChildCount": "0", "FSObjType": "0", "FullName": "SERVICE 01", "ID": "1", "ItemChildCount": "0", "PermMask": "0x7ffeffffffffffff", "SMTotalSize": "236", "WorkPhone": "" }, { "CellPhone": "YY YY YY YY YY", "ContentType": "Contact", "ContentTypeId": "0x01060062E91085FE5F6C468F33BBF1D871B1F7", "FileRef": "/sites/dsnb/it/Lists/Phones/2_.000", "FirstName": "Toto", "FolderChildCount": "0", "FSObjType": "0", "FullName": "SERVICE 02", "ID": "2", "ItemChildCount": "0", "PermMask": "0x7ffeffffffffffff", "SMTotalSize": "296", "WorkPhone": "AA AA AA AA AA" } Could you please help me with this? Thank you in advance. Ci-dessous le code JSON : { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "children": [ { "elmType": "div", "style": { "background-color": "=if(length(@currentField) == 0, '#ddd', '#aaa'", "border-radius": "1.5em", "color": "white", "height": "1.5em", "min-width": "1.5em", "position": "absolute", "right": "1em", "text-align": "center", "top": "0" }, "txtContent": "=length(@currentField)" }, { "children": [ { "children": [ { "attributes": { "href": "='mailto:' + [$person.email]" }, "children": [ { "elmType": "div", "style": { "font-size": "1.2em" }, "txtContent": "=if([$person.title] == '', [$Fullname], [$person.title])" }, { "elmType": "div", "style": { "color": "gray" }, "txtContent": "[$person.email]" } ], "elmType": "a", "style": { "margin-left": "0.5em" } } ], "elmType": "div", "style": { "display": "flex", "flex-direction": "row", "justify-content": "center" } } ], "elmType": "div", "forEach": "person in @currentField", "style": { "justify-content": "center", "margin-top": "=if(loopIndex('person') == 0, '0', '1em')" } } ], "elmType": "div", "style": { "align-items": "start", "flex-direction": "column", "min-height": "1.5em" } }
List Sharepoint Clickable cards
Hi everyone ! I need some help. I have formatted my SharePoint list as clickable cards to link to a URL, but I would like to change the layout to a grid mode and I can't seem to do it. The cards always appear one below the other in a single column. Could you please help me?Need a Percentage formula in the Progress field of the Gantt
I just built a Gantt in Sharepoint. This is an odd way to do it but it works. I need to know how to add the calculated formula in the Progress field. Right now the numbers are manually added. So I added the calculation in the Column Formatting - Not sure if I did this right? I also want to see a % in the bar as well but I am clueless in JSON??? Thank you, Holly
Sum for a Calculated Column
I am tracking invoices for projects throughout the year. The columns in my SharePoint list include: PROJECT TITLE JAN, FEB, MAR… DEC (monthly invoice amounts, formatted as currency) TOTAL (a calculated column that sums the monthly values) The issue I’m facing is that I can see the Sum for each month at the bottom of the view, but I cannot see the Sum for the TOTAL column. Since it’s a calculated field, SharePoint won’t let me display its sum. If anyone knows how to work around this, I’d be incredibly grateful!
