Flow to update Dataverse Table from Microsoft Form Submission

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I have this flow that takes the form response data to pull the target and stretch goals for the metric selected from the 23-24 Scorecard Metric table and create a row in the 23-24 Scorecard Data table.

I am having an issue with the data pull from the 23-24 Scorecard Metric table, I keep getting this error: "Syntax error at position 9 in 'Number of Labor Hours Saved'."

Screenshot 2023-07-19 082417.png Screenshot 2023-07-19 082444.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sanshubh 512 on at

Like (0)

Report
Copy link

Link copied!

Hello @gfeldhake

Check this out for writing filter condition :- Filter Query

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

Hi,
I have tried the filter query listed in the article but I am still getting the Syntax error message. Any advice for applying it to a MS form data?

Syntax error at position 10 in 'contains ('Metric', 'Number of Labor Hours Saved')'.

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 2,996 on at

Like (1)

Report
Copy link

Link copied!
@gfeldhake
First of all, you need to remove the space character after contains.
Secondly, you don't need a single quote for the column name (the first parameter of the contains function)
And the column name should be the logical name instead of the display name.
Here is the sample filter rows parameter and please replace xyz_meterics with the actual logical name of your column.

contains(xyz_metrics, '«MIS Metrics»')

I recommend using the FetchXML Builder tool to build the filter query if you are not familiar with the filter operators. Here are a couple of blog posts from the community on how to use the tool to generate the filter rows parameter.

https://blog.magnetismsolutions.com/blog/nickchin/2020/05/07/power-automate-flow--making-the-filter-query-easier
https://saralagerquist.com/2019/11/13/be-lazy-filter-list-records-in-power-automate-with-fetchxml-builder/

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (1)

Report
Copy link

Link copied!

Thanks @LinnZawWin, your walkthrough really helped.

Was this reply helpful? Yes No