Power Platform Community Forum Thread Details

Hi guys, I need your help. I have automated the following process, a normal user can specify via Microsoft Forms on which day he is in the home office or at the location and this then automatically creates a shift for the user in Microsoft Shift. Since the user cannot create shifts as a normal user, the flow runs via my account, which has owner rights. It all works really well.

Now I have added another flow where the user also can delete the shift via the forms and the date field. The problem is that I can't manage to do it that the shift is only deleted by the user who sent the forms. All shifts of all users are deleted on that day. Probably because everything is created via my account. Is there any workaround? Let me show you a screenshot but that flow is completely wrong now cuz I changed so much and I'm sad haha.

Thank you very much. I appreciate it.

Categories:

Building flows

It's hard to say exactly what your issue is. Also, it sounds like this may have happened to the form everyone uses, so you may want to test it on a form first before letting everyone use the feature.

The first possible problem is that you need to use 'Get a Shift' instead of 'List all Shifts.' It's hard to say for sure, but it seems with the code you've shown that shift user and display name are always equal. Then in your "for each" loop each shift is deleted.

If "Get a Shift" needs an ID itself which most things like this in power automate do, there is certainly a work around, but I'm not too familiar with Microsoft Shifts. However, what I think you could do is keep the 'List all Shifts' block, Filter the Array based on the name of the employee, and then select the first option from the name.
This is what the Filter the Array might look like, but yours would have actual variables.

I'm not sure what that data structure looks like that is returned by 'List all shifts,' but you can use expressions to retrieve the ID. If you would like more help, try to attach some more screenshots.