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.
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.
Hi Paul github.com/dtsoden/RU-vidVideos 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!
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....
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?
True and valid point: Won't be doing a video as I no longer offer these services. However, here is what to do... The nuclear restore: You can get the Akeeba Core backup for free - backup as shown in the video then download the backup file "*.JPA". Then also download the kickstart with the JPA file to fully restore the entire site to a new server or the same server after you have a clean server... get that here... www.akeeba.com/download.html#kickstart. Upload the JPA file and the 2 kickstart files. in a browser hit yoursite/kickstart.php to begin the restore wizard. **PS: I also use this approach to migrate the sites to a new server - or host IN APP RESTORE/ROLLBACK: if you simply want to restore from a previous restore, because say you messed up then use the restore option on the software to restore or rollback the site. I have used these approaches for over a decade - starting with Joomla and later moved to WordPress keeping with Akeeba. IME it works and I trust it. Pick what's right for you.
POE and GPT are not the same. While GPT is a language model developed by OpenAI, POE is a platform that allows you to connect with different language models, including ChatGPT, GPT4, and Sage by OpenAI, as well as models developed by other companies such as Claude, Claude Plus, Claude Instant 100K, and more.
This is so helpful. I was using varRecord for an item selected from a gallery and then using that variable as the source in another gallery to edit the fields of the record. My problem was that varRecord didn’t update with any changes so after every patch I had to use Set to update var Record again so those changes could be reflected in other controls, notifications, etc. Your wrapping method appears to be much more efficient. Thank you! Is there any risk in your example that the ID of the new record wouldn’t be created and returned fast enough to use that ID in an email notification from your save control?
Thanks. There is always the possibility that something can go wrong. Not likely as it's sequential but it is a platform. Consider adding ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iKtNb9UWS-k.html
I just checked and it seems to have loaded fine with sound on my phone. Perhaps it's your internet browser or RU-vid's having a problem? Anyway, I'm sorry you're having a problem. I can't see anything that I can do on my end to fix it.
The CORE difference the way I think of them is "isEmpty()" really means something like this "isTheTableEmpty" and is damn near to using If(CountRows(TableName) = 0,true,false); whereas "isBlank()" can be used on just about everything else like variables and controls properties to see if there is a value or not.
Great video David. At 21:10 people have been creating on premises data gateways with around 15 created. I was told there should only be 1 or 2. Can you advise re this please
I re-watched my video around the timestamp provided 2x and went even further back. The question your asking, I can not apply the context of the video to it. " People have been creating on premises data gateways with around 15 created." I did not state 15 of anything in and around this timestamp. You question the number of 15 stating only 1 or 2. Since I do not know what 15 is, I do not know how to address your question. 15 of what? I then went to youtubetranscript.com/?v=PvsiVuaU5G8 and search for 15 in the transcript. I mention $15 earlier regarding the licensing - I'm just at a loss. Apologies.
@@DavidSoden hello apologies for the confusion i was meant to say “people in my org have been creating on premises gateways in the power platform and there are 15” I guess to put it simply is there an issue having lots of on premises gateways in the power platform
I've not heard of limits like this as this can be clustered learn.microsoft.com/en-us/data-integration/gateway/service-gateway-high-availability-clusters That said there are issues with it being a pig sometimes and needing to tweak things learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance-cpu
Honestly not sure, I have not tried. if column is of type attachment, perhaps. if just an image url - aka text for sure yes. if somehow exists in a document library, likely not, but I do not know as I've not tested these specific senarios.
Just navigate to "Settings". hunt in the top menu area where " File / View / Inser" use to be (look for elipsis icon at end of the row) or bottom left of the designer screen - and very small - settings cog icon above the robot icon "ask a virtual agent"
Try editing the swager defition of the connector by toggeling the swager switch and editing just the area where the name appears that you want to rename. If it does not fully take. Copy the FULL Swagger. Delete the connector and make a new one by pasting in the swagger that has the proper name. (warning you will break anything using that connector and will have to fix anything using it so best to notate this first). IMO - I would leave well enough alone in a production environment unless your company is forcing you - if its a personal lab - go for it but do your homework to avoid headaches.
@@laura8363 make sure to clear the browser cache or use another browser to make sure its not a caching issue after flipping the switch. Also try the PowerShell option to force the change to happen immedialty. If this does not work then something has yet again changed and I would have to investigate this where the issue is happening to know more.
I didn't change the settings, they were already set to allow when i checked (no one else would be changing these settings). must be some other issue, classic MS @@DavidSoden
Hi David, I'd like to know about a scenario. I have a PowerApp which is connected to multiple flows in which one or two is using File System connector in PowerAutomate. What I am going to do with this File System connector is, create file in local folder by getting data from PowerBI / SharePoint list etc; I have more than 100+ users and I have a Data Gateway configured in a server PC which is signed in using my login credentials. I'd like to know, how I can utilize this Data Gateway for connecting the File System inside the flow for all 100+ users ( none of the user except the flow owner owns a premium license )
perhaps consider an approach like ... learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/manage-list-flows#managing-run-only-users and you may have to tinker with folder permissions too.
The script works great. Is it possible to change the challenger type from DNS to http. This would help when generating a certificate using free DNS platforms such as DuckDNS. Where a TXT entry can only be made for the created domain name and not for the required subdomain starting with _acme-challenge.XXX.XX. More precisely, I would like to be authenticated by let's encryp using my IP address
How would you write multiple input fields to table 1 (e.g. first name, last name) and then multiple input fields to table 2 (e.g. email and phone number). But then also multiple fields to a tabel 3 (e.g. company) that is only connected with table two through a foreign key? We would need to save multiple ID's while patching. How does that work?
When you make a normal patch patch statement wrie fields you need - but - simply do it inside a SET variable function to capture the result or the return info resulting from the PATCH. This variable will hold record including the Primary Key resulting from that patch if DEFAULTS was used in that patch. Use this variable name and the dot notation to get to the primaryKey. If my Table was named FOO and my variable was MyVar it would look something like MyVar.Foo. With that you can then use it in the next patch to assign/write a foreign key value or use the entire record if the data source is looking for that. You can then use this technique again and again for multiple repeated/related tables. you just need to know the hierarchical flow in which table needs to go first then second, third and so on.
do you know how to use the Power Platform Command-Line Interface? learn.microsoft.com/en-us/power-platform/developer/cli/introduction if so, you may unpack the canvas *.MSAPP to go line by line through some of the JSON and YAML files and alter or add code. Usually I create a new blank app, download the *.MSAPP file to use as a master source then download an app that as an issue to compare one vs the other using something like winmerge.org. Sometimes I copy the bad app as a new app and remove all the objects and screens except 1 blank one. This removes a crap load of extra code and files. Then do the comparison on those (new base app, and the copied stripped down app [both downloaded as *.msapp's]) and unpacked with the PP CLI to see what is different. If this is NOT a critical app for you, then it's way more trouble than it's worth, but you can do this to recover an app and it is faster than recreating an entire app from scratch.
AFAIK you can not. it's cached. The control needs to be resettable to allow that. Not sure why or how that would matter? Meaning to wipe out the last address in memory of the control, as it will be wiped once you search a new address. Typically, one would build a collection for addresses looked up then use that with the map control or use that data to enrich existing data. you could remove rows from the collection as needed.
