I'm new on PowerApps and i already learn a lot. This App is wonderful, but i need your help right now. Thanks in advance.
As you can see on my Sharepoint List (please see attachements), i have 3 lines. 2 of them has the Statut = Nouveau.
I would like to know how i can regroup them in a gallery in PowerApps. Cause for now, when i create a gallery, my gallery create a line for every "Nouveau" i have in my SharepointList. (see attachment)
I only want two lines in my gallery : "Nouveau"and "En cours"
Thanks for your help
Solved! Go to Solution.
As far as I can tell setting Items in a gallery to
GroupBy(Tickets, "Statut", "Group")
And adding a label in the gallery should give a gallery with the options.
What type of field is Statut in Sharepoint? I dont think it should matter but I know I've had issues with LookUp/Choice fields before
It looks like Statu is a Choice type column in Sharepoint. You can save yourself a lot of aggravation by either converting Choice columns to Single line of text or Numbers from within Sharepoint. I have never lost data by doing this but the other way is to create a new calculated column and put the Choice column in as the calculation. You can then use the new calculated column in Powerapps. Choice and Lookup columns are embedded tables and INHO are meant for use in SharePoint and are not designed for Powerapps. Thats the reason for the complicated work arounds. The screen capture on the left is from the Sharepoint Online with the list settings and create columns clicked and the calculated type chosen. In this case, the Categories column is a Choice type. Note the single line of text option below the type of information section. Unfortunately, this will not work for Lookup type columns. A different approach is necessary for unpacking them. I hope this helps.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.