You’re offline. This is a read only version of the page.
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:
Does anyone have any ideas? Or a solution they are willing to share?
Ah - you want to look at the length of the values, not the body.
Like this:
Are you able to show me a screenshot of your flow in configuration mode? (So I can see the expressions used, and references.)
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.'.
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.
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
