Unanswered

Unable to add input parameters to 'Run a flow built with Power Automate for desktop' action

(0) Share

Report

Posted on by IsobelRose

I have built a cloud flow triggered when a form is submitted which will get response details, add row into a table, then initiate a desktop flow. I want to add the form response id as an input parameter that I can use in the desktop flow but am really struggling to find a way to do this.

I am using the new designer so I tried asking Copilot which helpfully added this:

However when I then tried saving my flow I got this error: The caller object id is '11287cf3-77e9-434f-b7b9-40fc09f17ca0'. Connection '/providers/Microsoft.PowerApps/apis/shared_uiflow-1/connections/shared-uiflow-c86e96d7-a389-460e-b504-cfad879e398f' to 'shared_uiflow-1' cannot be used to activate this flow, either because this is not a valid connection or because it is not a connection you have access permission for. Either replace the connection with a valid connection you can access or have the connection owner activate the flow, so the connection is shared with you in the context of this flow.

I have removed and re-added the 'run a PAD flow' action to allow me to save the flow but cannot see any way to add the input parameter myself, there are no fields for this. I have copied the code that was shown when copilot added the step but am unable to paste this into code view as it's read only.

I have done a save as to create a new version of my flow and tried again with Copilot, it has successfully added the parameter but now when trying to save get a different error: Flow save failed with code 'WorkflowOperationParametersExtraParameter' and message 'The API operation does not contain a definition for parameter 'inputParameters'.'.

I have turned off the new designer but still don't see any options for adding parameters:

Please help!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Andrew_J 1,962 Moderator on at

Like (0)

Report
@IsobelRose

I am confused by your wording of your query so here goes:

An internal or external user (please confirm which) completes a form?
The responses of the form are stored in excel or a sharepoint list, please confirm which?

The first two can be undertaken by the CLOUD version of the Flow, as I see mention of the DESKTOP in your query. I do not belive you can use both versions but stand to be corrected.

My question to you is, what do you want to do with the data from the forms submisson when reaches there.

Regards,

Andrew

Was this reply helpful? Yes No
IsobelRose 2 on at

Like (0)

Report
Hi Andrew_J,

Thanks for responding, I'm very new to this.

The form is for a DSE assessment in which internal users will answer a series of YES/NO questions. When a form is submitted I want to save the response in two places:
Spreadsheet in Sharepoint with all responses to the form
Spreadsheet in Sharepoint for the individual response which can be saved to the employee's record

I created the form in Microsoft Forms which users access via a link in Teams. Responses auto-sync to an excel spreadsheet but this is quite a new feature which is currently only available for OneDrive from what I can gather, more info here: Introducing Forms data sync to Excel - Microsoft Community Hub

For step 1 I have created a spreadsheet 'WFH DSE_All Responses' in the relevant Sharepoint folder and set up a cloud flow that gets the response details and adds a row to the table in this sheet. That part all works perfectly.

For step 2 I have set up a desktop flow that creates a copy of 'WFH DSE Response Template' and populates the user details and responses by reading from WFH DSE_All Responses and writing to the copied file. This is then saved as 'WFH_DSE_Response_[name]_[date]'. This file can then be sent to our compliance coordinator who can take action as needed and record those actions in the spreadsheet. The cloud actions for excel online appear to be limited to adding data into existing online workbooks only which is why I have used a desktop flow using the excel app. This is triggered in my cloud flow after step 1 is completed.

Step 2 is working, however, the way I have it set up is 'get first free row on column A' then activate the row above where the latest response is:

This is ok if responses are infrequent, but it would be much better to use the Form Id for the triggering response. The problem I'm having is that I can only find the form ID as a dynamic input in the cloud flow, not in the desktop flow.

WFH DSE_All Respo...

WFH_DSE_Response_...

WFH DSE Response ...

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
@IsobelRose

Okay the lovely DSE assesments.

Thanks for your responce above, I am hopyfully able to provide you with some help. But I will say from the onset that the excel feature below has been about for years in MS forms so is not new as the post your refer to sugests.

I think we need to simplyfy things first as all the CLOUD verse DESKTOP flow use is not helping you in my opinion.

How many questions are on the DSE Form.
How many users need to interact with the Form.
What is your knowlege like on SharePoint Lists.
I would not be able to assist any further until I know the above.

Regards,

Andrew

Was this reply helpful? Yes No