web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Question about Excel - Update a row

(0) ShareShare
ReportReport
Posted on by 11
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
I have the same question (0)
  • David_MA Profile Picture
    12,908 Super User 2025 Season 2 on at
    Question about Excel - Update a row
    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.
  • Emile77 Profile Picture
    11 on at
    Question about Excel - Update a row
    Here is a screenshot of the portion of the flow which gives the problems and my input in the 'update a row'-window.
     
  • Verified answer
    Emile77 Profile Picture
    11 on at
    Question about Excel - Update a row
    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.

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard