You’re offline. This is a read only version of the page.
Hi
I've made a Flow for my PowerApp that creates an event in a outlook calendar when the leave is approved. It works when I use it, but obviously when another user tries to use this flow, they are trying to create an event using my Outlook account and therefore it fails.
I think I've worked out a way to make this works but I need the user of the app's calendar Id to be called, however, I can't seem to do this in Power Apps.
I have tried the following in the Items control of a dropdown box:
LookUp(Office365Outlook.CalendarGetTablesV2().value, name = "Calendar").id
However, this does not provide me with the Calendar Id, it fails.
Am I trying to achieve the impossible or is my syntax just bad?
Many thanks, and apologies if I've not been clear at any point in this post.
Many thanks
Is there a way to get a Meeting Room's Calendar ID?
An instant cloud flow is one you trigger on demand or one that triggers when it detects whatever logic you've built to trigger it. An automated cloud flow is one that is scheduled and not relying on a specific trigger.
Thank you for taking the time to explain this to me, it's really appreciated.
I'm not sure I quite understand the difference between a "(an instant cloud flow)" and a "(an automated cloud flow)"
What defines a "instant cloud flow" is it purely that it is called by a .run function in Powerapps? (My flow is called this way)
I'm not sure I quite understand why the formula wouldn't work in an Items part of a dropdown, but I do know that indicates a large gap in my knowledge. If there is any documentation you can think of to help me on this it would be appreciated, but if nothing springs to mind please don't utilise anymore of your time on it.
thanks again.
Also, I should add...depending on how you are instantiating your PowerAutomate flow, you will need certain permissions to be able to carry out what you are trying to do.
For example, if your flow is triggered by PowerApps with a .Run (an instant cloud flow), then it will be using the users' Calendar anyway as the connector is always used in the context of the user for a flow like that.
If the flow is triggered by some other event (an automated cloud flow), then it will be under the context of the account set for the flow.
SO...in regard to that last point - if the flow is an automated flow, then the account the flow is set for must have permission to the calendar of the user in order to carry out what you want.
That is all good...but you were stating that you were using a record with an id for the table of items for a dropdown!'
That will not work (or at least it is not a use for a dropdown)
However, if you just want the id of the Calendar for the current user, then your formula is correct!
LookUp(Office365Outlook.CalendarGetTablesV2().value, name = "Calendar").id
If you use this return, then you will have the id. (but not as an Items property)
Additionally, there are quite a few working solutions in this topic here. https://powerusers.microsoft.com/t5/General-Power-Automate/Easiuest-way-to-get-calendar-id-for-the-Office-365-Calendar/td-p/6279
You should be able to get the Calendar IDs using Graph Explorer
https://developer.microsoft.com/en-us/graph/graph-explorer#
More info here https://developer.microsoft.com/en-us/graph/docs/api-reference/beta/api/calendar_get%C2%A0
Thanks for your reply, Randy, I specifically want to find the Id n of the calendar called 'Calendar'. I need to know this as each ID will be different for each user although its name will always be "Calendar"
Thanks,
If you're using that formula for a dropdown Items property, then you really want to have a table, not a record (otherwise the dropdown is useless).
Using the Items formula: Office365Outlook.CalendarGetTablesV2().value
will give you the table of calendars for your dropdown.
Your Value field will be name.
If you want to set the "Calendar" as selected, then the Default property would be "Calendar".
The above assumes you are referring to a dropdown and NOT a combobox.
I hope this is helpful for you.
#1
WarrenBelz
388
Most Valuable Professional
#2
MS.Ragavendar
193
#3
stampcoin
147
Share
Report
All responses (
Answers (