Answered

The "Get Element" ID isn't the same as the "Form response" ID.

(0) Share

Report

Posted on by lundte

Hi.

I hope that you guys can help me!

I have this problem that the element id isn't the same as the form response ID.
So the result is to differents outputs.

My form looks like this:

But the outcome is this:

Formular response id 29

Sharepoint ID 29

What do I do wrong?

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Where does the 'Formular response id 29' come from?

Is there a specific question on your Form asking for the responder to enter this ID?

Thanx!

Was this reply helpful? Yes No
lundte 13 on at

Like (0)

Report
Copy link

Link copied!

Hi.

I think ID comes from the number of responses. I actually dont know, it isnt a number I give it.
The only unik number in the form, is the Contract number.

Regards
Daniel

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Is the contract number unique in your SP list? I mean, do you have no more than one element in your SP list with a specific Contract Number?

If so, you can replace 'Get item' and use 'Get items' instead. In order to read your target element, you can assign an ODATA in 'Filter query' input, or add a 'Filter array' action block after your 'Get items'

Please take a try and let us know your progress

Thanx!

Was this reply helpful? Yes No
lundte 13 on at

Like (0)

Report
Copy link

Link copied!

When I try your solution is says that the "request is invalid".

Regards
Daniel

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

According to your screenshot you are not building the ODATA Filter correctly, please check again the screenshot I shared as example

The internal column name is missing, the operator also, and you forgot to add the single quotes

Please try again and let us know your progress

Thanx!

Was this reply helpful? Yes No
lundte 13 on at

Like (0)

Report
Copy link

Link copied!

Hi.

Still a issue 😕
"message": "The term \"ContractNumber_x003a_eq'527497 '\" is invalid.

Regards
Daniel

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Weare closer to a happy ending, just forgot the spaces, one between internal column name and operator, the second one between the operator and the first single quote:

ContractNumber_x003a_ eq '527497 '

Hope this helps

Was this reply helpful? Yes No
lundte 13 on at

Like (1)

Report
Copy link

Link copied!

Oh Jesus....

Sry for being an rookie and thx a lot for your help and time!

It works now!!

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report
Copy link

Link copied!

No problema, I also had such mistake when started working with Power Automate 😄

Happy Flowing!

Was this reply helpful? Yes No