HI
Note: for your own safety you should black out your real addresses in your pictures.
Question: You said when you tried to run it, do you mean test it or , when you did work, and a file got generated. so when you say it did nothing, do you mean it didnt FIRE off or it didnt do what you expect.
I see nothing wrong with your flow.
If your flow did not update a record (let's not say it did nothing we don't know that) the it's most likely 1 of 3things
1) your filter is wrong in your Get Items and it returned 0 rows. That's almost 100% certain is what happened
-However do I verify
Go into the run, review the Inputs into Get Items and the Outputs (you should be able to click Download for the outputs) and I am going to guess when you get to the value property it just looks like [] aka blank/null/empty
Now you need to figure out why.
You need to look at the Filter Query, which will be part of the Action in the Run of that flow.
But a second thing you can do and I do suggest it is this
DO THIS: Before your Get Items, add a Compose
In the Compose put the Dynamic Property you are using in your Filter the one that starts with File name with
let's just verify what you have there, so we can compare it against whats in the list, so we can see IF no rows were returned
2) your condition is wrong
I dont think its this I think it was exactly 0 records from #1 so this part probably worked as expected, just not as you hoped. so we need to fix #1 so read that section carefully.
3) your not using the correct ID in your Update, where you have first. Now this one is definitely possible for sure, in which case the flow would probably run perfectly and this action would look like it worked perfectly and it probably did, it just didnt find any records.
DO THIS: Before the Update Item
Add a Compose, put your expression - the one in your ID property so we can see what you have there
If you cannot click the plus above your Update, do this
Put the compose below it
Then drag the Update below it and they will re-arrange
Now we have everything covered and we should easily see why it didnt update anything.
If this solves your problem please mark as the answer
33
Share
Report
All responses (
Answers (
