24
Happy TGI(almost)F...
Looking to see how to split the received date into two columns on the excel document. How do I achieve that?
I tried the below and it hasn't been working and I'm splitting it manually in excel.
You might consider configuring the date format in Excel:
Thank you. This worked.
@geeklarokcmie You need to use and expression and the formatDateTime() function. Use a Compose action to compose the date and time and run a test.
Click on the dynamic content tab and insert the output from the Convert Time Zone action.
Add a comma and single quotes. Between the single quotes enter your date format.
Run a test.
Use another Compose action to store the time output. Tip: Rename your actions to keep things organized!
Insert the output from the Compose actions into whatever action you are using (eg. Add Row or Create Row in table)
If you'd like to level up your Power Automate skills check out this video: Power Automate Beginner Tips and Tricks | 5 Things You Need to Know – Part 1
I cover the following in this video tutorial:
✅ Power Automate Beginner Tips and Tricks
✅ Why use the Manual Trigger instead of an Automated Trigger
✅ 3 Ways a Compose Action can help you build better flows
✅ How to Manually Trigger a flow with a specific Date and Time
✅ How to return a count of items
✅ How to use the top count
✅ How to send test emails
Hope this helps!
| If I helped you solve your problem—please mark my post as a solution ✅. Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion |
Share
Report
All responses (
Answers (
