Outlook and sharepoint

(1) Share

Report

Posted on by YR-16100643-0

Hi, I want to create a event starting from a Microsoft list. in my list, I have 3 things. Beginning (datetime), end (datetime) and create a event (yes or no). My trigger is if create a event is yes => create a event using start and ending time. But I have always the same error. I have a null but there is no empty cell. I add a delay but nothing change

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

AK-23050826-0 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Try the Power automate developers tool kit, it might help:

https://www.linkedin.com/posts/ajinkya-a107b1188_powerautomate-powerplatform-lowcode-ugcPost-7463235502469730310-IZx4/?utm_source=share&utm_medium=member_desktop&rcm=ACoAACxBm2wBkJbBqH3wfMs_HUDI4gP3RE5m3vE

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @YR-16100643-0,

Yes, sometimes this happens even though the value exists. We are still not able to get that column value directly from the trigger itself. I have faced a similar kind of issue before.

What you can do is add a "Get Item" action, pass the ID from the trigger, and retrieve the current record using "Get Item". Then use the date column value from the "Get Item" action instead of directly from the trigger, and try it.

Start Date Expression:

formatDateTime(outputs('Get_item')?['body/Beginning'],'yyyy-MM-ddTHH:mm:ss')

End Date Expression:

formatDateTime(outputs('Get_item')?['body/End'],'yyyy-MM-ddTHH:mm:ss')

Note: Please update the expression as per your action name and column name.

If you are still facing any issue, Please send the error screen shot.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YR-16100643-0,

The "null" error you’re seeing when creating an event from your Microsoft List in Power Automate, despite no empty cells, is commonly caused by how the flow reads or interprets the date/time fields or the "Create a event" Yes/No field.

Kalathiya - has explained well for the date part, beside that I have something to share:

How do we consider Yes/No: Let's consider to validate the Yes/No field condition - we need to ensure the condition to check if "Create a event" is Yes is correctly configured. The Yes/No field returns a boolean (true or false), so your condition should check for true rather than a string "Yes". We need to make sure if true/false is really true/false.

@equals(triggerBody()?['Createaevent'], true)

Handle Nulls in Expressions: In the Create Event action, let's use expressions like coalesce(triggerOutputs()?['body/Beginning'], 'default-date') to provide fallback values if the date is unexpectedly null. This prevents the flow from failing due to null values.

Are we using delay with justification? Adding a delay usually doesn’t fix null value issues unless the data is being updated asynchronously elsewhere. Let's focus on verifying the actual data received by the flow.

NOTE: Let's not forget to check Field internal names - sometimes the display name differs from the internal field name used in the flow. Let's Use the "Peek code" or dynamic content to confirm you are referencing the correct internal field names for Beginning, End, and Create a event.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
YR-16100643-0 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks.

Sorry but I have this issue. I have on my microsft list. 3 items :

> "Reserver du temps" : Yes or no. => Create an event

> Debut_Working : Datetime for the start of my event

> Fin_working : Datetime for the end of my event.

Thanks for your Help

Was this reply helpful? Yes No