'And' Function not working with DataVerse tables after switching from sharepoint list

(0) Share

Report

Posted on by protonme

Hi,

I am trying to filter my items list for Galerry, it worked fine with Sharepoint connection but on DV I cannot figure it out. When I put single condition it works, just when I try to add another with "and" it stops:

If( Inventory.Selected.Id=1 ,
SortByColumns(
Filter(
LIST, 
AND (
gal_poverview.Seleted.'ID' = ID, 
type = "General")), "Level"
, Ascending)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @protonme

Can you try the following?
If( Inventory.Selected.Id=1 , SortByColumns( Filter( LIST, gal_poverview.Seleted.'ID' = ID && type = "General"), "Level", Ascending )

Hope this helps

Was this reply helpful? Yes No
protonme 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, unfortuantely this did not help

Was this reply helpful? Yes No
protonme 8 on at

Like
a
(0)

Report
Copy link

Link copied!

After rebuilding the whole app from scratches it worked. I have no clue what was the issue.

Was this reply helpful? Yes No