check if SharePoint list contains A record with two fields

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

the sharepoint columns are

username, document, date

(document is a text string)

I am able to connect to the datasource (sharepoint) add and delete records, and do lookups (but not for a "and" condition on a specific record).

I just need a script that checks all the sharepoint list for a record that contains BOTH a specified user AND specified document (the date does not need to be checked). The script should return true/false.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous

Consider the following:

LookUp(yourList, userName = someUserName && document = someDocument, true)

This will return true if the record exists, false if not.

I hope this is helpful for you.

Was this reply helpful? Yes No