Dynamic value for SOQL query

[allwynbazil]

Team,

I am running an SFDC query in my workflow. I would like to limit the number of inputs based on the "Limit" value in the query. I would like to take the number from the user, and it has to be applied to the query. We can achieve this through the Text Box interface tool. I am unsure how to apply the Text Box value for the Limit in the SOQL query. Please help.

Regards,

Alwin

[gautiergodard]

Hello @allwynbazil 

I dont have the salesforce input connected at the moment, but you should be able to achieve this in similar fashion to the same workflow attached. 

In the action tool, you'll want to find the field that contains your query, and replace the limit number, in your case 21. Something like this:

Hope this helps! 

[allwynbazil]

Hi @gautiergodard,

Thanks for checking my query.

I tried as you mentioned, however the recordlimit is not working as expected.I used the formula to update the record limit in SOQL query. Any idea?

Regards,

Alwin

[gautiergodard]

Hey @allwynbazil 

I see you are updating the action tool with the 'Update value with formula' open. 

Could you please update to the 'update value (default)' option shown in my screeshot?

From there you'll need to expand the selections of the action tool until you find the expression currently inputted into your Saleforce tool and replace the number '10'.

If this doesn't work please provide screenshots of action tool after you've made the updates mentioned above and I can guide you further from there.

[allwynbazil]

Hi @gautiergodard ,

I have tried that as well but didn't work for me. Please check the screenshot below.

regards,

Alwin

[gautiergodard]

@allwynbazil I believe you need to select the highlighted below:

[allwynbazil]

Unfortunately, it's not working as well.

Regards,

Alwin