cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shalini6
Frequent Visitor

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

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.

 

2 REPLIES 2
abm
Super User III
Super User III

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?



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Shalini6
Frequent Visitor

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.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Kudoed Authors
Users online (20,926)