Answered

Question about Excel - Update a row

(0) Share

Report

Posted on by Emile77

Hello,

I have written a script which gets events from an excel file and either creates or updates the events in my google calendar.

However: I just encountered a problem with Excel: update a row.

When the event doesn't exist, powerautomate creates the event and afterwards adds the event id to the excel file with update a row (key value: Event Start Date-Time) and then add Event ID to the column ID.

This worked fine until now, when i have two events at exactly the same date and time. The subject of both events is different, but I cannot use the subject as key value, as i have many identical subject.

Does anybody know a solution? Is it possible to use two key values simultaneously?

All the best,

Emile

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

David_MA 13,850 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You will need to show your flow and what action is failing. Otherwise, it is a complete guess as to how to solve the problem.

Was this reply helpful? Yes No
Emile77 11 on at

Like (0)

Report
Copy link

Link copied!

Here is a screenshot of the portion of the flow which gives the problems and my input in the 'update a row'-window.

Was this reply helpful? Yes No
Verified answer

Emile77 11 on at

Like (0)

Report
Copy link

Link copied!

I managed to solve it myself. I added a formula in the excel file which changes the start date-time by adding one second when there are multiple events with the same date-time. This one second difference doesn't show in my calendar, but makes that the flow can distinguish between the events.

Was this reply helpful? Yes No