Answered

Run query against dataset, check to see if row exists in SharePoint list before creation

(0) Share

Report

Posted on by Albertax

111

Hi, I'm having an issue with my flow where I'm unable to figure out how to check to see if a row exists within the SharePoint list i'm creating to.

Problem with my flow is, I am getting my data from a JSON array.

This is my flow currently below. Steps are as follows:

Run a query against the data set.
Store the data in a var (Which is an array)
Parsing the JSON that comes out of the Var.
I'm then doing a CheckContains contains(outputs('Parse_JSON'))

Does anyone have any ideas? Or a solution they are willing to share?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (2)

Rhiassuring 8,690 Moderator on at

Like (1)

Report

So the goal is to create a new item in SharePoint if the row from your data set does not exist in SharePoint?

What is the key between the data? Would it be identical titles? You will need to do a "Apply to Each" (as you are) on the "Title" from the JSON output, on a "Get Items" action for SharePoint, where Filter Query = Title eq 'JSON Title Output'. Then you can do a length() on the output from that, to identify if you've retrieved anything or not. If the length() is equal to 0, then that means you need to create the new item. If the length is not 0, then the item already exists.

Was this reply helpful? Yes No
Verified answer

Albertax 111 on at

Like (0)

Report

Greatly appreciate your response. I seem to be getting an error:

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object'. Please see https://aka.ms/logicexpressions#length for usage details.'.

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (0)

Report

Are you able to show me a screenshot of your flow in configuration mode? (So I can see the expressions used, and references.)

Was this reply helpful? Yes No
Albertax 111 on at

Like (0)

Report

Thanks again for your help, please see screenshot

Was this reply helpful? Yes No
Verified answer

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Ah - you want to look at the length of the values, not the body.

Like this:

length(outputs('Get_items')?['body/value'])

Was this reply helpful? Yes No