Answered

Trigger a flow when date today is the same as the date in the data list table

(0) Share

Report

Posted on by yellowsubmarine

Hello , Could you help wiht my flow build. I want to create a flow that will run on a daily basis at 8AM but will only perform an action if the date today is the same as in the Sharepoint data list table below. 🙂

By the way dates above are imaginary and not necessarily Calendar day 1 to 5. Hence Day 5 could be calendar day 6 or 7 thats why I have a table being maintained.

@v-zhos-msft @v-bacao-msft @Pieter_Veenstra @v-yamao-msft love to get your thoughs 🙂

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Hi @yellowsubmarine ,

Can yo share more details on what component is the date coming from Sharepoint? If it is a list -item, please refer to the screenshot below:
Note: Date used for comparision:
formatDateTime(utcNow(), 'MMMM dd, yyyy')
DaysOpen is a field from my sharepoint list.

You can define/ create your actions under the yes tab.

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
yellowsubmarine 62 on at

Like (0)

Report

Hi @yashag2255 ,

Thanks for the response, for the date it is a Data List as shown in my screen shot but as text e.g. Jan 1, 2020. Did I answer you question? 🙂

regards,
ys

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hi @yellowsubmarine ,

Yep Got It.

So the date is coming from a Data List. I wanted to know what is the name of the column that stores the date (or the string of form MMM dd, yyyy)

If you see the screenshot of the flow I posted, In the Get Items, Select this Data list and in the condition inside of the Apply to Each loop, compare the string created with the date field from your shrepoint list.

Hope this Helps.

Thanks.

Was this reply helpful? Yes No
yellowsubmarine 62 on at

Like (1)

Report

Thanks @yashag2255

Was this reply helpful? Yes No