Share
Report
8I have a flow in which multiple people perform work and need to respond to the same case number. When a manager is notified of a certain case, the Microsoft Form URL given to that manager is unique to them. Another words, the URL to the form contains the actual case number. I will post an example below. The reason for the case number in the URL: For over 6 months, the case number is the one thing everyone must input into their Microsoft Forms questionnaire in order for those answers to populate the correct row in Excel (finds the row with the same case number and populates). The issue is that we are all human and about 60% of the time, managers enter in the wrong case number. I do have a flow checking for a match and when there isn't one, the flow sends an email to the manager, warning them that they entered in the wrong case number. I spend so many hours weekly correcting these mistakes, it has become overwhelming.
So, I thought I would add the case number to the form's URL and it does work; however, I cannot retrieve the case number from the URL and make sure the right case number get updated. I cannot dynamically include a space for this number in the form ID and the URL for the form completed does not come through to Power Automate. I am trying to remove the human error element from this flow and provide a pre-populated case number. I just can't get past not being able to identify that specific case number for the response.
Here is an example of the link that is sent to the manager: https://forms.office.com/Pages/ResponsePage.aspx?id=A8u7m8NNo0SmPtJCYf0zP0nrh6NWopKvehGj0e_54BUOUVIM04xUDlZNDNZMzZZM01MR0pUQ0M0SS4u&DOTNumber=567654
You will notice that the last 6 digits is the case number and although it doesn't look like it is part of the URL, it is, but didn't copy that way to this message. How can I get power automate to extract the URL used for the form's response and then list the case number to reference?
Any thoughts on how to make this happen would be appreciative.
Thanks!
All responses (
Answers (
