Answered

Reverse search / search for non-existent data

(0) Share

Report

Posted on by nic86

Hi
I hope this great forum can help me again with a tip - I just can't find a solution.

I have a gallery. My users can use a button to mark posts that have already been read as such. With the help of the patch function, their user name is entered in the "Read status" column of Datavers.

Since we have a lot of posts, I would like to create a filter with which all unread posts can be displayed.

Although I manage to display all the read posts. But I can't manage to do the search in reverse, so that only the posts are displayed where the user name is not yet in the table.

Do you have an idea how I could go about this?

Many thanks for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@nic86

Probably the easiest way to do this is to create a view from your dataverse table and use that view for your gallery.

Was this reply helpful? Yes No
nic86 36 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp
Thanks for your tip.

Unfortunately, if I understand it correctly, this doesn't seem to solve my problem either. Since all user names are written one after the other in one line with the patch function, I would otherwise have to create a separate Dataverse view for each user. And make them available separately for each user in PowerApps. Or am I wrong?

Was this reply helpful? Yes No
Verified answer

nic86 36 on at

Like (0)

Report
Copy link

Link copied!
Fortunately, I think I've finally found a solution that works (and actually wasn't difficult at all).
I'm not (yet) able to search directly for the username. But via the detour of an additional text input, the whole thing now works as desired. The (not visible) text input gets its data automatically via User().FullName.
Maybe it helps someone else here:
If( Checkbox2.Value; Filter( Test; Not(TextInput1.Text in ReadStatus) ); Test )

Was this reply helpful? Yes No