Skip to main content

Notifications

Community site session details

Community site session details

Session Id : R3e0IgaqvRLfZy1GT/yge6
Power Automate - Power Automate Desktop
Answered

PAD or Power Automate Desktop SharePoint Get Items List Property Missing if has no value

Like (0) ShareShare
ReportReport
Posted on 18 Apr 2024 01:45:34 by 73

Is there a Simple way to handle this Empty Property that does not exist no easy way to check except column count on the item/row.

Am I missing something. Is there a way to force all (columns/Fields) properties to be loaded for a SharePoint Get Items row so the column has a Null Value or Empty string. 

 

This means each row in the list based on missing properties varies in length but on the PAD end you have no way to check this without counting the Row's length and guessing. Processing each whole row as a separate array. 

 

Not a nice experience. 

  • Verified answer
    comsys Profile Picture
    73 on 18 Apr 2024 at 03:23:30
    Re: PAD or Power Automate Desktop SharePoint Get Items List Property Missing if has no value

    Solution I found for this is if no property On Block Error set variable to replace the property that is missing to empty string ''

     

    comsys_0-1713410602484.png

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 4 Super User 2025 Season 1

#2
KO-05050229-0 Profile Picture

KO-05050229-0 2

#2
stampcoin Profile Picture

stampcoin 2

Overall leaderboard
Loading started