Unanswered

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

(0) Share

Report

Posted on by Shalini6

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.

Categories:

Process mining

I have the same question (0)

All responses (2)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Shalini6 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No