You’re offline. This is a read only version of the page.
Announcements
56
Hello everyone,
I am working on app that i have cascaded Radio buttons . to chose main category then sub category then the product range, once the user select the product range , all final products will appear in a gallery (Title, Subtitle, Body) to select based on the previous selections from radio buttons .
** data source is SharePoint list **
i added the below codes for each Radio button and Gallery
RB1: Sort(Distinct(Filter(CCTVLIST,'Main-Cat'="Cam"),'Sub-Cat'),Value)
RB2: Sort(Distinct(Filter(CCTVLIST,'Sub-Cat'=Radio1.Selected.Value),Form),Value)
RB3: Sort(Distinct(Filter(CCTVLIST,'Sub-Cat'=Radio1.Selected.Value && Form = Radio1_1.Selected.Value),shape),Value)
Gallery3 : Sort(Distinct(Filter(CCTVLIST,'Main-Cat'="Cam" ,'Sub-Cat'=Radio1.Selected.Value, Form=Radio1_1.Selected.Value, shape=Radio1_2.Selected.Value),Description),Value)
the issue is :
Galley is displaying only product Description , but what i need to change Title with the Price and Subtitle with the Part number . i tried to change the Item of the Title to be (Thisitem.Price) it didn't work !!
is anyone can help me to achieve this
Thanks in advance for any help
Sort(GroupBy(Filter(CCTVLIST,'Main-Cat'="Cam" ,'Sub-Cat'=Radio1.Selected.Value, Form=Radio1_1.Selected.Value, shape=Radio1_2.Selected.Value),”Description”,”Result”),Value)
The label text property should be:
First(ThisItem.Result).Price
But all products with the same description have the same price and the same part number ?
Also be aware of delegation issue because the formula is not delegable to SharePoint server and all operations will be done on client side with 500-2000 items (based on your settings).
Share
Report
All responses (
Answers (
