SQL get row not finding the record even though row id is present

(0) Share

Report

Posted on by SachinG31

422

Hello All,

In my flow i am using get tow to get row details from a view , this view has one column of row ID , even though record related to that row ID is present in the view , flow is getting failed , please see and advise if i am making any mistake.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

eric-cheng 5,171 on at

Like (1)

Report

Hi @SachinG31 ,

Can you check that:

1. The view contains this row and it isnt filtered away
2. The row id is a primary key, unique identifier and auto-generated
3. It is returned using Get Rows or Query

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
SachinG31 422 on at

Like (0)

Report

Hello @eric-cheng , Thanks for looking into this issue , please see my comments below
The view contains this row and it isnt filtered away
Yes , View contains this ID and other also which is having the same issue i am not using any filter
The row id is a primary key, unique identifier and auto-generated
Yes the row ID is primary key and auto generated in Share point and import in SQL table
It is returned using Get Rows or Query
Yes its return value , even in compose action i can see value of the same attribute.
Here is my full flow , it might give a better idea.

Was this reply helpful? Yes No