User
Write something
Saturday Live Stream is happening in 3 hours
Word Cloud Concept
In the workshop today (16 April) we talked about a word cloud. I gave a small description on how you could possibly do it, but wanted to get some additional thoughts, because it was an amazing idea. My basic thoughts for beginner word cloud concept is this. Create a gallery that expands the size of the screen you want it. In this case I am pulling from another app I have built so its a full screen gallery. I currently have an SharePoint list where I have three main columns (XCoord, YCoord, and Word Cloud). I currently have the XCoord and YCoord manually set, but this is where this groups hive mind could probably do same amazing things. Keep in mind the XCoord and YCoord are based on the position of the screen. So if you gallery is 50w x 50h you would be able to assign the X and Y values between 0 and 50. In this case I select my Label and set the label X value to ThisItem.XCoord and the Y value to ThisItem.YCoord. This is how it moves the label around the screen in a word cloud format. My quick thoughts. 1. Try to show only the Distinct Items. 2. Create a formula to count the number of distinct values and change the font size based off this count. 3. Dynamically create the XCoord and YCoord. 4. a. This would probably need some tweaking. Maybe put the largest count centered. Set the other X and Y to be based off this. Maybe have some sort of detection built in to make sure there is no "Collisions" 5. Set the onSelect to make that work a variable. Now have your other gallery filtered off that variable.
3
3
New comment 22d ago
Automatic Currency Conversion / Inflation Calculator
@Darren Neese / @Kurt Larson : If you've already covered something like this in a previous tutorial, please can you direct me to the link? If not, then I have a 'Suggestion for New Content' request: ===== FIRST REQUEST ===== I'm building a contract management solution (in SharePoint) which will record contract values - as at the date the contract was awarded. Is it possible to connect to an online currency conversion tool, via a Power App that will automatically convert the contract values to any selected currency? An example use case would be when the contractor is submitting a proposal for work in a different country and needs to include examples of previous work completed, but is required to reflect contract values in the currency of that country. NB: The currency would need to be converted as at the date the contract was awarded, i.e. not today's date. I found this free embeddable widget tool, but not too sure how it could be applied within a Power App or how/if I can connect it to my table of contract values: https://www.oanda.com/foreign-exchange-data-services/embeddable-currency-converter-widget/ I also found a few tutorials for live currency converters set up via an Excel spreadsheet, so could possibly link to an Excel spreadsheet sitting in a shared location in the background? e.g. https://www.youtube.com/watch?v=onjlQNE-dFY - but hopefully there's a more efficient way (which is also free of premium licensing). ===== SECOND REQUEST ===== A further add-on to the above request is to be able to build some kind of "Inflation Calculator" into the system that would convert a historical contract value to a value relative to today's economy. e.g. If the contract value in 2005 was $10,000 then in 2024 that contract would be equivalent to about $16,000 now. (Ref: https://www.in2013dollars.com/us/inflation/2005?amount=10000)
4
6
New comment 24d ago
Managed Environments
We have a lot of different Microsoft Teams groups throughout our organization and in some cases multiple Teams may want to use the same application, but with different data (internal to their team). Knowing how to publish and app inside of different teams, but than be able to push updates to each app after changes are made with be helpful.
1
1
New comment 24d ago
Workshop Topic for This Friday - Ideas?
Last Saturday, I mentioned that this week we would cover planning & design for Power Apps projects. It turns out there wasn't as much interest in that as I thought. I'm looking for ideas from you guys again! 😂😭🙏🙏 https://www.skool.com/power-apps-community/power-apps-workshops
Complete action
0
4
New comment Mar 1
Drag & Drop Tasks
I’ve done a lot of research over the last 9-10 months on solutions to queries I have in Power Apps. Some of which were probably too advanced for my skills at the time. Nevertheless, I followed guidance on YouTube and eventually modified what I saw to work to my needs. I probably didn’t understand why it was working but I made it work. I then came across @Darren Neese and the Learn Power Apps community. There is so much useful information and guidance offered that I recently purchased the PPC course to advance my knowledge. That brings me back to why I’m posting. One thing I would like to see on the channel is a solution to dynamically drag and drop for tasks. i.e. having a list of tasks/jobs that I can drag and assign to a user/time slot just like scheduling our production or maintenance jobs. I found a really good solution by Scott Durow where he provided a component which allowed me do it (link below). https://youtube.com/playlist?list=PLhgOm-Jpmt82JvLdJFx3Zqo89h_deWJQF&si=Iioh8BXLOVnosTqz It was fairly in depth and took me a lot of time to get up and running, but I did get it working, well sort of. I could drag and drop my tasks but could not figure out how to get the Patch back to my datasource to work as I was trying to adapt his instruction to my app needs. Like I mentioned earlier, I was probably trying to achieve something far too advanced for my understanding at the time. If I looked at it again, I may stand a better chance of achieving the final goal of saving my drag and drop changes. Is it possible to come up with a solution that achieves a similar result without the need for installing the components that Scott provides? It’s a big ask but, if I’ve learned anything, you have to think a bit out of the box and that’s what this community and its contributors do best.
1
3
New comment Feb 27
1-13 of 13
Public group
A community of people who are enthusiastic about and trying to learn about Microsoft's Power Apps!
Leaderboard (30-day)
powered by