Hi Guys,
I am trying to create a flow that reminds the owner of the order (Dynamics 365) by using a date time field, however the date time field is showing time. I would explain the flow that I created below (I am not sure if this is the correct way that I did it or if there are more optimal ways to go with this problem)
I first initialized a variable that would get the time now and add an additional 7 days to it.
and then afterwards i used a list record which gives out active orders. (This is the part where I think i can improve it by using a filter query to just check the datetime field that would be coming up in the next 7 days only however I do not know the exact query to use)
After getting the list I use this condition where it uses the variable i initialized at the start to check for the datetime field however due to it being a date time field its not matching, i checked it using a compose and it showed up like this.
Below you could see that the datetime field has time on it as well, i was wondering how i could just leave the date field on it.
Or if you have better ideas to make it more optimized like just adding something on the filter query to prevent listing a lot of active orders that would be the best. Thanks guys
@jimmart
Could you share a screen shot of your complete flow.
I believe you can use a compose to return the date only but need to see your flow so i can see its structure and where it would go
Gary
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
92 | |
58 | |
41 | |
39 | |
38 |
User | Count |
---|---|
83 | |
71 | |
57 | |
56 | |
42 |