![]() ![]() So if you're familiar with SharePoint REST call formats your goal will be to attain the same result and the query should work. ![]() 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. Power query odata filter list of items 2016. 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%27T19:450Z%27The 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |