User Profile
juliemturner
MVP
Joined Jul 15, 2016
User Widgets
Recent Discussions
MSFlow filter SharePoint list in GetItems action by date field
I was attempting to create a flow that executed a GetItems action that would use the ODATA filter field to limit the rows to those where a date field (ProjectEnd) was less than or equal to the current date/time. I accomplished this by creating a composed string variable that was the filter portion of what will be essentially a REST call to SharePoint. So if you're familiar with SharePoint REST call formats your goal will be to attain the same result and the query should work. In this case I needed the REST call to have $filter=ProjectEnd lt '2017-04-27T19:51:38.7610450Z'. That turned out to be tricky, but knowing that the browser would encode the single quotes anyway I just jumped ahead and did it in my variable. The resulting variable looks like this: ProjectEnd lt %272017-04-27T19:51:38.7610450Z%27 The result of this Compose can then be attached to the filter of the GetItems. KEY: when you actually create this compose action item, put (double quotes) " around the value, they do not show once you've saved the flow but are critical to make it work.Re: Client side development - Where do I begin?
Yes, you're exactly right and definitely not alone in your view. If you're at the point of understanding JavaScript and the sewp then your next step is TypeScript and the dev toolchain. To address the latter the free Voitanos video I recommended will help you understand what you need to know vs what you need to understand. Strictly speaking since TypeScript is basically a superscript of JavaScript with a few tricks you can just keep writing JavaScript in SPFx, but honestly its potentially easier to just learn TypeScript. And to your point, you can just utilize a modern version of a sewp. It really just depends what your requirements and personal goals are.Re: Issue of Microsoft Graph API not supporting Office365 Sharepoint Cloud enumerate sites on smartphone
Well, I obviously cannot comment on why whomever told you to migrate told you to do so, but given the MSGraphAPIs are still in beta I would say the move is premature. I can also assure you that the REST apis in SharePoint are very much alive and well.Re: Issue of Microsoft Graph API not supporting Office365 Sharepoint Cloud enumerate sites on smartphone
My appologies, you're absoluely right Re CSOM, that is a .NET construct. That said, what exactly do you mean by "REST api they actually no longer support"... the SharePoint REST endpoints are absolutely still supported and actively being maintained and enhanced.Re: Client side development - Where do I begin?
To add to JaredMatfess, I agree regarding learning JavaScript first. Go that road and build a few customizations using the SEWP or the CEWP... Then, if you want to get deeper into the SPFx, and want some deeper explaination of the tooling etc Andrew Connell just started creating courses (Voitanos) around this and has a free getting started with SPFx which would get you started with setting up your environment. https://www.voitanos.io/Re: Issue of Microsoft Graph API not supporting Office365 Sharepoint Cloud enumerate sites on smartphone
To clarify, you're referring to the beta endpoint /sharePoint/sites only returning the default site? I have not been able to get any roadmap when the SharePoint endpoints will move out of beta. That said, you could do a seperate authentication against SharePoint tenant itself and use the SharePoint REST api's or CSOM.
