- 231
- 156 576
David Soden
United States
Приєднався 15 бер 2007
David Soden has 25+ years of experience in both software and digital infrastructure solutions, including hybrid digital cloud infrastructure and software designed to speed up the needs of both Fortune 500 and medium to large-sized companies. He also brings an additional 17 years of software product management and leadership to his role. His chief strengths lie in architecting low-code and traditional software solutions, strategic thinking, execution, delivering results, and leadership across various modern and legacy IT teams. He is passionate about improving operational efficiencies by leveraging modern low-code technologies where applicable, driving increased efficiency, maximizing ROI, and enriching both the internal and external user experience.
Subscribe to this Chanel if you want to learn more about fantastic software & automation to run your business, department, team, or tasks. You can reach out to me on my website here www.davidsoden.com.
Subscribe to this Chanel if you want to learn more about fantastic software & automation to run your business, department, team, or tasks. You can reach out to me on my website here www.davidsoden.com.
Installation and Setup for Your Power App Solution
Welcome to the first step of our exciting journey into building powerful applications with the Microsoft Power Platform! In this video, we’ll guide you through the essential installation and setup process for our canvas app solution.
🌟 What You'll Learn:
Step-by-step installation of all necessary tools
Setting up your environment for optimal performance
Key configurations to ensure a smooth start
An overview of what’s to come in our upcoming series
Join us as we lay the foundation for your app development adventure! Whether you’re a beginner or an experienced developer, this walkthrough is designed to get you up and running quickly. Don’t forget to subscribe for future videos where we dive deeper into advanced features and functionalities!
🔔 Stay tuned for more insights and tips on mastering your Power Apps journey! APP DOWNLOAD LINK:
github.com/dtsoden/UA-camVideos/tree/main/AdvancedApp
APP DOWNLOAD LINK:
github.com/dtsoden/UA-camVideos/tree/main/AdvancedApp
🌟 What You'll Learn:
Step-by-step installation of all necessary tools
Setting up your environment for optimal performance
Key configurations to ensure a smooth start
An overview of what’s to come in our upcoming series
Join us as we lay the foundation for your app development adventure! Whether you’re a beginner or an experienced developer, this walkthrough is designed to get you up and running quickly. Don’t forget to subscribe for future videos where we dive deeper into advanced features and functionalities!
🔔 Stay tuned for more insights and tips on mastering your Power Apps journey! APP DOWNLOAD LINK:
github.com/dtsoden/UA-camVideos/tree/main/AdvancedApp
APP DOWNLOAD LINK:
github.com/dtsoden/UA-camVideos/tree/main/AdvancedApp
Переглядів: 129
Відео
Walkthrough of Our Power Apps Journey
Переглядів 4614 днів тому
Welcome back to our channel! In this video, we’ll take you on a comprehensive walkthrough of everything we’ve explored in our Microsoft Power Platform series. Whether you’re a beginner or looking to refine your skills, this session covers it all! 🔍 What You’ll Learn: Quick recap of key concepts like gallery configurations, date calculations, and color customization. Insights into creating dynam...
Template Fill & Advanced Settings in Power Apps
Переглядів 5014 днів тому
In this video, we dive deep into the world of gallery records within Microsoft Power Apps! Learn how to effectively use the template fill property to enhance the visual appeal of your galleries. We’ll explore advanced settings that allow you to customize the appearance and functionality of your app, making it more user-friendly and engaging. 🔍 What You’ll Learn: How to set up and customize gall...
Transform Your Canvas App: Change Default Colors in One Go! 🎨
Переглядів 3814 днів тому
In this video, we dive into the Power Platform to show you how to effortlessly change the default colors of all controls in your canvas app with just a few simple steps! Whether you're looking to enhance your app's aesthetics or maintain brand consistency, this tutorial is perfect for you. ✨ What You'll Learn: How to access and modify default color settings across your canvas app. Quick tips fo...
Date Calculations and Building a Traffic Light Component in Power Apps! 🚦
Переглядів 8414 днів тому
In this exciting bonus video, we dive into the world of date calculations within the Microsoft Power Platform! Learn how to manipulate and calculate dates effectively to enhance your canvas apps. We'll also guide you through creating a dynamic traffic light component that visually represents important data trends. Whether you're tracking deadlines, project statuses, or other critical metrics, t...
Creating Banded Rows in a Gallery: Dynamic Indexing in Microsoft Power Apps
Переглядів 8114 днів тому
In this video, we'll explore how to implement banded (alternating) rows within a gallery in your Microsoft Power Apps canvas app! Whether you're looking to enhance the visual appeal of your data presentation or improve user experience, banded rows can make a significant difference. 🔍 What You'll Learn: Step-by-step guide to creating banded rows for better readability. How to dynamically add an ...
Invalid Argument: Expecting a OptionSetValue" in Microsoft Power Platform Canvas Apps
Переглядів 7314 днів тому
Welcome to our channel! In this video, we delve into the common error "Invalid Argument. Expecting a OptionSetValue" encountered in Microsoft Power Platform canvas apps. If you're a Power Apps developer or enthusiast, this comprehensive guide will help you troubleshoot and resolve this specific issue effectively. 🔍 What You'll Learn: Understanding the OptionSetValue data type and its significan...
Mastering Data Management in Power Platform: Import, Transform, and Migrate Data with Ease
Переглядів 1653 місяці тому
Mastering Data Management in Power Platform: Import, Transform, and Migrate Data with Ease
From Chaos to Control: Taming JSON Data with Power FX Functions
Переглядів 1234 місяці тому
From Chaos to Control: Taming JSON Data with Power FX Functions
How to use Power App Named Formulas like a Boss
Переглядів 1734 місяці тому
How to use Power App Named Formulas like a Boss
Power Platform Multi-Table Data Modeler
Переглядів 1594 місяці тому
Power Platform Multi-Table Data Modeler
Save MONEY, OpenAI Custom Power Apps & Automate Flows, Step-by-Step
Переглядів 2254 місяці тому
Save MONEY, OpenAI Custom Power Apps & Automate Flows, Step-by-Step
Power Apps View Code - overcome limitations and missing features today!
Переглядів 2604 місяці тому
Power Apps View Code - overcome limitations and missing features today!
#54 Power Fx - Series - Language Function
Переглядів 585 місяців тому
#54 Power Fx - Series - Language Function
#53 Power Fx - Series - AsType and IsType functions
Переглядів 1095 місяців тому
#53 Power Fx - Series - AsType and IsType functions
#52 Power Fx - Series - Now, Today, IsToday, UTCNow, UTCToday, IsUTCToday functions
Переглядів 375 місяців тому
#52 Power Fx - Series - Now, Today, IsToday, UTCNow, UTCToday, IsUTCToday functions
#51 Power Fx - Series - WeekNum and ISOWeekNum functions
Переглядів 356 місяців тому
#51 Power Fx - Series - WeekNum and ISOWeekNum functions
#50 Power Fx - Series - IsNumeric function
Переглядів 326 місяців тому
#50 Power Fx - Series - IsNumeric function
#49 Power Fx - Series - IsMatch, Match, and MatchAll functions
Переглядів 4136 місяців тому
#49 Power Fx - Series - IsMatch, Match, and MatchAll functions
#48 Power Fx - Series - Round, RoundDown, and RoundUp functions
Переглядів 316 місяців тому
#48 Power Fx - Series - Round, RoundDown, and RoundUp functions
#7.16 Power Fx - Series - Operators - in, exactin
Переглядів 636 місяців тому
#7.16 Power Fx - Series - Operators - in, exactin
#47 Power Fx - Series - If & Switch functions
Переглядів 526 місяців тому
#47 Power Fx - Series - If & Switch functions
Make a "Sharpoint List" into a SECURE API endpoint for your clients!!
Переглядів 2108 місяців тому
Make a "Sharpoint List" into a SECURE API endpoint for your clients!!
Canvas Power App, Export Data to Excel From a Gallery
Переглядів 7 тис.8 місяців тому
Canvas Power App, Export Data to Excel From a Gallery
#46 Power Fx - Series - Host function
Переглядів 648 місяців тому
#46 Power Fx - Series - Host function
#45 Power Fx - Series - Hashtags function
Переглядів 738 місяців тому
#45 Power Fx - Series - Hashtags function
#44 Power Fx - Series - GUID function
Переглядів 748 місяців тому
#44 Power Fx - Series - GUID function
#43 Power Fx - Series - GroupBy and Ungroup functions
Переглядів 798 місяців тому
#43 Power Fx - Series - GroupBy and Ungroup functions
#42 Power Fx - Series - ForAll function
Переглядів 1509 місяців тому
#42 Power Fx - Series - ForAll function
Absolutely great video. How do you manage to open the msapp file from Windows Explorer though?
@@sebastiaanvanvugt1761 it's just a zip file. Change extension to open. Or use power platform CLI to unpack
Perfect. It took me far too long to find out how to compare 2 strings that aren't equal, few seconds in and you've answered it for me :)
Horrible. Why should I give you 50 mins when you only have a following of 1.3K subs. And then you talk over the studio voice.
Thanks for the video. how can I order the columns in the excel?
Have you tried the sort(), in front of the showcolumns().
Hi David, Thanks for the video, I have an issue - hope you can help me. I created an on-premise gateway, used it to create a custom connector to upload file to an internal api. Custom connector action to upload a file has the fields like (container, title, file ) and posts a multi-part form data to the api. when I check the action in connector's swagger editor, I see the fields (container, title and file - which allows me to upload a file). When I use the connector in Power automate, I see the fields Container, title, body (instead file - to post the file content), and file (file name). My api is expecting file parameter instead of body in the pay load. Is it possible to fix the connector so field with name body appears as file. Thanks
been quite a long time since I had to do this but I think is something like.... (you will have to play) parameters: - in: formData name: FileData description: The file to be uploaded required: true type: file
@@DavidSoden Thanks for the quick response. Yes I am doing the same but some how in power apps its showing as body. Cannot show the image here. But anyway, I will have to play with it. Thanks again.
I cant see this option in the current version. Help!
Not much you can do then. Brain surgery is your only option. Download the app. Then make a new empty app and download that. Do a YAML comparison and try copying the code over. It's lots of trial and error but something should stand out. Past that open a ticket with Microsoft.
Hi David, is there a way to deactivate relation with the project for web ?
@@r.zainalarifinfandisaputraif you're talking about dataverse yes, unless it's a system relation or they did something to prevent it and finally a dependency preventing it from being deleted. Some you can work through others no.
@@DavidSoden I see. It's related restrict how user enter new project. I'd like to make it one flow only just registering in project accelerator, but yesterday incidentally created by user who I haven't yet gave him access. After I went through, I found that my user imported his *.mpp to project for web. I was trying to delete and updating its status to inactive, but it impacted to his project for web. I guess I need another work around to solve this
so pipeline does not exist that time? looks painful to transition from DEV to PROD
correct, did not exist, ADO and or PP-CLI were the main options past manual.
Dear Teacher, Thanks very much for your precious time to make Videos. I am a newbie and very struggling now. May I bother you. I need combine 2 lists: List A & List B from SharePoint into 1 edit-form C; A is a to be inputted list (for example: Team 1, Team 2,…; Team 1 do job 1, Team 2 do job 2, so on) B is a data list already on SharePoint (for example: employee code, employee name, so on) Things I want to do are: Step 1: input Team 1, job 1, …for list A. Step 2: make an App by edit-form C. Step 3: C picks data from both A and B. Step 4: print out edit-form C. *Example: final image of edit-form C: +Team 1, do job 1, by employee1, employee2, employee3, employee4. +Team 2, do job 2, by employee5, employee6, employee7, employee8. +So on. If possible could you pls help, teach me. Many thanks.
Usually happy to help in the comments section, but this ask very large for a comment. This is the 1st time I have had this large of a question ask in the comments so... If you would like to discuss hiring me for 1:1 consulting training davidsoden.com/#MyCalendar, perhaps this is an option but I do not see this possible to answer in comments.
Manual - drive.google.com/file/d/10ulVANnFEw2gwfk2KliQdfyRiMLOC29s/view Report - lookerstudio.google.com/reporting/3e672222-4bee-4a9d-9e36-d93aa3b6ee7b Link Builder - utm.transformationleaderspodcast.com/Form
Hi! Informative video:) However, I faced one problem: when I press the button, the "ready to scan" message does not appear :((( Do you know if this could be a bug with Microsoft? My phone can read NFC through other apps
Which mobile platform? iOS is more finicky over Android IME
Ok so I made a quick simple app and ya the function is completely changed and non functional. Suggest you open a ticket with microsoft ASAP and I'll do the same. the more pain they see something is broken the more incentified they are to make it go away. make sure you open the ticket from the admin center admin.powerplatform.microsoft.com > left side bar HELP & SUPPORT
@@DavidSoden yep, we were going to raise a ticket and noticed that the ticket was already raised the day before (4406775-ReadNFC feature is not working in power apps moible)! It is related to the new PowerApss version. Workaround helps but I hope Microsoft will fix this soon. Proposed workaroud: "While addressing the long-term solution, for short term resolution kindly proceed with publishing your application by setting the studio authoring version to 3.24092.19 and republishing the app."
I have confirmed with Microsoft that this will be fixed in 10.2 starting on 10/21/24 and available to all regions by 10/28)24. Hang tight! And use the workaround in the meantime.
@marti0 I received word from Microsoft that this has been resolved. I build a basic test app which is now working.... github.com/dtsoden/UA-camVideos/tree/main/NFC_Testing_App
This only works if you have less than 100 rows? What happens when there is more than that?
Not 100% what your referring to but I believe your speaking to the gallery that only loads the first 100 rows of data at a time. If you scroll it gets the next... so on and so forth up to the default of 500, which you can change in settings to a maximum of 2000.
Thank you. Very helpful.
Thank you!
Thanks a million. I don't have the view options, so this was really helpful!
Thank you!
Great Video!
Thank you!
Thank you for this very informative video. I ran into an odd issue when trying to unpack the msapp to a subfolder. When setting the --sources command to .\unpackFolder or .\unpackFolder\ or even c:\projects\unpackFolder, I would get an error that is not a valid command. So if anyone else has this problem, navigate the console to the folder you want to extract the files to and only set the sources to --sources \ and just reference your .msapp file as --msapp ..\YourApp.msapp
Great Video . 👍
thanks!
Excellent tutorial. Thank you. Are multiple separate customised PMO Accelerator projects possible on the same environment?
Unfortunately no because of how dataverse and environments work. I question multiple instances as well because how the integration is with project for the web and the default environment. You would have to segment another way IMO. Lots of experiments trial and error. If you need something like that use another application likly a faster win.
Wow, good to know, before I watched this I would of made each table a separate named formula.
Glad it helped.
how to generate a certificate for the ip address and port ?
--domains "<<Your Domain>>" :"<<Your Port>>"
It works thanks you! A quick notice, I had to activate a second one called relational something they also asked for this and then it worked.
thank you for the additional context - hard to believe in 2024 this video is still giving value, assumed this video had a shelf-life if about 1 year. 😁
Thank you David. only the following part i had issue @10:55 i used this for unpacking : pac canvas unpack --msapp C:\PowerApps\MSAppFiles\IssueAppSQL.msapp --sources C:\PowerApps\ProjectFiles\IssueAppSQL Source msapp file: C:\PowerApps\MSAppFiles\IssueAppSQL.msapp Target output folder: C:\PowerApps\ProjectFiles\IssueAppSQL for packing : pac canvas pack --sources C:\PowerApps\ProjectFiles\IssueAppSQL --msapp C:\PowerApps\MSAppFiles\IssueAppSQL.msapp
master piece of productivity
Thanks for the kind words 😊
awesome!
@@davidjimenez8952 thanks man
But is must not be static information. Only the calculation is static. I use ist for example to collect data from a SharePoint list: nfRecordOfMyList = Filter(YourShareSpointListName, ID = gblID) And in many places of my app, I update this global variable: Set(gblID, Gallery1.selected.ID) And now my named formula is updated.
Very useful, great help, thanks
Thank you, glad it helped in some way.
Fantastic 🎉
Thanks, Janardhanan
Hi David, thank you for your tutorial, but I have one question. If this project app would like to access by multiple members, should I add connection for common data service for all the members ?
@@r.zainalarifinfandisaputra dataverse tables and access are controlled typically through roles. So yes, your users are going to need to make sure they have the appropriate role assigned to them. I'm not sure if that's what you meant, but security is a topic that literally covers pages of written content. So before I write or reply a scroll, let's make sure I understand what you're asking.
@@DavidSoden Hi David, thanks for replying. It's related importing solution. In importing solution > connection for common data service dialog, it's default to my account. I'm just thinking that do I need to add all members in this section or no. But, yesterday I've just finished the import process and my team is able to access the project accelerator now. Another question David, related security roles. I saw Project Common, Project Owner, Project System, Project Team Member, and Project User. Should I just follow based on this role to setup the my team access to this project accelerator ?
@@r.zainalarifinfandisaputra this is a complicated topic as most of this is based on your needs and what your trying to accomplish. If you start here github.com/OfficeDev/Project-Accelerator?tab=readme-ov-file#deploying-the-solution for the official repo and deployment instructions, you will see a link that takes you to "An environment with the Project for the web solution in it. Learn more about deploying Project." that link takes you here... learn.microsoft.com/en-us/project-for-the-web/deploying-project and there you will see much of what you are likely seeking. You can customize anything you want based on your needs as this is an accelerator which means you can change up almost anything you want or need within reason.
@@DavidSoden I see, well noted David, thank you very much for your help.
Excellent video, learn lots of things, #developer ♥️
Thanks for the kind words ☺️
Awesome
thanks
ops..I saw #5....so i should not use anymore onprem gateways?
see above as this is likely all related
Hi David, I hope you are doing well. question..I need to use a gateway, to call an internal API...for ex..using HTTP request, with Gateway...or create custom connector...with the last one, I need ADMIN privs on the Gateway (wont work...) also I tried using HTTP request with Entra ID, which enables the use of an onpremise gateway...but..I CANT see the gate way in the popup list of the connector....altough I DO SEE the Gateway in the gateway lists....any idea? Custom Connector is the only option? thanks in advance!!
IMO there are times and ways to change up the tech stack this may be one such example why to do such. Do you know about "private endpoints in Azure, and combined with a S2S VPN or ExpressRoute"? Power platform gateways are good, but there are times when... Also you can do desktop flows to power automate cloud flows, but its slow and messy IMO. In the end it's what you know. and what your allowed to spend, and what your allowed to do, and (sometimes who you know ;)
Well done sir. Clear and informative. Thank you for sharing. Just even after creating and naming Clearcollect, it's not been added to my tables (so that I use it in a chart). Do you have any idea what would be wrong?
not without seeing the code. Clearcollect cleans the table empty then collects whatever you put in it. if you are checking the left side bar {X} icon, under "collections"... perhaps you need to refresh the variables/collections - this happens to me quite often and I think nothing has happened and it has
I am looking for a contact number for AI Revolutions having difficulty getting signed up.
I only see the 'Allow users to run custom script on self-service created sites'. The other option you mention does not appear at all. Will it still work? Great video - thanks!
Do you have global admin rights? Can you find someone with these if not?
@@DavidSoden, yes I do have global admin rights...
@@deborahjoyous looks the same for me here so it may be something different on your tenant. Try opening a ticket with Microsoft?
@@DavidSoden, will do. Thanks!
@@DavidSoden, after quite a while with Microsoft, the result was that those instructions are for a Classic SP site. For Modern, you also have to go to the SP Admin Center, then select Active Sites > select the site in question > click Settings > Edit Custom Scripts > Allow. Save as Template appears immediately after that. Hope this helps others in the future!
Great video! thank you
Thanks for the kind words 😊
Does this method maintain the IDs in the list after import?
IME yes the ID column and values matched
Hey David, I know this is an old video, but if you have any insight, I would love to figure this out. I am not able to get my PowerBI Reports to show updated projects information. Someone else set the accelerator up before I started working for this company, and I think it may have been configured incorrectly. How would I go about fixing a broken powerBI dashboard? I am slowly thinking I will need to fully uninstall and reimplement the accelerator to the org, but if you have any ideas of an easier work around, I would love to hear them! The person who set it up did so following this video, if there is a more updated one, that would also be great! I couldn't find one, but I may not have looked hard enough. Thanks!
It's because you do not have Power BI connected to its online service ($), and the Power BI service will do a scheduled refresh. This all has to be set up in the Power BI service one time. So the best thing you can do, which is not ideal at all, is manually refresh the report. This is okay for development and testing. Then you can re-publish the report and life goes on. In order to get the basic power bi service, it's like 10 bucks a month, last I checked.
Thank you David!
Thats awesome, glad I ran in to this.
Thanks for stopping by. Glad it helped.
Hi David, I was looking to access the global file from your repo but it appears to no longer be there. Is there a reason why it has been removed?
Hi Paul github.com/dtsoden/UA-camVideos is live and in the description of this video. Perhaps what your looking for I moved? Do you have the link that's not working and Ill dig deeper?
@@DavidSoden At 12:34 you reference a file called OpenAI_Global.yml which I do not see in the repo. I see AuthorizationConfiguration.jpg, AzureOpenAI.png, AzureOpenAI.yaml, OpenAI.png, and OpenAI.yml, but not the global one. I tried following using OpenAI.yml but I got stuck when trying to create the access token header because it said it was already a part of the request.
I've looked and looked online locally and can't find this file I must have accidentally deleted it. Apologies. The concept can be used with the available openAi file there.
@@DavidSoden Alright. I do believe I figured it out anyway. I will need to test with my organization still, but I was able to successfully run the test protocol without an authorization field so I think I'm in the clear. Thank you for your video!
@@pauldigerolamo1084 Glad this helped. and apologies again.
Nice tutorial
Thanks
Hello, thanks to sharing this. when I try to import solution, it failed to import, can not move to next. any one how how?
Sorry I missed your comment. What is the specific error you are getting?
@@DavidSoden quit the same here. No se ha importado la solución "BTD-ExportExcel": Import Solution Failed: CustomControl with name contoso.excelexport failed to import with error: Principal user (Id=e8089609-adb5-ec11-983f-000d3ac05679, type=8, roleCount=5, privilegeCount=1533, accessMode='0 Read-Write', AADObjectId='01a07ca1-19b8-463e-8f91-a1ac602bb99a', MetadataCachePrivilegesCount=5183, businessUnitId=2c628de0-4a2d-eb11-bf68-000d3a88758c), is missing prvCreateCustomControl privilege (Id=036ed3c6-2dfd-4b98-9271-3bc72cba3586) on OTC=9753 for entity 'customcontrol' (LocalizedName='Control personalizado'). context.Caller=e8089609-adb5-ec11-983f-000d3ac05679. Consider adding missed privilege to one of the principal (user/team) roles.
Thanks a lot for the instructions! Very helpful! Do you know if the PAL will still work even if the ServiceAccount is set to "Disabled"? Some of our customers are not comfortable having too many "Owners" on resources....
Two things are a must. PAL association and owner. Not sure about disabled status. Gut says no. You'd have to test that.
Very useful piece.
Many thanks!
Thanks David, definitely going to need this sooner or later. I really like these shorter videos that don't cook my brain.
Glad to help
Awesome!
Thanks!
Awesome Tutorial, thanks for creating. I am trying to bring P4W into my organization and this was very unintimidating. Since we don't have full support yet, I launched project and the accelerator in a dev environment and for the most part this worked extremely well. I ran into one issue with the PowerBI report, though, that I was wondering your thoughts on. I had the same problem with you on the naming convention as your hack fixed it, but now there is 3 instances of the dashboard that appear as a drop down in the Project App. I can set as default the one that works for the report, but I'd like to remove the other two. Where can I find those? ALso curiously... the overrides solution overwrote the home dashboard too, even though in the site map object it points to the home dashboard in the original project solution. I thought maybe it's because both the report and home site maps are using the same URL (/workplace/home_dashboards.aspx) but couldn't find anything to support that was wrong. Any ideas?
this helped me so much david thanks so much !
most welcome varzy 😊😊