Unanswered

Difficulty with creating a flow - comparison syntax

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have been trying to create a flow, in order to trigger automated emails to respective parties to notify that their campaign ends within 2 days prior to the End Date. The list which contains information on the End Date and other campaign information is up on Sharepoint.

So far I have done the following:

used a 'Recurrence' to schedule the flow to run once per day
used the 'Compose' to create a variable: End_x0020_Date eq addDays(utcNow(),2,'yyyy-MM-dd')
used 'Get items' and invoking the output from Compose within theFilter Query field
And 'Apply to each' (view the following image): The first three steps had succeeded - the 'Get items' has identified the campaign which ends in 2 days. However, I am still having difficulties in the last method for Apply to each for the comparison.

Any assistance would very much appreciated 🙂

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey! you should modify your expression in apply to each condition as
formatDateTime(addDays(utcNow(),2),'yyyy-MM-dd')

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have attempted your solution:
However it is displaying the error message Unable to get token for audience 'https://management.azure.com/'. Details: 'AADSTS50079: Due to a configuration change made by your administrator, or because you moved to a new location, you must enroll in multi-factor authentication to access '797f4846-ba00-4fd7-ba43-dac1f8f63013'. Trace ID: 4d75f5d9-ec30-49e. I am wondering if this a problem with the syntax that I have put or a problem with access to sharepoint?

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

This seems to be an authentication issue with the connectors you are using. Please log out of the current session, close the browser window and start a fresh session. Re login into flow and run it.

Alternatively, you can try deleting the current connection to sharepoint and create a new connection.

Hope this Helps.

Was this reply helpful? Yes No