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?

All responses (9)

Answers (1)

efialttes 14,756 on at

Like (1)

Report

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

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

Happy Flowing!
lundte 13 on at

Like (1)

Report

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

Oh Jesus....

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

It works now!!
Verified answer

efialttes 14,756 on at

Like (0)

Report

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

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
lundte 13 on at

Like (0)

Report

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

Hi.

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

Regards
Daniel
efialttes 14,756 on at

Like (0)

Report

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

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!
lundte 13 on at

Like (0)

Report

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

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

Regards
Daniel
efialttes 14,756 on at

Like (0)

Report

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

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!
lundte 13 on at

Like (0)

Report

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

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
efialttes 14,756 on at

Like (0)

Report

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

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!