Answered

Populate text field on web page using an expression startOfMonth(utcNow())

(0) Share

Report

Posted on by digiworx

Hi,

I'm trying to use a start of the month expression to populate a web form field, but Power Automate is passing this as text. Would be grateful for any help.

Categories:

Power Automate Desktop

All responses (6)

Answers (1)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

You are using "Populate text field" which is probably why it is passing as Text...is it not supposed to be text, or is it in the wrong format?

If it's not supposed to be text, try changing to the appropriate comment such as "Set drop down list".

If it is supposed to be text, and it is simply in the wrong format, use Convert Date to Text and populate the text field with the result. When using Convert Date to Text, ensure you use MM for month as mm stand for minutes.

Best of Luck!
digiworx 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, I'm new to Power Automate, how do I do such things that you've recommended?
Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

I am not familiar with the UTC start of month option. I get dates like this:
Once you have a date as a variable (%BDTM% in my example), the "Convert datetime to text" parameters look like this:

Let me know if you need anymore help.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You're expecting to populate the field with the result of this expression?
Not sure PAD supports this.
You can work with text or variables. For variables, you have to use % notation.
See Variable manipulation and the % notation - Power Automate | Microsoft Docs
digiworx 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah thanks, that gave me a lead to figure out what I needed. Thanks very much.
digiworx 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Brilliant, just what I needed. Thanks very much