You’re offline. This is a read only version of the page.
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.
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.
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?
Share
Report
All responses (
Answers (
