Create an Invite. Auto Populate the field: Survey, with Power Automate Flow.

(0) Share

Report

Posted on by Roxana

691

Hi All,

Please your help. In a Power Automate Flow, I have the action: "Create an Invite."

I need the field: "Survey" be auto-populated, not manually selected in the flow.

I have tried the following syntax,

msfp_survey,Guid of the Survey
/msfp_surveies (Guid of the Survey)
/msfp_surveys (Guid of the Survey)

But I only get error: "BadRequest."

Error: {"ErrorMessage":"System.Exception: CreateInviteRequestHandler::RetrieveAndUpdateFormDetails:: expection while fetching form and cds url ---> Microsoft.FormsPro.Shared.Common.InvalidFormIdException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. ---> System.FormatException: The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. \r\n

Thanks and best regards.

-Roxana

All responses (4)

Answers (1)

Sort by

Verified answer

ChadAlt 367 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

Hi Roxana,

Great question! I figured this out recently by selecting a survey, then clicking "Peek code" beneath the three dots of the action in Power Automate. This allows you to find the specific format that's expected in the code itself.

From looking here, it actually expects the FormID rather than the survey's GUID. And you don't need the table name but the form ID itself.

The FormId can be found from using the Peek Code or by navigating into Customer Voice and looking at the URL when viewing a survey.

Since it looks like you have dynamic content, this will be available as the "Source survey identifier" from the Survey record.

If you want to make each of these steps dynamic, you can even use environment variables as shown below that store each of these values for the best experience when moving between environments.

Hope this helps!

Chad Althaus

Senior Functional Consultant

Stoneridge Software
Suggested answer

Roxana 691 on at

Like (1)

Report
Copy link

Link copied!

Hi Chad.

Thank you for your kind answer.

Effectively, the field: msfp_sourcesurveyidentifier helped to fill dynamically the field: Survey.

Since the user selects the survey in the screen, I do the following

1-Action Get Row by ID. Get the fields: msfp_sourcesurveyidentifier and _msfp_project_value

from the table: Surveys.

2-Action Create a Survey Invite. Dynamically set the fields: Survey and Project from the values taken in the point 1.
ChadAlt 367 User Group Leader on at

Like (1)

Report
Copy link

Link copied!

Looks good! Is that working for you now??
Roxana 691 on at

Like (1)

Report
Copy link

Link copied!

Yes, it is working very well.

After those steps, I had to add a "Delay" to update the "Survey Invite" on a custom field, otherwise I got an error of: PreConditionFailed, like the primaryKey already existed. The Delay step corrected this error.

Now I am facing another issue, I will post in another thread.

Thank you Chad.