You’re offline. This is a read only version of the page.
40
Hi community.
in my app i got a gallery displaying items from a sharepoint list. in my sharepoint list i got columns like MachineType, MachineId and Cycle and want to filter the data that way, that only 1 item of each MachineType-MachineId-Cycle Combination is displayed, ideally the last one added. do you have any idea how to accomplish that?
Help much appreciated, thanks in advance ❤️
Hi @KAdler ,
Yes that is exactly the workaround - you can only group by Text columns.
Found a workaround by using AddColumns to add the Value of the choice column to the data. Afterwards i can GroupBy that new column. 🙂
@WarrenBelz: Thanks for your quick reply. Looking good so far, but i can't group by Cycle. I guess it's related to it being at selection type column in the SP list. Neither Cycle not Cycle.Value got accepted. Is there any workaround?
Hi @KAdler ,
Try
Share
Report
All responses (
Answers (
GroupBy(
Sort(
SPList,
ID,
SortOrder.Descending
),
MachineType,
MachineId,
Cycle,
Grouped
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
