Pnp to reterive all pages

 Connect-PnPOnline -Url "https://yourtenant.sharepoint.com/sites/YourSite" -Credentials (Get-Credential)


# Get the site pages library
$sitePagesLibrary = Get-PnPList -Identity "Site Pages"

# Query for pages where "isincludeinnews" is "yes"
$pagesToUpdate = Get-PnPListItem -List $sitePagesLibrary -Query "<View><Query><Where><Eq><FieldRef Name='isincludeinnews' /><Value Type='Boolean'>1</Value></Eq></Where></Query></View>"

# Update the specific column for each page
foreach ($page in $pagesToUpdate) {
    # Set the value of the target column (e.g., "YourTargetColumn")
    $page["YourTargetColumn"] = $false  # Set to false to match your condition
    $page.Update()
}

# Execute the changes
Invoke-PnPQuery

Comments

Post a Comment

Popular posts from this blog

Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide

Image
Effortlessly Import JSON Data into SharePoint with Power Automate Flow: A Step-by-Step Guide Importing data into SharePoint can be a time-consuming and complex task, but with Power Automate Flow, you can easily import JSON data into SharePoint with just a few clicks. In this post, we'll show you how to do just that with a step-by-step guide. Why Import JSON Data into SharePoint with Power Automate Flow? JSON (JavaScript Object Notation) is a lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate. It's a popular format for exchanging data between different systems and applications, and it's often used to store and transfer data over the web. By importing JSON data into SharePoint, you can make this data easily accessible and manageable in SharePoint. How to Effortlessly Import JSON Data into SharePoint with Power Automate Flow Here's a step-by-step guide to effortlessly importing JSON data into SharePoin...
Read more

Generic Design Powerapps, Sharepoint and flow

  1. Backend: SharePoint You will use SharePoint to store all the data required for the event management system. Create the following SharePoint lists for different entities: Event List : Stores event details (e.g., Event Name, Date, Location, Description, Organizer, Capacity, Registration Deadline). Columns: Title, EventDate, Location, Description, Organizer, Capacity, RegistrationDeadline, etc. Attendees List : Tracks attendees for each event. Columns: AttendeeName, Email, Event (Lookup to Event List), RegisteredDate, Status (Registered, Waitlisted), etc. Feedback List : Captures feedback from attendees post-event. Columns: Event (Lookup), Attendee (Lookup), Rating, Comments, etc. Notification Settings List : Manages notification triggers and timing for automated emails. Columns: NotificationType (e.g., Reminder, Registration Confirmation), TimeBeforeEvent (in hours/days), EmailTemplate, etc. 2. Front End: Power Apps The Power Apps application will serve as the main interface for...
Read more