Unanswered

Set Variable to create Date Table is Empty, Even When I Follow Format

(0) Share

Report

Posted on by KN-10020535-0

I can't figure out what I am doing incorrectly. I am wanting to create a Data Table from a set variable. As you can see on the side, it says it created 0 rows and 0 columns. Even though it isn't pictured, at the end it had ' }% ' Can I please get help with this? I am not getting any synax errors. Thank you!

Categories:

Power Automate Desktop

SetVariable.png

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @KN-10020535-0

Please find the solution. You can see 4 rows and 3 columns has been created.

Set Variable syntax.

Just try editing this below one by copy pasting.

%{ ^['StartDate', 'EndDate', 'YN'], ['03-08-1997', '04-09-2020', 'Yes'], ['03-08-1987', '04-09-2000', 'No'], ['03-08-1999', '04-09-2024', 'Y'], ['03-08-1997', '04-09-2025', 'N'] }%

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
KN-10020535-0 11 on at

Like (0)

Report

@VishnuReddy1997

I tried copying and pasting what you suggested and it still isn't working! I don't know if I just have a bug or something?

Was this reply helpful? Yes No
Verified answer

KN-10020535-0 11 on at

Like (0)

Report

@VishnuReddy1997 Never mind! I found it couldn't be in a subflow and then it worked. Thank you for your time! Take care.

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @KN-10020535-0,

No problem.Thank you if it solved your problem please mark it as a solution.

Regards,

Vishnu Reddy

Was this reply helpful? Yes No