Re: Excel Community Medicine 181.pdf
Lorean Hoefert
Hello, I oversee licensing and credentialing for facilities and personnel within my company over several sites. I currently have that in an excel workbook with separate sheets feeding into a consolidated report page. We have some personnel in other departments that need the info, but can't have access to the full file. I usually manually print a copy of the report sheet, save it as a PDF, and then email it to the team members.
I'd like to automate the process with a flow, but I don't see how to extract JUST the single sheet with the "Get file" options. I am also comfortable enough with adding VBA to the file if that would help, I just don't know how to combine that with the flow if that would be a possibility.
I didn't have the sheet in a Table previously, but after reading your comment I determined that there is no negative impact on the data or the layout if I create a table format that is based on the current style, font, colors, etc. I'll give it a go from there.
Without pasting in a handful of links, there are lots of tutorials to create a new file, create a new worksheet, create a table, add rows to a table, looping through the original table data - but overall that's one way of doing it.
We are excited to announce the "The Copilot Cookbook Community Challenge is a great way to showcase your creativity and connect with others. Plus, you could win tickets to the Power Platform Community Conference in Las Vegas in September 2024 as an amazing bonus. Two ways to enter:1. Copilot Studio Cookbook Gallery: _Copilot_Cookbook_Challenge2. Power Apps Copilot Cookbook Gallery: _Copilot_Cookbook_Challenge There will be 5 chances to qualify for the final drawing:Early Bird Entries: March 1 - June 2Week 1: June 3 - June 9Week 2: June 10 - June 16Week 3: June 17 - June 23Week 4: June 24 - June 30 At the end of each week, we will draw 5 random names from every user who has posted a qualifying Copilot Studio template, sample or demo in the Copilot Studio Cookbook or a qualifying Power Apps Copilot sample or demo in the Power Apps Copilot Cookbook. Users who are not drawn in a given week will be added to the pool for the next week. Users can qualify more than once, but no more than once per week.Four winners will be drawn at random from the total qualifying entrants. If a winner declines, we will draw again at random for the next winner. A user will only be able to win once. If they are drawn multiple times, another user will be drawn at random.Prizes: One Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value, does not include travel, lodging, or any other expenses)Winners are also eligible to do a 10-minute presentation of their demo or solution in a community solutions showcase at the event.To qualify for the drawing, templates, samples or demos must be related to Copilot Studio or a Copilot feature of Power Apps, Power Automate, or Power Pages, and must demonstrate or solve a complete unique and useful business or technical problem. Power Automate and Power Pagers posts should be added to the Power Apps Cookbook. Final determination of qualifying entries is at the sole discretion of Microsoft.Weekly updates and the Final random winners will be posted in the News & Announcements section in the communities on July 29th, 2024.Did you submit entries early? Early Bird Entries March 1 - June 2: If you posted something in the "early bird" time frame complete this form: _Challenge_EarlyBirds if you would like to be entered in the challenge. Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. @Mathieu_Paris 1. @SpongYe 2. n/a2. @Deenuji 3. n/a3. @Nived_Nambiar 4. n/a4. @ManishSolanki 5. n/a5. n/a Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. Kasun_Pathirana1. ManishSolanki2. cloudatica2. madlad3. n/a3. SpongYe4. n/a4. n/a5. n/a5. n/a Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. Parul_Yadav_Neo1. n/a2. SpongYe2. n/a3. n/a3. n/a4. n/a4. n/a5. n/a5. n/a
We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for. We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer. Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together. Here's to new beginnings and endless possibilities! If you have any questions, observations or concerns throughout this process please go to To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages
Calling all Super Users & User Group Leaders UPDATE: We just wrapped up June's Community Ambassador monthly calls for Super Users and User Group Leaders. We had a fantastic call with lots of engagement. We are excited to share some highlights with you! Big THANK YOU to our special guest Thomas Verhasselt, from the Copilot Studio Product Team for sharing how to use Power Platform Templates to achieve next generation growth. A few key takeaways:Copilot Studio Cookbook Challenge: Week 1 results are posted, Keep up the great work!Summer of Solutions: Starting on Monday, June 17th. Just by providing solutions in the community, you can be entered to win tickets to Power Platform Community Conference.Super User Season 2: Coming SoonAll communities moving to the new platform end of JulyWe also honored two different community members during the call, Mohamed Amine Mahmoudi and Markus Franz! We are thankful for both leaders' contributions and engagement with their respective communities. Be sure to mark your calendars and register for the meeting on July 11th and stay up to date on all of the changes that are coming. Check out the Super User Forum boards for details. We're excited to connect with you and continue building a stronger community together. See you at the call!
Markus Franz is a phenomenal contributor to the Power Apps Community. Super Users like Markus inspire others through their example, encouragement, and active participation. The Why:"I do this to help others achieve what they are trying to do. As a total beginner back then without IT background I know how overwhelming things can be, so I decided to jump in and help others. I also do this to keep progressing and learning myself."Thank you, Markus Franz, for your outstanding work! Keep inspiring others and making a difference in the community! Keep up the fantastic work! Markus Franz LinkedIn Power Apps: mmbr1606
Has anybody used this health dashboard- as it is for testing your implementation and your data governance, auditing and QA efforts as well as all variables, success events/metrics hits/instances for the whole suite. It is very helpful because it has some kind of anamoly detection built in it with confidence interval testing for custom success events extending past 100 as well as the evars and props. It also populates an email screenshot and uses outlook via a macro from the trigger of a button for creating an alerts email. I love this doc but it takes about 15-20 mins to run and we have about 20 different sites/report suites and it is not ideal for all of them.
A couple problems here:
1) it seems to freeze or break at any point when it is running after you click "run dashboard" to audit your report suite. I can't or dont know how to debug this to see where it is occuring - if it is some kind of setup/configuration I have (bc I haven't manipulated much of it other than the checkboxes to extend the variable auditing) and can't tell if its the API/server and the reporting Que backed up causing the freeze/stop or if it is something on my computer as it uses a significant amount of ram.
2) since our sites aren't identical in the implementations due to the features we have on our sites that are setup for tracking- we can't use the global report to see if any anomalies are detected unfortunately or else I would be using the global roll-up to then isolate and see where the breaks/anomalies are present and which site to go and dig deeper to fix any inconsistencies found- so I have to run all 18 of these dashboards.
3) Because of the lag/freezes- when I set it up with a vbs script to run and windows task scheduler, it then stops on one report and any other reports that i have scheduled to run later in the day don't run because of that one report that froze because it doesn't close it out so another can continue forward to run later in the day. So this freeze problem that happens within the sheet when it seems to break is causing all of the headaches I have. I'm wondering if there is a known issue and way to fix this but also if not- if theres another way to simply audit all sites implementations - that is all inclusive and as detailed as this report as it is very helpful and i prefer it as I can find a way to get the automated email alerts setup with some other scripts to email me accordingly. I want to get it all automated at some point but this one problem is holding up a lot of progress I've been trying to gain traction on.
Any help would be greatly apprecaited. Really all I have done is tried a few troublshooting steps - I just open the doc- enter my client id and secret and check all three checkboxes and hit run report and clear out the old report- right after that is when it freezes after I "run dashboard" macro by clicking the button. I've tried loading report builder before because it seemed to run better I noticed if you login to report builder add-on first in excel, and I've attempted to see if a self-signed certificate would help but nothing. And to note- it happens in both manual and automated operations so really there isn't much to go with on it or any detailed instructions as to what I can do to make it run more efficiently and not freeze or any FAQs on it in particular. Most of the instructions just show how to set it up and then run it and that's it. I had to figure out the vbs script to open it and run the macros myself with task scheduler. Thanks in advance. I'll try and attach the zip file I got with the report template and insructions if anyone would like to see it but I'll need to check with adobe I think as to the permissions and sharing it with the community as I'm not sure if it is allowed yet. Thanks!
b1e95dc632