Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

How to create Planner tasks based on excel table

Like (0) ShareShare
ReportReport
Posted on 18 Feb 2023 00:13:04 by 26

Hello, 

 

I'm trying to create a workflow to transfer my excel table into planner tasks, but I can't figure out why I keep getting the null value error: A null value was found for the property named 'title', which has the expected type 'Edm.String[Nullable=False]'. The expected type 'Edm.String[Nullable=False]' does not allow null values.

 

My test table:

Cinna103_0-1676678795556.png

 

My workflow:

Cinna103_5-1676678970403.pngCinna103_3-1676678940108.pngCinna103_4-1676678952884.png

 

 

  • CU31081919-0 Profile Picture
    26 on 19 Feb 2023 at 03:41:45
    Re: How to create Planner tasks based on excel table

    That worked! Thank you for your help! 

  • Verified answer
    abm abm Profile Picture
    32,464 Most Valuable Professional on 18 Feb 2023 at 21:15:08
    Re: How to create Planner tasks based on excel table

    Hi @Cinna103 

     

    Here is my tutorial video based on this error you getting. Please have a look and comment.

     

    https://youtu.be/2RVEzFD93Uw

     

    Thanks

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…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started