Skip to main content
Community site session details

Community site session details

Session Id : TAMXxocSrET0LbdwbeK5Cy
Power Automate - Process Mining
Unanswered

How to get time value from excel and pass it in find meeting time for searching someone's availability in their calendar

Like (0) ShareShare
ReportReport
Posted on 26 May 2021 09:13:17 by 2

Hi,

We have one excel file which has multiple sheets. in one sheet we have some details regarding candidate like name role and preferred time to give interview. for preferred time we have two columns in which one is date and one is time. In second sheet of excel we have details related to Interviewers like name role email id etc.

So I want to check Interviewer's calendar according to preferred time of candidate and need to check for the available slots if slots is available we need to send them a team meeting invite. if slots is not available we need to check for the next Interviewer's calendar for free slots and scheduled a meeting on rotation basis. 

it would be a great If anyone can help me  on this.

 

I am able to get date from excel in correct format but i am not able to fetch time(which is in different column) to check available slots in interviewer's Calendar.

 

  • Shalini6 Profile Picture
    2 on 28 May 2021 at 05:32:52
    Re: How to get time value from excel and pass it in find meeting time for searching someone's availability in their calendar

    Hello @abm Thank you for your response. now i am able to fetch time also in correct format. can you please help me on other side. i am able to fetch interviewer's calendar also but not able to scheduled meeting on their free time.

    also, i need to pick interviewer's list on round robin basis and assign interview. in my case whenever i run the flow the interview is assigned to the first interviewer in excel.

    Can you please help me on that.

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 26 May 2021 at 10:56:14
    Re: How to get time value from excel and pass it in find meeting time for searching someone's availability in their calendar

    Hi @Shalini6 

     

    What format the Excel stored the time? Also in flow how is it retrieved as?

     

    Could you post an example of the data from Excel and your run history of flow where it shows the time?

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete