Alex! I love how you explain every step. I wish everyone did that in their videos. This video is exactly what I needed. Question 1: When I create an ‘all day event’ on CalendarOne it creates two entries on CalendarTwo (split over midnight). Question 2: When I create a ‘repeating event’ on CalendarOne it does not create the event on CalendarTwo, even though the flow ran successfully. Would really appreciate any help with this because it’s something I need to launch this month and I’m stuck. Thanks so much.
What if you wanted to do this to create lines in a excel table, but you want to create a line with each active year and it just repeats the information for the other columns… so the stuff not in a array repeats but it iterates through the array on a new line…. To make it more dynamic where different entries have a different number of items in the array.
Hello Alex, this is what I need except I need the first calendar to be the SharePoint calendar then the second calendar as the old (legacy calendar/App calendar). I'm using this for a leave request. I hope you can make that video. The SharePoint List Calendar is great for look but doesn't have the features like the legacy so I need to use it for the purposes.
Hi. I created the custom connector and am "pretty" sure I followed the setup in your guide. But, when I click new connect my Office Dialog Pops Up and accepts my login with no errors, but the connections drop down on the custom connector remains at "none". Can you suggest what to try here? Thanks.
Alex - Thanks for this - It unlocked for me how to access the values of a collection of multi-select choice items (think server names in a SharePoint list column called Servers). I went from getting the entire object to getting the Value of a specific item . item()?['Servers']?[0].Value gets me >> SERVER01. This is good I need to a way to get ALL of the selected item Values dynamically using a similar expression/function call while I am getting the other columns for the row via a select can you help?
Hello Alex, First of all thanks for the tutorial. I am trying to follow this tutorial but in the end, when I test the connector I get an "EnvironmentAccessDenied" type error. Would you have any idea on how I can solve this?
Thanks for the great video! I am trying to create a flow that updates ALL checklist items (based on JSON object information from Get Task Details) across tasks from Planner, as opposed to one particular task based on a trigger. Do you know if this is possible? Thanks again!
Exactly what I was looking for, thank you! Did you ever figure out how to update the second calendar if an event is deleted from the first calendar? If so, it would be great if you would tell us how to do that.
Thanks Alex for the video, it helps.. Well, I have a doubt, how can we read json field with spaces, say for example {"place name": "Bangalore"} Any suggestions are appreciated..
This is fantastic! Thank you so much! Can you provide any links to help understand what other REST Api calls can be made. Can I figure out any details about the run instance like the sharepoint record that caused the flow to start? Also is there a way to cancel all the approvals that are active in the flow?
Very useful video, however, One quick question: suppose the json keys were like first.name or system.firstname: can you check if your method works? When you do [‘first.name’], flow gives an error saying invalid expression.
Excellent Alex, you explain clearly so everything looks easy. Can you make another video working on a JSON file with multiple records instead a JSON object variable? That would be really handy! Thanks!
OK, I just discovered how to do the same as shown in this video but using JSON files; use first a file content step with the "Get File Content" action. Next, as the input of the "Parse JSON" action, it is necessary to do two conversions including from base 64 to string as Power Automate manage files as binary even if they are flat files. For example, if the step is called "FileContent", then the conversions for that input would be: base64ToString(base64(outputs('FileContent')?['body'])). It works!
Hello Alex, Thanks for your tutorial ! I'd like to ask a question about $filter parameters, i tried to use by start date in filter field but it gets an error. "filter is invalid or not supported". Do you have a suggestion about it? I want to filter Startdate lt '26.01.2021 00:00:00' for exp.
@Alex Tofan Many thanks for your response, I tried to change the query as startTime lt '2021-01-26T00:00:00Z' and startTime le '2021-01-26T00:00:00Z', but both of them return error again. When you try to filter by date as like me, did it return any error? '{"error":{"code":"InvalidQueryFilter","message":"The provided query filter 'startTime le '2021-01-26T00:00:00Z'' is not valid or not supported. '{"error":{"code":"InvalidQueryFilter","message":"The provided query filter 'startTime lt '2021-01-26T00:00:00Z'' is not valid or not supported.
@@AlexTofan Hello Alex, i found an alternative solution. I tried to use filter array in the flow and it worked! Thank you for all your video series! Have a nice day.
