May 08 2021
10:53 AM
- last edited on
Aug 03 2023
08:36 PM
by
TechCommunityAP
May 08 2021
10:53 AM
- last edited on
Aug 03 2023
08:36 PM
by
TechCommunityAP
Hello, I am trying to create a workflow for new hire requests.
I have created both forms, the Sharepoint list and have created multiple flows, however, the Manager Form responses are not updating to previously created HR items. It is creating a new item instead.
The flow is below. Any suggestions? I am new to Flow and have been You Tubing and Googling to learn!
May 09 2021 12:43 AM - edited May 09 2021 12:47 AM
@abbeymiles sorry but that won't work, you can't use multiple forms in a single flow. You can only have 1 trigger, the "when a new response is submitted", which is then immediately followed by the "get response details" action. So what you've done is correct for the HR part and you've saved the response into a SharePoint list (we always do the same). However you then have a second "get response details" (without any trigger) but that will never work because it doesn't know which manager response to get.
You will need to do 1 of the following:
1) get the manager to go into the item in the SharePoint list to complete their information - you can provide a link to it automatically in the email; or
2) in the email include the ID of the item created in the SharePoint list and ask the manager to enter that into a question in the manager form, for example the question might be "What is the ID?". You would then need a second flow to run when the manager submits their form and get the item from the SharePoint list using a filter query of ID eq 'What is the ID?' (with that question selected from the dynamic content, not typed in), then have an update item action to update that item with the additional details that the manager is completing.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
May 09 2021 07:05 AM
May 09 2021 07:30 AM
Solution@abbeymiles In option 1 it's not a link to a form it's a link to the specific item in the list for them to edit it with their info. In the email action you select the </> code view icon then add the following html code and select Link to item from the dynamic content:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
May 09 2021 04:31 PM
Sep 14 2021 08:09 AM
@RobElliott so wil that link to the item for the MS form. So when the line manager fills in their info for will it relate to the actual item in the sharepint list?
Sep 14 2021 09:46 AM
@Obayd_LD it will link to the item in the list that was originally populated by the data in the form.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
May 06 2023 01:24 AM
@RobElliottI am also struggling with this issue and cannot get the data from the second form to fill in the MS List on teh same row. I have clearly set up somethign wrong but cannot work it out. Here is my flow, if you are able to provide some guidance please. Thanks in advance
Jan 12 2024 03:25 PM - edited Jan 12 2024 03:28 PM
@RobElliott I'm trying to recreate the steps you've outlined under 2 above but can't seem to get the filter query to work, any advice? Error details: The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/0/Vendor_x0020_Business_x0020_Addr'.'
Jan 13 2024 01:11 AM
@Tscott64 I'm not sure what you're trying to achieve with the get items action but your filter query is incorrect; you've entered ID eq but then there's some dynamic content from the form. The form doesn't know what the SharePoint list ID is. Are you asking the user to enter the SharePoint list ID into a question in the form?
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Jan 13 2024 08:19 AM
@Rob_Elliott Thank you for the reply. The user is entering the ID of the item created in the SharePoint list on an MS Form. I was trying to follow the instructions you listed in this post but must be missing a step: “ …in the email include the ID of the item created in the SharePoint list and ask the manager to enter that into a question in the manager form, for example the question might be "What is the ID?". You would then need a second flow to run when the manager submits their form and get the item from the SharePoint list using a filter query of ID eq 'What is the ID?' (with that question selected from the dynamic content, not typed in), then have an update item action to update that item with the additional details that the manager is completing.”
May 09 2021 07:30 AM
Solution@abbeymiles In option 1 it's not a link to a form it's a link to the specific item in the list for them to edit it with their info. In the email action you select the </> code view icon then add the following html code and select Link to item from the dynamic content:
Rob
Los Gallardos
Microsoft Power Automate Community Super User