Skip to main content

Notifications

Power Automate - General Discussion
Answered

Finding Records with Missing Required Fields in SharePoint Online.

Posted on 29 Apr 2023 13:03:52 by 282

Is there any painless way in SharePoint to locate missing Required fields in document records?

I have a document library with over 40K entries, and I'd like to get a listing of those with missing data.

My only recourse is to use Power Automate, read through the entire library, and use the empty function.

  • Verified answer
    lbendlin Profile Picture
    lbendlin 7,795 on 29 Apr 2023 at 15:24:19
    Re: Finding Records with Missing Required Fields in SharePoint Online.

    You should be able to run an ODATA query against the SharePoint API with the appropriate filters for this - maybe give that a try.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard

Featured topics