User Profile
wm-thompson
Brass Contributor
Joined 2 years ago
User Widgets
Recent Discussions
SharePoint Lists and AutoSave feature
I am generating a new Microsoft Sharepoint List and I have several questions. I think I will make individual posts here on learn.microsoft.com where each post addresses an individual question or issue. This post, I intend, will address the auto-save issue and feature. As I add content to my Microsoft List, is the data automatically saved? I assume that there might be some way to automatically add a large number of virtually blank rows with an auto-incrementing index (aka title) column. But I thought it would save time to just record and run a macro script to add a large number of rows. I did this on my work laptop which I took home to continue the operation. To my disappointment, when I went to work and rebooted my laptop computer and opened this list, the large number of added rows were not there. Why is this? Isn't there some sort of automatic save mechanism at play? As I suggested, I was working off of a laptop computer that I moved from work to home. Maybe this has something to do with what went wrong. Maybe disconnecting from one server and then attaching to another caused a security flag to be thrown.How do I resolve this exception thrown while trying to do CRUD operations on CSOM?
How do I resolve this exception thrown while trying to do CRUD operations on CSOM? Let me break this down for you. CRUD, of course, means "Create Read Update and Delete". CSOM is the tech for connection C# to a Sharepoint List (or, I assume, also a Microsoft List) in order to programmatically make additions or mortifications to said list from C# code. I think that, due to the fact that the Microsoft List resides on a highly secure remote source dripping with security systems, I get an exception thrown when I set up a query and perform an "ExecuteQuery" from the ClientContext class. I can provide some source code if necessary but I do not think it is necessary. The question I have is simply this. What would cause a 403 Forbidden error and how can I find a way to resolve it?Using Microsoft Lists VS using Microsoft Dataverse in a Power App
I had to step away from a proof of concept I was working on. Now that I have returned, I have some concerns and puzzles. I thought I had created a Microsoft List from scratch for this proof of concept to be used by a Microsoft Power App. But after looking closely at the Power App, I am not so sure of what is going on. Maybe you can tell me what is going on. I have created a Microsoft List and I created a Power App to interact with it. Here is the header of the Power App loaded in the Power Studio: The App is full of data and when tested seems to run properly. When I investigate what its database connection is, I see this icon on the left side: I am shocked that clicking on this icon does not reveal what I expect it to show. I expect it to show that I am using a Microsoft List as a database source. Instead, I see this: This is not as I expected. I notice that the name of the database is "x300 Proof of Concepts" whilst I remember creating my Microsoft List as "x300 Proof of Concept" (without the s at the end). And when I bring up my Microsoft Lists I see the List that I expect to find. While the Microsoft List "x300 Proof of Concept" looks similar. I do not think it is exactly the same thing. How can I find the other database and how can I assign my Microsoft Power App to the other data soucr, the Microsoft List?https://powerusers.microsoft.com/t5/Building-Power-Apps/Help-expand-and-develop-more-content-on-a-Mi
I am working on making a Microsoft Power App that uses data to fill a form. I have used the following tutorial: https://www.youtube.com/watch?v=H11RFxiDltw Fundamentally, it demonstrates creating a blank Power App and then adding a From to the Power App canvas and connecting the Microsoft List to the form. It seems to be an App for submitting a new record to the Microsoft List. But what if I want simply to display the data of a Microsoft List in a list in the Power App? Instead of an app where the user inputs a row into a Microsoft List by using a Power App, how would I create an App which only displays the data currently in the Microsoft List? How would that be done? I asked our friendly neighborhood Bing AI Copilot and here is what she said: Certainly! If you want to create a Power App that displays data from a Microsoft List without allowing users to input new records, you can follow these steps: 1. Create a Canvas App with Data from Microsoft Lists: You can create a canvas app directly from within Power Apps using data from a Microsoft List. The app will contain three screens: Browse Screen: This screen allows users to scroll through all items in the list. Details Screen: Shows detailed information about a single item in the list. Edit Screen: Allows you to create a new item or update existing item information. You can apply these concepts to any list in SharePoint. Here’s how to create the app: 1. Sign in to Power Apps. 2. From the home screen, choose one of the following options: To create a single-page gallery app with a responsive layout: Select Start with data > Create with SharePoint List. Or, choose Start with a page design > Gallery connected to external data > From SharePoint. To create a three-screen mobile app: Select Start with an app template > From SharePoint. 3. If you haven’t already created a SharePoint connection, you’ll be prompted to do so. Enter the SharePoint URL and connect. 4. Select a list and then choose Create app. 5. Your app opens in Power Apps Studio, where you can design, build, and manage it. 6. Give your app a name and save it1. 2. Displaying Data in the App: Once you’ve created the app, you can display the data from your Microsoft List using controls like galleries or data tables. For example, you can insert a data table control on a screen and set its Items property to the name of your SharePoint list (e.g., 'Travel Requests'). When you provide the list name to the Power Apps data table, all the SharePoint columns and records will appear in the table. Customize the app further by adding filters, sorting, and other features as needed2. Remember that you can always preview your app and make additional changes before sharing it with others. Good luck with your Power App development! 😊👍 https://drive.google.com/file/d/1zXH2dyV-57oCId04HkveXkDutSnJj0Th/view?usp=sharing I was able to create a Microsoft Power App using these steps. Now I have some questions. What was automatically generated is a good starting point but I want to provide the user some information based on some calculations from the individual record they are looking at. Is there a way to drop a container into this section on the right side of the page such that all of the other displays are moved down? Inside this area, I want to have three check boxes with the title A, B and C where, depending on the calculations made on the record, one of the three corresponding check boxes is checked. I would also like to know how I can make this app such that it is not the only page. I would like to have perhaps a couple more page with similar content that the user can choose to view.Difficulty connecting to datasource in PowerApps
There are a couple of ways to connect to a datasource. One method is to create a Canvas App with the Datasource itself is part of the creation process of the Canvas App. I will describe my experience with this method soon. Another method is to create a blank canvas app from scratch, then add a form to that canvas app and then connect to thea torm using your shareport List (or Microsoft List) as its Data Source. When I tried the first method I have mentioned here, when it came time to connect to my Microsoft List data, I got a page describing a problem. At the top of the page was this information: (image of page data) The session id is: 89fce4a0-089b-11ef-9c95-17cf2d841331 I have used it as a search string in the suggested support site but I did not get any results. And now for the second method of connecting a data source to a Power App which is to start with a blank Canvas App and then add a database connection to the app by way of a form. This method is described in this videohttps://www.youtube.com/watch?v=H11RFxiDltwwhich I followed. But when it came time to add the connection, I got this connection waithing message that has now been on the screen for a couple of hours. (please wait) I guess there is nothing to do but wait. It is a good thing it is Friday. Maybe by Monday it will have loaded and made the connecion. I am thinking that perhaps since there were many columns in the Microsoft List, it will take a while. But it was not exactly an exhorbanant number of columns. It was around 30 or so. But not thirty thousand. Is it normal for it to take hours? I have seen some strange things in the software world like this where, eventhough computations happen at virtually the speed of light, no one accounted for nested loops and the exponential nature of processes like this. What are your suggestion? Does thesession id, 89fce4a0-089b-11ef-9c95-17cf2d841331, mean anthing? How can I make use of i t? This is part of the low-code or n-code world. Is there any way I can break that and actually use code to access the Microsoft List? Is the problem in part due to the fact that I am using a Microsoft List as a database instead of an actual SharePoint List? Is there a soultion or another option that I can not imagine, think of, or exists but I am not aware of it? I made a recording just in case one might not believe that this is taking a long time to process. Here is at least the first 40 minutes. https://youtu.be/dPEmlaVdGY4I have an issue with a Power App template.
Among the available templates to use to start generating Power Apps is one entitled "Power Apps Training", This looks like a tool were someone can learn Power Apps in a psudo-tutoral where you just press F5 to switch from preview mode to editing mode. It has instructions and exercises included. The problem is on the pageL06_Rules On this page, there is a slider along with a button like this: To best explain what is happening, I will post a screen shot of the instruction: Before I forget I will mention that there is a typo. There are ony 4 steps. The number that comes after three is four, not six. But that is not the issue I am having. Although I am able to complete the task of changing the text of the button according to the number on the slide control. I can not get the color to change. Please advise and help.Matching data types in a flow ignores number data type.
We have created a successful flow which matches the data that is entered from a jotform UI/UX. Then the flow enters the information successfully into a Microsoft List row. Everything is fine and we tested it with a small amount of the data. Afterwards, I went ahead and started adding files and matching them with the incoming data. The problem is noticed when I started to enter number fields instead of short strings. Look at the screen shot I am including. The values for Total TIme and "Flight time last 12 months" had no corresponding data type and the ony difference between these and the other fields is the fact that these two fields are numbers and the others are short strings. When I try to add connection for the number field, I get this error message. Please tell me what this means and how do I fix it.How do I use Azure Data Studio with schemas?
I had thought that a database schema was the name of the structure on which tables are interconnected by primary keys and foreign keys. But in the tool, Azure Data Studio, the user is asked to select from a pre-defined set of schemas when creating a table. What is more is that when setting up or createing a database through Azure, we are given the opportuniityh to use a sample database and this is where "SalesLT" comes from and so there must be some place where we can define a schema with Azure Data Studio. Where would that be? It was generated when deciding to use a demo sample database. So there must be some way, using SQL code or otherwise, to generate a schema.How are schemas used and defined in Azure and wih Azure Data Studio?
I had thought that a database schema was the name of the structure on which tables are interconnected by primary keys and foreign keys. But in the tool, Azure Data Studio, the user is asked to select from a pre-defined set of schemas when creating a table. What is more is that when setting up or createing a database through Azure, we are given the opportuniityh to use a sample database and this is where "SalesLT" comes from and so there must be some place where we can define a schema with Azure Data Studio. Where would that be? It was generated when deciding to use a demo sample database. So there must be some way, using SQL code or otherwise, to generate a schema.
