Great Video tutorial. Even now it's still up to date and useful when u don't create too many Power Apps and want to refresh knowledge about functionality. I miss here only the topic about creating own collections. :)
Dude, great video. I started messing with charts last week, and kept looking for features that weren't there. Hopefully Microsoft keeps improving it instead of de-scoping charts like they did with Access.
Great Video Shane - very helpful. I am new to Power Apps Canvas - having used Model Driven development in the past, and I am enjoying exploring Canvas features (or not) lol. I find it frustrating, as i know what (I want it to do - but often can't find the way to do it. That's where your videos have proved really helpful. Thanks 🙂 A quick question for you? I'm developing a small app to collect Applicant details and then their submissions of Art-works to a competition. So, each applicant can have 1 or many Art-work submissions. The first part of the Canvas APP collects their Application details and uses (Patch) to update them to the Applicant Dataverse table. The next screen collects their Art-Work details (and repeats this process to a maximum of three entries). However, each separate Art-work submission (Dataverse record) needs to be linked to its Parent Applicant record using the previously entered (under Application Form) SURNAME. I currently show the ART-Work record Lookup Field from Art-Works record on the add Art-Work screen - but not sure how to set the lookup USING the SURNAME entered in previous screen? I can display the previously entered surname on the add Art Work form - but not sure how to ensure its (USED) by the lookup field and therefore ONLY ever returns the matched name . The alternative at the moment, is showing all applicant names and requires USER to chose their name from the list . Not ideal lol. 🙂 Any thoughts are welcome. I'm enjoying using Power Apps canvas having developed software in the past using Oracle, Cobol and yes Vax Basic lol 🙂 Revealing my vintage Lol Any ideas welcome . Thanks Shane.
Without BI in our subscription thank you very much just came back for a refresh before starting a new app which needs to be more visual than previous. Last time I built some fairly snazzy graphics just on setting location, size and colour of objects... All which expanded based on a timer. Behind the curtain its very cheap, but worked effectively. I'm going to need to use charts on the next one though! I like the idea of using the on select to either expand the size of the chart, and select items to potentially go down a level in granularity.
Thanks again Shane. I have a column in my list that counts down days from today's date to a Client check out date. It dynamically updates based on what day it is. (Also go that from you) Is there any kind of if statement that I could use to only chart the records that hit 7 days or less? It's turning my head inside out trying to even think about how I would write that. I'm trying to figure out a dashboard or email flow that will alert users when the days until checkout hits that 7 day threshold.
I would think flow for this problem. Get Items action using an oData query where you get items that column is less than 7. Very much like this video ruclips.net/video/qGqqQjGMun8/видео.html
Excellent video as usual Shane. A pie chart would be handy to identify a range of items which are below an acceptable level. Clicking the slice to further break apart what items are in the "too low list". Useful for a quick visual of a stock items status. ie no items in the red slice so nothing to order. Items in an orange slice is getting to reorder point... items in red are at or below reorder point.
If Power Apps knows the data is changed. So if a gallery would have refreshed then yes the chart would have refreshed. But the chart itself isn't looking for changes.
@@ShanesCowsI had a similar question. I have a gallery and a chart on the same page. My button to refresh the chart runs a clear collect to gather the data that I need and summarize it and it works very well for the chart. My issue is that when I add or delete an item from the gallery via a form I added the clear collect into the unsuccess but it is not updating the charts. Do you know how I can get that chart to automatically update based on the gallery being updated? I have not been able to figure out that trick
Hi Shane! you videos' have been amazing. I have a question with date inconsistency with PowerApps date picker especially when it is been displayed on different device with different keyboard language setup. What solution can be used?
Hi Shane, I have bit different case, I have 2 data sets, 1: full Table with all possibilities per person. (Upload form) 2: Table where the Upload form is sending the data to. Now my first Table is 100% and the 2nd table the % depends on the upload form already done. I wish to create a chart where it will show that for specific Country the upload was done in XX% So how I would approach in comparing those datasets using a chart?
Radoslaw you will have to get them into one collection. So imagine you are going to ForAll through the first collection to find the amount from the second collection and create a 3rd collection that has your results. Then you would show the 3rd collection. I hope that makes sense.
@@ShanesCows Currenlty I dont understand it, I mean I just started with Power apps, and I cant even figure out why 3 dependent comboboxes needs 3 different formulas to send selected items into excel Concat(C1.SelectedItems, Result, "; ") Concat(C2.SelectedITems, Value, "; ") Concat(C3.SelectedItems, Value & ": ") instead of 1 formula .... So c sadly taking about collections and data import to visualize send input Vs the "100% input" is kinda hard now. Do u have a video maybe with this ? or maybe could u make 1?
Hi Shane thx for the vids... Is there any way to filter the data based on the user logged in? I am looking to build a sales dashboard using an excel file as data source. However I would only want to share to each individual user their sales and target amounts. Thank you!
Hi Shane, thank you for your helpful videos. I have a query: I have a pie chart that uses choice column and i want to filter it. i have a search box there if i type 2022 the piechart should show the result with year 2022 in it. Can you help me with this. Thank you once again.
Is there any way to control the space assigned to the labels of a chart? There is very little space by default and all my labels are cut. If only it was possible to force them to be multi-line text or to give them a bit more space...
Hi Shane. Thanks so much for all your videos, you are a fantastic teacher! Is there a way to sum numbers per month fx and then show them as one column or one dot in a line chart. If I have 1. feb, 120, 2. feb, 100, 3 feb. 200 I like to have only one dot for the feb with the sum 420 and so on for all the months, but I can't figure it out. And now it is the third time I like to have this kind of charts, so I hope you are my luck again :-) Thanks in advance!
Hello and thank you for the inspiring videos. I am attempting to create a chart using your instructions where I want to group Departments into blocks. However, I am not getting very far as my columns are missing. It only shows "Field1, Field2, and so on. It does connect to my Sharepoint table i can see. Erlier in the app, the columns appear as they should. This is on Screen3. Google nor ChatGTP4 have given me any answers, praying for you now :)
Nice video! I would also be nice if you could add a video of how to make a inventory list. I would like to keep track of the hardware that is borrowed and used in the company. And maybe make a reservation for a specific hardware item for a period of time if it is available.
Another great video. One question from me - at the end when you added a gallery to show the department members, could you have used the DATA from the collection you created? Just wondering if it's more efficient to build the collection once and then use it in more than one way.
Thanks a lot Shane. Just one question, about the delegation.. using your data, if I want count people in each dpto... im using CountRows at the final of my sintaxe.. but still limited to delegation. Any workround.. my data has more then 2000 itens? AddColumns(GroupBy(Filter(f_BRIEFING_PROD_OBRA;PROP1="Sim");"PROP1";"PROP");"QTD";CountRows(PROP))
@@ShanesCows Shane, i saw that even using GroupBy and Sum.. like you did, still limited to delegation.. 500 rows that could be changed to 2000 max... is it? THere is no way to sum more then this rows?
Thanks for the great video shane, i just created a column chart works good but there is an issue, i have a time tracker sharepoint list where records of 15 people are stored. I want to create a column chart for each person & for every month ( date vs hours) can you please help me , when a person logs into the app he should be able to see only his chart
You will have to find a way to filter the data you are passing to the chart based on the logged in user. Kind of like shown in this video: ruclips.net/video/-VaADTTPYmg/видео.html
Hi Shane! Amazing series! I have a question, I have an Excel based powerapp and I need to be able to copy the data from one Excel row to another excel file, one at a time, from the powerapp. Ideally that action would also delete the row from the initial excel. To be more specific, we are trying to implement this in a hospital, and the powerapp has all our active patients, and we need a button that "discharges"them, and transfers their data to another separated excel file. is this possible?
Run this task with Power Automate (BC Flow) and trigger it from PA. Power Automate has got great actions on Excel (of course these spreadsheets MUST be in OneDrive = online).
Hi Shane I have a case here that I need a Pie Chart to put all Status Reason that I have and counting of each one from a collection that I have created. What you do in a case like this? I have tried, but with no success.
Why can't I see some columns for adding to Labels or Series in the charts? The column that I want to add is a Choice type one, so I don't know why it doesn't appears as selectable
Hi Shane! Thanks for your videos! They're very cool!! I'd like to know if is possible to select an Excel file (by upload) in powerapps and add the data in a exist table in powerapps with other data already exist.
Great Video as usual. I do have one question. I'm working from a Sharepoint online list that has a date, hours worked and a bunch of other data. I create a collection where I can GroupBy Month/Year and then sum the total number of hours worked for the month. But, some months have no hours. So, when I do the GroupBy, that month doesn't exist. When I chart the data by month, of course, that month is left out. Do you have any ideas how to get all the months to show (even when there are 0 hours worked?) (And, thanks for all your videos....without you, I would have given up long ago.)
Great video, Shane! I need help! My SP list is to track daily measurements taken at locations. My powerapps gallery uses a search box to search by location, when the user makes a selection, the graph is set up to display the location of the gallery selection, however, I'd like to graph the last 30 days of activity for that selected location. I also have a dropdown of location and date picker on the graph screen in case the user wants to choose another location (This works on its own: Filter('Sourcename',TestLocation=Dropdown2.Selected.Value,SampleDate>=DatePicker1.SelectedDate,SampleDate
Hi Shane, thank you for your helpful videos. I have a query: Is there a way to add comma separator in Y series of Line chart? I tried using Text function but it ignores all those
Dear Shane, I've been following all your video and its really helpful. Right now, I need to improve my sharepointlist so it could give a reminder email with multiple task that are going to expired within some days using MS Flow. Do you know how to do it? I don't found any helps right now. So, it would be great if you make one. Thank you, hope ypu notice thiz.
Hi Shane, Filtering a gallery via chart selection was exactly what I was looking for, BUT... How do you clear the selection and clear the gallery filter? Reset(Gallery) isn't working. Someone had a slick formula to reset View/Edit via UpdateContext, BUT it didn't clear the gallery filter. HELP! :) I also tried setting a variable, but I couldn't get the variable to capture the chart slection. Used a text label to verify nothing was happening.
Hi Shane! Great video. I'm struggling with the following: I have a column graph which shows spend against different categories (e.g. $100,000 total, of which $20,000 in total spent on category A, $30,000 in total spent on category B etc). However, each of these items in the table shows who spent the money and against what category (e.g., Dave spent $5,000 on category A, Fred spent £15,000 on category A (to make up the $20,000 total spend) etc.) I want the graph to be able to show how much Dave spent against each category by selecting a dropdown and the graph changing. Essentially, I want the chart to change when a person is selected from the dropdown box. I can't for the life of me figure this out. Any help appreciated :)
I wish I had a quick answer but I don’t. 😕 I have someone in my team that does all of the number crunching Power BI things. I feel like it is possible though.
Hi Shane, Great presentation, I subscribed to your channel as a result ;-) I do have a question. I have an excel with kms run by our colleagues, every day people post their achievements which gets into an Excel. It would be nice to show a graphic with the total amount of kms per month (bar chart for instance). Can this also be done with the sum function or is it easier to foresee a extra table in Excel with totals per month?
I have a question, I am using an excel as a data source, which is grouped by a column. When I retrieve the details of a selected column it returns only one row of that group. Any suggestions 🙏
@@ShanesCows I went into the rabbit hole and figured it out. 🙌🏻 Thanks tho😺 Anyhoo, I appreciate you explaining everything so easily. Have been a fan for a while now 😬🤟🏻
Dear Shane, I am still wondering why Powerapps team still not done much of work on Charts in Powerapps. Its really very difficult to even make and edit a simple bar chart. There should be option to make charts as easy as we can do in PowerBI. Thanks for the video, keep up the good work. Can you try making one video on How to join two different apps let say Two Templates together and use it as one app?
I think the reason the Chart Controls don't get improved is because they are already have Power BI. So they don't want to duplicate work. But I don't know. 🤷♂️
@@ShanesCows agreed with you there. They will give ou some basic functionality but for anything else PowerBI. It has been a blocker on several projects in 365 for a while now. Had to resort to going the extra mile and workarounds to display data in SharePoint and soon this way in Powerapps. I did see a demo somewhere on using SVG image files to display data so that is another option. Again way more complicated than just using PowerBI.
Question, I am using a SharePoint list as a data source and trying to group by a lookup column that references a related list. The data shows it as a record but doesn't accept it in the group by. Am I missing something?
@@ShanesCows It doesn't even recognize that the column exist. As a possible work around, is there a way to create a collection that stores the lookup column as a value rather than a linked record. I am using several collections but it looks like the lookup columns are stored as sub tables for lack of a better word.
@@russellhenry951 In the sharepointlist create a calculated column and assign the lookup column (=[status]) here status is a lookup column , now the calculated column listed in the powerapps columns list. use the calculated column for groupby function
I am struggling with Choice fields from Sharepoint Lists. They do not appear for Label/Series selection in the PowerApps Charts, only Text and Number field types. Any clue how do I get this information from the Sharepoint list? I am trying a simple pie chart to show # of records for each picklist value (of Country choice field) but it is not working. I tried using Collection, or manually adding columns and calling "ThisRecord.Country" but neither worked. :'(
Great Video tutorial. Even now it's still up to date and useful when u don't create too many Power Apps and want to refresh knowledge about functionality. I miss here only the topic about creating own collections. :)
This video is a look at Collections if it helps. ruclips.net/video/4zM-Oyhpc3U/видео.html
Super video, and all these extra tips and tricks like AddColumns + ThisRecord, GroupBy, Text formating with currency format, ... You are the best!
Thanks 🤩
Knocking vids out the park this month Shane! Great Work!
Appreciate it! 😎 I will try to keep it up.
Dude, great video. I started messing with charts last week, and kept looking for features that weren't there. Hopefully Microsoft keeps improving it instead of de-scoping charts like they did with Access.
Fingers crossed but they haven’t changed in a long time. 😬
Great Video Shane - very helpful. I am new to Power Apps Canvas - having used Model Driven development in the past, and I am enjoying exploring Canvas features (or not) lol. I find it frustrating, as i know what (I want it to do - but often can't find the way to do it. That's where your videos have proved really helpful. Thanks 🙂
A quick question for you?
I'm developing a small app to collect Applicant details and then their submissions of Art-works to a competition. So, each applicant can have 1 or many Art-work submissions. The first part of the Canvas APP collects their Application details and uses (Patch) to update them to the Applicant Dataverse table. The next screen collects their Art-Work details (and repeats this process to a maximum of three entries). However, each separate Art-work submission (Dataverse record) needs to be linked to its Parent Applicant record using the previously entered (under Application Form) SURNAME.
I currently show the ART-Work record Lookup Field from Art-Works record on the add Art-Work screen - but not sure how to set the lookup USING the SURNAME entered in previous screen? I can display the previously entered surname on the add Art Work form - but not sure how to ensure its (USED) by the lookup field and therefore ONLY ever returns the matched name . The alternative at the moment, is showing all applicant names and requires USER to chose their name from the list . Not ideal lol. 🙂 Any thoughts are welcome.
I'm enjoying using Power Apps canvas having developed software in the past using Oracle, Cobol and yes Vax Basic lol 🙂 Revealing my vintage Lol Any ideas welcome . Thanks Shane.
Without BI in our subscription thank you very much just came back for a refresh before starting a new app which needs to be more visual than previous.
Last time I built some fairly snazzy graphics just on setting location, size and colour of objects... All which expanded based on a timer. Behind the curtain its very cheap, but worked effectively. I'm going to need to use charts on the next one though!
I like the idea of using the on select to either expand the size of the chart, and select items to potentially go down a level in granularity.
Awesome. I hope you blow your users away with the cool stuff you build.
Thanks Shane. Love the GroupBy drive by too, it’s just what I need.
Right on! Always trying to sneak in little nuggets.
Great video, thank you so much for your detailed approach in troubleshooting
No problem! Have a great week.
Thanks again Shane. I have a column in my list that counts down days from today's date to a Client check out date. It dynamically updates based on what day it is. (Also go that from you) Is there any kind of if statement that I could use to only chart the records that hit 7 days or less? It's turning my head inside out trying to even think about how I would write that. I'm trying to figure out a dashboard or email flow that will alert users when the days until checkout hits that 7 day threshold.
I would think flow for this problem. Get Items action using an oData query where you get items that column is less than 7. Very much like this video ruclips.net/video/qGqqQjGMun8/видео.html
Thank you for this amazing content, it is full of useful information.
You're very welcome!
VERY Helpful! Thank you Shane!👏🏾👏🏾👏🏾
Hi Shane, very informative. Thank you. How to scale x axis if we want to plot whole year data daily basis but i want plot only 1sr date of each month.
Excellent video as usual Shane. A pie chart would be handy to identify a range of items which are below an acceptable level. Clicking the slice to further break apart what items are in the "too low list". Useful for a quick visual of a stock items status. ie no items in the red slice so nothing to order. Items in an orange slice is getting to reorder point... items in red are at or below reorder point.
😎 always so much fun 😎
increibles tus videos, muchas gracias desde Colombia
De Nada Diana 🐶
Hi Shane, another great video. A question: Do these charts auto-refresh if there's a change in data in the data source such as a SharePoint list?
If Power Apps knows the data is changed. So if a gallery would have refreshed then yes the chart would have refreshed. But the chart itself isn't looking for changes.
@@ShanesCowsI had a similar question. I have a gallery and a chart on the same page. My button to refresh the chart runs a clear collect to gather the data that I need and summarize it and it works very well for the chart. My issue is that when I add or delete an item from the gallery via a form I added the clear collect into the unsuccess but it is not updating the charts. Do you know how I can get that chart to automatically update based on the gallery being updated? I have not been able to figure out that trick
Hi Shane, Thankyou for your helpful videos. I have a query that can we use Stack Chart in Powerapps Canvas App if yes than how can you help me
I think you have to us PBI for that.
Hi Shane! you videos' have been amazing. I have a question with date inconsistency with PowerApps date picker especially when it is been displayed on different device with different keyboard language setup. What solution can be used?
Text function lets you control the format.
Facing same issue with date picker..
Looking forward to the GroupBy video. Thank you
In case you didn't see it. ruclips.net/video/MDhIjM08u-w/видео.html
hi shane , hank you for your helpful videos. I have a query: if we need the 0 value instead of hid e , what we'll do
This is very helpuful video. Thank you Shane.
Happy to help.
Hi Shane, I have bit different case,
I have 2 data sets,
1: full Table with all possibilities per person. (Upload form)
2: Table where the Upload form is sending the data to.
Now my first Table is 100% and the 2nd table the % depends on the upload form already done.
I wish to create a chart where it will show that for specific Country the upload was done in XX%
So how I would approach in comparing those datasets using a chart?
Radoslaw you will have to get them into one collection. So imagine you are going to ForAll through the first collection to find the amount from the second collection and create a 3rd collection that has your results. Then you would show the 3rd collection. I hope that makes sense.
@@ShanesCows Currenlty I dont understand it, I mean I just started with Power apps, and I cant even figure out why 3 dependent comboboxes needs 3 different formulas to send selected items into excel
Concat(C1.SelectedItems, Result, "; ")
Concat(C2.SelectedITems, Value, "; ")
Concat(C3.SelectedItems, Value & ": ")
instead of 1 formula ....
So c sadly taking about collections and data import to visualize send input Vs the "100% input" is kinda hard now.
Do u have a video maybe with this ? or maybe could u make 1?
Hi Shane thx for the vids... Is there any way to filter the data based on the user logged in? I am looking to build a sales dashboard using an excel file as data source. However I would only want to share to each individual user their sales and target amounts. Thank you!
Apply the concepts show in this video and you will have it. 😀 ruclips.net/video/-VaADTTPYmg/видео.html
Thank you so much for this video. Very helpful!
Glad to help. 😀
Great videos 👍🏼👍🏼👍🏼....
If possible Please explain formulas in detail......
Hi Shane, thank you for your helpful videos. I have a query: I have a pie chart that uses choice column and i want to filter it. i have a search box there if i type 2022 the piechart should show the result with year 2022 in it. Can you help me with this. Thank you once again.
Hi Shane , great video . I have one query how do we show count of case resolved/ opened by EMP name .. please help ..
Use the Sum function with a filter.
Is there any way to control the space assigned to the labels of a chart? There is very little space by default and all my labels are cut. If only it was possible to force them to be multi-line text or to give them a bit more space...
I don't think there is.
Perfect! Thanks a lot for tips and tricks :)
My pleasure!
Hi Shane. Thanks so much for all your videos, you are a fantastic teacher! Is there a way to sum numbers per month fx and then show them as one column or one dot in a line chart. If I have 1. feb, 120, 2. feb, 100, 3 feb. 200 I like to have only one dot for the feb with the sum 420 and so on for all the months, but I can't figure it out. And now it is the third time I like to have this kind of charts, so I hope you are my luck again :-) Thanks in advance!
Look at the GroupBy stuff I talk about at the end. What you want is possible, just a bit tricky.
Great video, any idea on how to group by date? To show number of bookings per day instead of having each date as a separate bar?
Try GroupBy function.
Hello and thank you for the inspiring videos. I am attempting to create a chart using your instructions where I want to group Departments into blocks. However, I am not getting very far as my columns are missing. It only shows "Field1, Field2, and so on. It does connect to my Sharepoint table i can see. Erlier in the app, the columns appear as they should. This is on Screen3. Google nor ChatGTP4 have given me any answers, praying for you now :)
Hello Shane, very thanks for yours videos! It's possible to put a pie charts in a pdf? Thank you
I don't know. I have never tried so I just don't know. Sorry.
Nice video! I would also be nice if you could add a video of how to make a inventory list. I would like to keep track of the hardware that is borrowed and used in the company. And maybe make a reservation for a specific hardware item for a period of time if it is available.
Thanks for the idea!
Another great video. One question from me - at the end when you added a gallery to show the department members, could you have used the DATA from the collection you created? Just wondering if it's more efficient to build the collection once and then use it in more than one way.
Yes. That would be great. I think I was trying to show I wasn’t doing any magic. But caching is always great.
Thanks a lot Shane. Just one question, about the delegation.. using your data, if I want count people in each dpto... im using CountRows at the final of my sintaxe.. but still limited to delegation. Any workround.. my data has more then 2000 itens?
AddColumns(GroupBy(Filter(f_BRIEFING_PROD_OBRA;PROP1="Sim");"PROP1";"PROP");"QTD";CountRows(PROP))
Nope. There is no way to countrows in SharePoint past 2000 that I can thnk of.
@@ShanesCows Thanks!! I will use automate to return to powerapps!
@@ShanesCows Shane, i saw that even using GroupBy and Sum.. like you did, still limited to delegation.. 500 rows that could be changed to 2000 max... is it? THere is no way to sum more then this rows?
Thanks for the great video shane, i just created a column chart works good but there is an issue, i have a time tracker sharepoint list where records of 15 people are stored.
I want to create a column chart for each person & for every month ( date vs hours) can you please help me , when a person logs into the app he should be able to see only his chart
You will have to find a way to filter the data you are passing to the chart based on the logged in user. Kind of like shown in this video: ruclips.net/video/-VaADTTPYmg/видео.html
@@ShanesCows thank you shane....this really helps
For the pie chart, would it be possible to select varying series data on command?
I don't think so but... I haven't really tried either.
Great job. Thank you very much.
Glad to help. 😀
thanks for the video Shane! Great tips, let's get to work to improve the app with some charts.
Boom! Make your apps awesome 😀
0
Hi Shane! Amazing series! I have a question, I have an Excel based powerapp and I need to be able to copy the data from one Excel row to another excel file, one at a time, from the powerapp. Ideally that action would also delete the row from the initial excel.
To be more specific, we are trying to implement this in a hospital, and the powerapp has all our active patients, and we need a button that "discharges"them, and transfers their data to another separated excel file. is this possible?
Run this task with Power Automate (BC Flow) and trigger it from PA. Power Automate has got great actions on Excel (of course these spreadsheets MUST be in OneDrive = online).
@@avinoamrothenberg1244 thanks! I'll give it a try and i'll let You know how it went
Thanks for the assist. 😀
Hi Shane
I have a case here that I need a Pie Chart to put all Status Reason that I have and counting of each one from a collection that I have created.
What you do in a case like this?
I have tried, but with no success.
You would have to fix up the table to be what you want before connecting to the Pie. I am guessing it is possible but not super easy
Just wondering if we can do vertically aligned Column chart from left to right too? or combined Column and Line Chart?
Not that I know of. I think you would need Power BI
@@ShanesCows thank you! powerbi is out of my option since I donthave a license for that to share or incorporate to different apps
Why can't I see some columns for adding to Labels or Series in the charts? The column that I want to add is a Choice type one, so I don't know why it doesn't appears as selectable
Hi Shane! Thanks for your videos! They're very cool!! I'd like to know if is possible to select an Excel file (by upload) in powerapps and add the data in a exist table in powerapps with other data already exist.
Try this ruclips.net/video/QcWjAt7QVn4/видео.html
Great Video as usual. I do have one question. I'm working from a Sharepoint online list that has a date, hours worked and a bunch of other data. I create a collection where I can GroupBy Month/Year and then sum the total number of hours worked for the month. But, some months have no hours. So, when I do the GroupBy, that month doesn't exist. When I chart the data by month, of course, that month is left out. Do you have any ideas how to get all the months to show (even when there are 0 hours worked?) (And, thanks for all your videos....without you, I would have given up long ago.)
Nice! How I Can format labels to currency?
Not sure but this video talks about formatting as currency. ruclips.net/video/OXGWnsxuyzM/видео.html
Hi Shane, can switch the chart type after select the type?
I don't think that you can. 😑
@@ShanesCows 😣
Great video, Shane! I need help! My SP list is to track daily measurements taken at locations. My powerapps gallery uses a search box to search by location, when the user makes a selection, the graph is set up to display the location of the gallery selection, however, I'd like to graph the last 30 days of activity for that selected location. I also have a dropdown of location and date picker on the graph screen in case the user wants to choose another location (This works on its own: Filter('Sourcename',TestLocation=Dropdown2.Selected.Value,SampleDate>=DatePicker1.SelectedDate,SampleDate
Never mind!! I figure it out, it just came to me suddenly. 😊
Glad you got it Linda
🙏🙏🙏 thanks Shane
Happy to help. Have a great day. 🐶
It would be great if you could also do a RUclips tutorial on how to make a Gantt chart.
Hi Shane, thank you for your helpful videos. I have a query: Is there a way to add comma separator in Y series of Line chart? I tried using Text function but it ignores all those
ooh! A bit more complex, love it 👏
Glad you like it!
Dear Shane, I've been following all your video and its really helpful. Right now, I need to improve my sharepointlist so it could give a reminder email with multiple task that are going to expired within some days using MS Flow.
Do you know how to do it? I don't found any helps right now. So, it would be great if you make one. Thank you, hope ypu notice thiz.
I added this to my list of ideas. 😀
@@ShanesCows Thanks a lott!
Shane Young where’s this list!? You should have people up vote ideas?
Good job. Thanks for the video
Thanks 😊
Hi Shane, Filtering a gallery via chart selection was exactly what I was looking for, BUT... How do you clear the selection and clear the gallery filter? Reset(Gallery) isn't working. Someone had a slick formula to reset View/Edit via UpdateContext, BUT it didn't clear the gallery filter. HELP! :)
I also tried setting a variable, but I couldn't get the variable to capture the chart slection. Used a text label to verify nothing was happening.
Another one of your videos saved the day... Patch! You rock, Shane!
ruclips.net/video/gmYlJIjHS2M/видео.html
Hi Shane, you're my new BFF :-)
Awesome videos, I've learnt so much already!
Glad to hear it Eric. Buy me a matching BFF charm bracelet 🤩
Is there a way turn the column chart to horizontal bar chart?
Not sure. I haven’t tried 🤷♂️ but I am doubtful
Hola Shane, una pregunta, y como haría para hacer un grafico y ordenarlo por meses ?, algún video porfavor
You can sort by column on a date column or use GroupBy to combine dates by month.
What I'm really frustrated about is I can't seem to pull a O365 SP dropdown into the chart.
Try .value after the column name. Sorry haven’t tried that one.
Hi Shane! Great video.
I'm struggling with the following: I have a column graph which shows spend against different categories (e.g. $100,000 total, of which $20,000 in total spent on category A, $30,000 in total spent on category B etc). However, each of these items in the table shows who spent the money and against what category (e.g., Dave spent $5,000 on category A, Fred spent £15,000 on category A (to make up the $20,000 total spend) etc.) I want the graph to be able to show how much Dave spent against each category by selecting a dropdown and the graph changing.
Essentially, I want the chart to change when a person is selected from the dropdown box.
I can't for the life of me figure this out. Any help appreciated :)
I wish I had a quick answer but I don’t. 😕 I have someone in my team that does all of the number crunching Power BI things. I feel like it is possible though.
Thank you bro
Happy to help. Have a great day. 🐶
Hi Shane it's very useful..
Thanks 😊
Hi Shane,
Great presentation, I subscribed to your channel as a result ;-)
I do have a question.
I have an excel with kms run by our colleagues, every day people post their achievements which gets into an Excel.
It would be nice to show a graphic with the total amount of kms per month (bar chart for instance).
Can this also be done with the sum function or is it easier to foresee a extra table in Excel with totals per month?
Great stuff as always !! Thank you for sharing and shortcutting our learning and development curve :)
My pleasure!
THANK YOU! THANK YOU! THANK YOU!
I have a question, I am using an excel as a data source, which is grouped by a column. When I retrieve the details of a selected column it returns only one row of that group. Any suggestions 🙏
Excel has to be flat data. No fancy formulas or group
@@ShanesCows I went into the rabbit hole and figured it out. 🙌🏻 Thanks tho😺
Anyhoo, I appreciate you explaining everything so easily. Have been a fan for a while now 😬🤟🏻
@@ShanesCows it was flat but I was using lookup instead of filter😝
Thx for teaching
Glad to help. 😀
Dear Shane,
I am still wondering why Powerapps team still not done much of work on Charts in Powerapps. Its really very difficult to even make and edit a simple bar chart. There should be option to make charts as easy as we can do in PowerBI.
Thanks for the video, keep up the good work.
Can you try making one video on How to join two different apps let say Two Templates together and use it as one app?
I think the reason the Chart Controls don't get improved is because they are already have Power BI. So they don't want to duplicate work. But I don't know. 🤷♂️
@@ShanesCows agreed with you there. They will give ou some basic functionality but for anything else PowerBI. It has been a blocker on several projects in 365 for a while now. Had to resort to going the extra mile and workarounds to display data in SharePoint and soon this way in Powerapps. I did see a demo somewhere on using SVG image files to display data so that is another option. Again way more complicated than just using PowerBI.
Question, I am using a SharePoint list as a data source and trying to group by a lookup column that references a related list. The data shows it as a record but doesn't accept it in the group by. Am I missing something?
I don’t think you can group by a lookup column. I haven’t tried but would be surprised if it doesn’t work. Did you try column.value?
@@ShanesCows It doesn't even recognize that the column exist. As a possible work around, is there a way to create a collection that stores the lookup column as a value rather than a linked record. I am using several collections but it looks like the lookup columns are stored as sub tables for lack of a better word.
@@russellhenry951 In the sharepointlist create a calculated column and assign the lookup column (=[status]) here status is a lookup column , now the calculated column listed in the powerapps columns list. use the calculated column for groupby function
Hey Shane I need immediate help on power apps charts how can I connect with you for paid services
Sonam you can email me Shane at PowerApps911 dot com and I will connect you.
Can I show 0 value in bar char . Power apps doesn't show even a indicator for 0 value any help on this issue.
I don't know. I haven't tried that.
I am struggling with Choice fields from Sharepoint Lists.
They do not appear for Label/Series selection in the PowerApps Charts, only Text and Number field types.
Any clue how do I get this information from the Sharepoint list? I am trying a simple pie chart to show # of records for each picklist value (of Country choice field) but it is not working.
I tried using Collection, or manually adding columns and calling "ThisRecord.Country" but neither worked. :'(
I see this video is from July 2020, when did PowerApps start supporting charts? I never noticed it was even there... was it there all along?? lol
Long time Kevin. Long time. 😂
@@ShanesCows OMG I was afraid you'd say that!!
Hi, how can i link the chart to gallery is it possible?
Gallery.Allitems produces a table. The chart just wants a table. 🙂🙂
great tip
Thanks 😊
hi, how u create the user picture and the username (right above)?
Using the User() function ruclips.net/video/FpXrF5NDZbI/видео.html
Thanks, have u a exit() when you click on it?
how to agg the data?
I hate that they don't ever show the sharepoint it's connected to. That's a key step that needs clarifying.
I'm watching this now. There better be cows.
Oh man.... the might be in trouble. 🐮🐄
@@ShanesCows You've lost your way. :) 🐮🐄
Red, green and ... another green, you're so naughty.
😋
Hi shane
Hey 👋