Answered

Sharepoint list update, odata and conditions. Flow says succeeded, but nothing is happening

(0) Share

Report

Posted on by Mirna

Dear community,

This is my first post. Hopefully you can help with the following flow that I have been trying to understand the past three days.

I have a flow that keeps returning status: succeeded, but thats it. The actions that I am after are not happening.

This is the idea:

- Flow runs every morning

- Variable of todays date

- Get items from share point. Here I make use of odata

- Apply to each SP item and create a condition where I ask the flow to check if the startdate matches the date of today.

- If so, create an item at column Mutatiedatum with todays date.

- Afterwards another nested apply to each, where I ask the flow to check whether Sharepoint column Mutatietype matches the choice 'Start' in this example.

- If so, then I ask the flow to send an email and post a message in Teams.

This flow works, howover no changes are done in SP, no emails are sent and no posts are posted in Teams.

I have no idea, but it seems that I am missing some imortant steps, however I don't seem to figure it out.

Above example that the flow succeeds, however on the apply to each there is no false or true, which makes it confusing for me.

Below an example of the entire flow. Hopefully someone can help out.

Thanks!

All responses (2)

Answers (1)

Mirna 4 on at

Like (0)

Report

Re: Sharepoint list update, odata and conditions. Flow says succeeded, but nothing is happening

Hi @Expiscornovus ,

Thank you for your message and apologies for the delay. I thought that my message did not came through.
The issue was related to the date. I used your solution, however I wanted to use CET (Central Europe time), so looked as follow.
convertFromUtc(utcNow(),'W. Europe Standard Time','yyyy-MM-dd')

Furthermore I made a change to the date format in Sharepoint.

Thank you.

Last I removed the brackets on the odata filter.
Verified answer

Expiscornovus 31,643 Most Valuable Professional on at

Like (0)

Report
Re: Sharepoint list update, odata and conditions. Flow says succeeded, but nothing is happening

Hi @Mirna,

I have a couple of questions

- How is your StartDatum field configured, is it datetime or only date?

- And do you get any output results in your Get Items Mutatie action in your flow run, is that action empty?

My guess would be that it is probably something with the filter query of the Get Items.

Can you try this approach for your filter query of the Get Items?

1. Use the UTCNow function in your TodayDate and use the format which resembles your StartDatum column. My guess would be yyyy-MM-dd

2. Can you remove the round brackets. I don't believe those are needed in the filter query

StartDatum eq '@{variables('DateToday')}'