power apps
18 TopicsMicrosoft 365 & Power Platform Conference
365 EduCon Chicago, a Microsoft 365 & Power Platform Conference will have workshops and sessions focused on Power Platform, Power Automate, Power Apps and more, taught by the Top Experts! October 30 - Nov 3, 2023. McCormick Place South. https://365educon.com/ChicagoNetwork error when using Patch function: The specified column is read-only and can't be modified.
Hi All, I've created a custom form to enter and edit data in a SharePoint Online List. Creating a new item works perfectly, but if I try to edit an existing item, I get the above error when I try to save, and all my changes are lost. I cannot see any "read only" fields (e.g. ID, Modified by, etc.) in the form in PowerApps. The "App Checker" in PowerApps does not detect any problems. Can anyone point me in the right direction? Even if it's just to some log files which might tell me which field/column is causing the problem? Any suggestions appreciated. Greg.23KViews0likes4CommentsCalendar List in Sharepoint - Default item values
Hi all, I hope you're all doing good. I am doing an office attendance calendar from a sharepoint list in order to enable my coworkers to state when they are coming at the office. The list only have 3 values : -The user -The date -Other (Mandatory column of the list i couldnt delete) With the calendar view, this is what it looks like : And this is the form In order to increase user exp, I wanted to set the user per default so he doesnt have to select himself by using this code in power apps form as defaultselecteditem value : { DisplayName:User().FullName, Claims:"i:0#.f|membership|" & Lower(User().Email), Email: User().Email, Picture:"" } But by changing that, the name directly display itself. But unfortunately, when clicking direclty on the calendar on the + button, the date doesnt set itself by default anymore (while it did in the before the change). It is as the Parent.Default function doesnt work anymore... Can someone explain me what is happening here and how to solve that ? Thanks a lot,1.9KViews0likes5CommentsUser Defined Folder Selection within SharePoint for image upload
Hi there, I'm working on a media library and currently building an approval process where staff would have the ability to upload images to SharePoint. I originally was thinking of doing this via MS Forms, but it seems Forms cannot connect to SharePoint in such as way. The reason why we wanted to use Forms was to create a buffer so staff couldn't just put images straight into the SharePoint library and instead would have to wait for the images to be approved by our Marketing team. Is there a way to build a SharePoint Form or Canvas which would allow the upload of multiple images at once? Would appreciate any advice 🙂810Views0likes1CommentAdd Button to SharePoint Form JSON
I maintain a SharePoint list at work, and I would like to create some buttons on the Edit and Display item forms for common quick actions which involve updating data in several fields / columns. I've tried a few approaches: I have a Power Automate flow for each quick action, and I can currently use these flows from the right-click menu when I'm looking at the SharePoint list, but I can't use them when I have the item open and am looking at the Edit/Display form. I was able to make a custom column on a test list that could set other values in the item, but it also wasn't actionable from the Edit/Display Form. I have the Edit/Display Form configured using the options described here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration. The idea is to add button elements to the header, with the customRowAction of "executeFlow" (or set Value-- tried this too but no luck). I created elements on the Edit Form that look like buttons, that show up where I want them to, the way I want them to, when I want them to. However, clicking them does nothing. Based on everything I've tried so far, I think the json & Flow setup is correct, but so far nothing has transferred to the list forms. I know Power Apps is an option for this, but I would prefer to avoid re-building the current JSON formatting for the list forms in a new place if I can, since the overhead there is much higher. Is there something specific I need to do differently to make buttons work on the list forms? Alternately, is there a way to pull the existing JSON-formatted list forms into PowerApps to start with as a base? Below is what I have in the header JSON to define one of the buttons (edited out work-specific info for obvious reasons). The button is conditionally visible to me & another user who was helping me troubleshoot, depending upon the status of the item, and the flow ID is just taken from the flow URL. The visibility works fine, but clicking the button doesn't do anything. { "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json", "elmType": "button", "customRowAction": { "action": "executeFlow", "actionParams": "{\"id\": \"<the flow ID>\"}" }, "style": { "border-width": "1px", "border-radius": "20px", "width": "225px", "margin": "2px", "box-shadow": "1px 1px SlateBlue", "border-style": "solid", "border-color": "SkyBlue", "background-color": "LightSkyBlue", "color": "MidnightBlue", "text-align": "center", "font-size": "16px", "cursor": "pointer", "visibility": { "operator": "?", "operands": [ { "operator": "&&", "operands": [ { "operator": "==", "operands": [ "[$Technical_x0020_Reviewer_x0020_D]", "" ] }, { "operator": "!=", "operands": [ "[$Status]", "Rejected" ] }, { "operator": "!=", "operands": [ "[$Status]", "Approved" ] }, { "operator": "!=", "operands": [ "[$Status]", "Approved, Won't Be Updated" ] }, { "operator": "!=", "operands": [ "[$Status]", "Abandoned" ] }, { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@me", "<my email>" ] }, { "operator": "==", "operands": [ "@me", "<other work user>" ] } ] } ] }, "visible", "hidden" ] } }, "children": [ { "elmType": "span", "attributes": { "iconName": "SkypeCircleCheck" }, "style": { "padding-right": "6px", "color": "AliceBlue", "text-align": "left" } }, { "elmType": "span", "txtContent": "Mark Technical Approval", "style": { "padding-right": "6px" } } ] } I've also tried making it into a "set value" button instead, but no luck with that either.Solved18KViews0likes5CommentsDeploy SharePoint List from one SharePoint Site to Another SharePoint Site
Hello everyone, I'm using SharePoint as a backend in the Power Apps Canvas App. I'm having 2 SharePoint sites let's say DEV_Site and PROD_Site which will have the same structure i.e. PROD_SIte will be the exact replica of DEV_Site (Just to distinguish Development and Production environment). Now, my concern is how I can deploy all the lists from DEV_Site to Prod_Site once I made appropriate changes to the lists of DEV_Site. The ultimate goal is to Update existing lists and Add new lists in the PROD_Site based on DEV_Site. Can anyone know how I can do this? Any suggestion or solution will be highly appreciated.829Views0likes0CommentsSharepoint Intranet Site and Power apps
Hi! We have a Sharepoint site (Intranet) and we want to add Power App webparts. These apps will have lists as data source, and these lists are in the site, but I wonder if we should create the lists on a separate site, each list on a different site. There will be around 20 power apps, each one with at least 1 list. What is the best practice? ThanksSharePoint and Power Automate integration
Hi everyone. I have stumbled upon something difficult for my level. I have created a SharePoint Task List and in the Task form I have added a Documents webpart. I have created a lookup record for the Document list looking to the task, so for each task will show only linked Documents. When I choose to add a Document it request from me to add the Lookup field to the Task. What I want to do is, when I am uploading a new Document, then to catch the ID of the Task form where the Document was uploaded from and update the lookup field automatically. Also to do the same when I drag and drop the file to upload. I have try any possible way with power automate, but I guess my knowledge is limited for this. Kind Regards Chris