You’re offline. This is a read only version of the page.
16
Hi, I have this code to feed a table when toggle = true or False. The toggle name is: LbVisible.
Share
ReportIf ( LbVisible.Value = false;
Sort( Filter( INCO_REQUESTS; Status = "Submitted for Action" And Request_Type <> "NO TARIFF" And IsBlank(Email) ); Submitted_Time; Ascending );
Sort( Filter( INCO_REQUESTS; Status = "Submitted for Action" And IsBlank(Email) ); Submitted_Time; Ascending )
)
Now i would like to add Distinct value only, cause right now, i have duplicated rows.
How can i do that?
Thank you
I think i was able to make it work like this:
All responses (
Answers (
GroupBy(
Filter(
INCO_REQUESTS,
Status = "Submitted for Action" And Request_Type <> "NO TARIFF" And IsBlank(Email)
),
"From",
"To"
), but i will continue to test
For some reasons, i'm still having all those errors
What if i use First and groupBy to replace the Distinct?
Ex:
First(
Filter(
INCO_REQUESTS,
Status = "Submitted for Action" And Request_Type <> "NO TARIFF" And IsBlank(Email)
)
)It gives me the first record only, but if i group by 2 columns value, would that also do it?
Ex: Group by "From" and "To" columns?
Would i have to put my GroupBy at the beginning?
I tried again, and when I add the Distinct code piece, I still receive the same errors:
I'm confused as to why this is happening.
For some reason, the minute I add "Distinct", that's when I get an error. If I remove the Distinct portion of the code you gave me, it works perfectly. I will try again and get back to you, but for now, no luck.
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
