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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow to extract data f...
Power Automate
Unanswered

Flow to extract data from Outlook to Excel

(1) ShareShare
ReportReport
Posted on by 2

I had built a flow which included a trigger from Bookings, Find Event in Outlook and then extract custom fields to excel online. It had been working great until now. Was there an update to Outlook or Bookings today? The extracted information now is not working correctly now. When I look at the format on the Outlook calendar, it looks different than previous data. 

 

Anyone else has issue with this?

 

 

Categories:
I have the same question (0)
  • AVoraman Profile Picture
    43 on at

    Yes.  I'm fighting with this, also. 

    I have two dropdowns and I can no longer get the values of the selected options.  There are new arrays:

    AVoraman_1-1692912401192.png


    That last one is the array index for whichever array you're running Apply to Each on.  I want the actual options, as I'm using them to look up a particular record in an Excel table. It's the entire reason I'm using a dropdown and not letting the user enter the information.
    I'm not sure if these are integers - because I got an error when trying to use a Switch on an input field. 
    I got angry so I came here to see if anyone had any better ideas on how to get the actual options out of Bookings, so I don't have to make ridiculous conditional chains. 

  • AVoraman Profile Picture
    43 on at

    Yes, that last one is an integer, so I can set an integer variable to that input and use that in the Switch.  I can't use the direct input, though, or it won't even let me save.

     

    I hope this helps.

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

Forum hierarchy changes are complete!

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

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard