Correctly enter data from Sharpoint list in Excel table

(0) Share

Report

Posted on by TomTT

I would like to append data for evaluation from a sharpoin list as a row in an excel table once a month:

Example:
If the data from June is to be evaluated, I have the key 6 in the excel table
July = 7
August = 8 etc.

How do I automatically get the corresponding column of the month in the flow to select the correct key in the Excel table and insert the data in the correct column for June, for example?

In my flow I have entered the key 5 for the month May.

The flow should automatically recognize which month is selected.

The Key column in Sharpoint is a calculating column.

I have no approach to solve this. I do not write good English

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Correctly enter data from Sharpoint list in Excel table

Hi @TomTT

Are you trying to convert a date into a number for that month?

May = 5
formatdatetime(utcnow(),'MM') = 05
formatdatetime('05/12/2021','MM') = 05
replace(formatdatetime(utcnow(),'MM'),'0','') = 5

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
TomTT 91 on at

Like (0)

Report

Re: Correctly enter data from Sharpoint list in Excel table

Hi DamoBird365,

Thank you, it works as requested.
I subscribed to their very interesting blog and YouTube channel
Best regards

Was this reply helpful? Yes No