2 сағат бұрын
2 сағат бұрын
2 ай бұрын
3 ай бұрын
4 ай бұрын
6 ай бұрын
8 ай бұрын
8 ай бұрын
8 ай бұрын
8 ай бұрын
Пікірлер
@sebastiaanvanvugt1761 3 күн бұрын
Absolutely great video. How do you manage to open the msapp file from Windows Explorer though?
@DavidSoden 2 күн бұрын
@@sebastiaanvanvugt1761 it's just a zip file. Change extension to open. Or use power platform CLI to unpack
@Joe-b9c 9 күн бұрын
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 :)
@mas5867 21 күн бұрын
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.
@hadar17289 27 күн бұрын
Thanks for the video. how can I order the columns in the excel?
@DavidSoden 26 күн бұрын
Have you tried the sort(), in front of the showcolumns().
@iraira8561 Ай бұрын
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
@DavidSoden Ай бұрын
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
@iraira8561 Ай бұрын
@@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.
@jennusi8317 Ай бұрын
I cant see this option in the current version. Help!
@DavidSoden Ай бұрын
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.
@r.zainalarifinfandisaputra Ай бұрын
Hi David, is there a way to deactivate relation with the project for web ?
@DavidSoden Ай бұрын
@@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.
@r.zainalarifinfandisaputra Ай бұрын
@@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
@bugz1124 Ай бұрын
so pipeline does not exist that time? looks painful to transition from DEV to PROD
@DavidSoden Ай бұрын
correct, did not exist, ADO and or PP-CLI were the main options past manual.
@CuongDangQuoc-q8t Ай бұрын
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.
@DavidSoden Ай бұрын
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.
@DavidSoden Ай бұрын
Manual - drive.google.com/file/d/10ulVANnFEw2gwfk2KliQdfyRiMLOC29s/view Report - lookerstudio.google.com/reporting/3e672222-4bee-4a9d-9e36-d93aa3b6ee7b Link Builder - utm.transformationleaderspodcast.com/Form
@marti0 Ай бұрын
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
@DavidSoden Ай бұрын
Which mobile platform? iOS is more finicky over Android IME
@DavidSoden Ай бұрын
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
@marti0 Ай бұрын
@@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."
@DavidSoden Ай бұрын
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.
@DavidSoden Ай бұрын
@marti0 I received word from Microsoft that this has been resolved. I build a basic test app which is now working.... github.com/dtsoden/KZbinVideos/tree/main/NFC_Testing_App
@iswired4sound Ай бұрын
This only works if you have less than 100 rows? What happens when there is more than that?
@DavidSoden Ай бұрын
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.
@a1t0rmenta Ай бұрын
Thank you. Very helpful.
@DavidSoden Ай бұрын
Thank you!
@JasonMADCow-j4n Ай бұрын
Thanks a million. I don't have the view options, so this was really helpful!
@DavidSoden Ай бұрын
Thank you!
@GeorgiaDigitalProfiles 2 ай бұрын
Great Video!
@DavidSoden 2 ай бұрын
Thank you!
@robbolles4742 2 ай бұрын
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
@Pradeep2722 2 ай бұрын
Great Video . 👍
@DavidSoden Ай бұрын
thanks!
@belindabosman3678 2 ай бұрын
Excellent tutorial. Thank you. Are multiple separate customised PMO Accelerator projects possible on the same environment?
@DavidSoden 2 ай бұрын
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.
@DiveSafariNZ 2 ай бұрын
Wow, good to know, before I watched this I would of made each table a separate named formula.
@DavidSoden 2 ай бұрын
Glad it helped.
@zenobiusztasak8604 3 ай бұрын
how to generate a certificate for the ip address and port ?
@DavidSoden 3 ай бұрын
--domains "<<Your Domain>>" :"<<Your Port>>"
@FzR123 3 ай бұрын
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.
@DavidSoden 3 ай бұрын
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. 😁
@jasonswami9275 3 ай бұрын
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
@davidjimenez8952 3 ай бұрын
master piece of productivity
@DavidSoden 3 ай бұрын
Thanks for the kind words 😊
@davidjimenez8952 3 ай бұрын
awesome!
@DavidSoden 3 ай бұрын
@@davidjimenez8952 thanks man
@Mx81 3 ай бұрын
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.
@josephdsilva4941 3 ай бұрын
Very useful, great help, thanks
@DavidSoden 3 ай бұрын
Thank you, glad it helped in some way.
@janardhanansgm521 3 ай бұрын
Fantastic 🎉
@DavidSoden 3 ай бұрын
Thanks, Janardhanan
@r.zainalarifinfandisaputra 4 ай бұрын
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 ?
@DavidSoden 4 ай бұрын
@@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.
@r.zainalarifinfandisaputra 4 ай бұрын
@@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 ?
@DavidSoden 3 ай бұрын
@@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.
@r.zainalarifinfandisaputra 3 ай бұрын
@@DavidSoden I see, well noted David, thank you very much for your help.
@jadha_ravi 4 ай бұрын
Excellent video, learn lots of things, #developer ♥️
@DavidSoden 4 ай бұрын
Thanks for the kind words ☺️
@andre1787 4 ай бұрын
Awesome
@DavidSoden Ай бұрын
thanks
@pablogallucci2264 4 ай бұрын
ops..I saw #5....so i should not use anymore onprem gateways?
@DavidSoden 4 ай бұрын
see above as this is likely all related
@pablogallucci2264 4 ай бұрын
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!!
@DavidSoden 4 ай бұрын
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 ;)
@Jpoorsis 4 ай бұрын
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?
@DavidSoden 4 ай бұрын
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
@karensuits9482 4 ай бұрын
I am looking for a contact number for AI Revolutions having difficulty getting signed up.
@deborahjoyous 4 ай бұрын
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!
@DavidSoden 4 ай бұрын
Do you have global admin rights? Can you find someone with these if not?
@deborahjoyous 4 ай бұрын
@@DavidSoden, yes I do have global admin rights...
@DavidSoden 4 ай бұрын
@@deborahjoyous looks the same for me here so it may be something different on your tenant. Try opening a ticket with Microsoft?
@deborahjoyous 4 ай бұрын
@@DavidSoden, will do. Thanks!
@deborahjoyous 4 ай бұрын
@@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!
@patrickharilantoraherinjat2994 4 ай бұрын
Great video! thank you
@DavidSoden 4 ай бұрын
Thanks for the kind words 😊
@BenjaminDietz 4 ай бұрын
Does this method maintain the IDs in the list after import?
@TransformationLeadersPodcast 4 ай бұрын
IME yes the ID column and values matched
@Cody-b7b 5 ай бұрын
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!
@DavidSoden 5 ай бұрын
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.
@Cody-b7b 4 ай бұрын
Thank you David!
@dariusf2 6 ай бұрын
Thats awesome, glad I ran in to this.
@DavidSoden 4 ай бұрын
Thanks for stopping by. Glad it helped.
@pauldigerolamo1084 6 ай бұрын
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?
@DavidSoden 6 ай бұрын
Hi Paul github.com/dtsoden/KZbinVideos 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?
@pauldigerolamo1084 6 ай бұрын
@@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.
@DavidSoden 6 ай бұрын
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.
@pauldigerolamo1084 6 ай бұрын
@@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!
@DavidSoden 6 ай бұрын
@@pauldigerolamo1084 Glad this helped. and apologies again.
@youngdataio 6 ай бұрын
Nice tutorial
@DavidSoden 4 ай бұрын
Thanks
@yinkaishan 6 ай бұрын
Hello, thanks to sharing this. when I try to import solution, it failed to import, can not move to next. any one how how?
@DavidSoden 4 ай бұрын
Sorry I missed your comment. What is the specific error you are getting?
@cimarr0nargent0 Ай бұрын
@@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.
@ashalan5233 6 ай бұрын
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....
@DavidSoden 4 ай бұрын
Two things are a must. PAL association and owner. Not sure about disabled status. Gut says no. You'd have to test that.
@serieslimited9064 6 ай бұрын
Very useful piece.
@DavidSoden 4 ай бұрын
Many thanks!
@ronbakker1300 7 ай бұрын
Thanks David, definitely going to need this sooner or later. I really like these shorter videos that don't cook my brain.
@DavidSoden 4 ай бұрын
Glad to help
@EasyProj 7 ай бұрын
Awesome!
@DavidSoden 4 ай бұрын
Thanks!
@JasonGraham-qr5il 8 ай бұрын
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?
@varzywarzy6793 8 ай бұрын
this helped me so much david thanks so much !
@DavidSoden 8 ай бұрын
most welcome varzy 😊😊