question Re: Look up RITM records through Flow Designer in Developer forum

Look up RITM records through Flow Designer

Mike15 — Mon, 30 May 2022 13:52:32 GMT

Hello Experts

@Ankur Bawiskar

We are trigger flow once user profile is created or updated in sys_user and we sending link to manager and manager will fill the catalog form

If the ritm found then update the user record if not then send reminder email ,Please find below attachment it is not working if through there is one record it is not updating the user record

Don't know it is working any solution or inputs ?

Re: Look up RITM records through Flow Designer

Aman Kumar S — Mon, 30 May 2022 14:02:04 GMT

Did you check the flow context, are you getting anything as result of lookup?

And how the test flow looks like?

Re: Look up RITM records through Flow Designer

Ankur Bawiskar — Mon, 30 May 2022 14:04:19 GMT

Hi,

I hope you are running flow as System User

Did you check the flow context? what's the error?

what debugging you did?

Regards
Ankur

Re: Look up RITM records through Flow Designer

Mike15 — Mon, 30 May 2022 14:50:46 GMT

Hello @Ankur Bawiskar @Aman Kumar

Yes i check the flow context it showing count as 0

Re: Look up RITM records through Flow Designer

Tudor — Mon, 30 May 2022 15:03:55 GMT

Hi Mike,

Asking the stupid question here.

If you apply the same condition, as the lookup, on the sc_req_item table in the list view, does it return any results?

Tudor

Re: Look up RITM records through Flow Designer

Mike15 — Mon, 30 May 2022 15:12:03 GMT

Hello Tudor

Yes i already verified that

Re: Look up RITM records through Flow Designer

Ankur Bawiskar — Mon, 30 May 2022 15:14:45 GMT

Hi,

Seems query is not working

Did you check this point?

I hope you are running flow as System User

Regards
Ankur

Re: Look up RITM records through Flow Designer

Mike15 — Mon, 30 May 2022 15:19:23 GMT

Hello @Ankur Bawiskar

Yes

Re: Look up RITM records through Flow Designer

Ankur Bawiskar — Tue, 31 May 2022 03:13:20 GMT

Hi,

are you sure the query you are doing is correct with correct field names and values?

Regards
Ankur

Re: Look up RITM records through Flow Designer

Markus Kraus — Tue, 31 May 2022 06:26:17 GMT

Please expand the "Look Up Records" action and post a screenshot of the values. I have the feeling that there is wrong with the requested_for value.

Additionally this could be a timing issue if this flow takes place when this onboarding sc_req_item you are looking for is created in parallel. In this case you might have to do a sleep of a few seconds before doing the lookup.