cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

File can not be output with a specified period

I am developing with PowerApps and Flow.
I was able to output CSV using flow.
There are dates such as registration date in CSV. I want to output only data for the period specified by PowerApps to CSV for the registration date
Could you tell me how to become a method or a reference site?

 

I want to output data with the period specified in the following Flow.

Thank you for your consideration.

q01.PNG

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: File can not be output with a specified period

Hi @sheep

Do you only want to output data for a specified period (registration date) passed from an app?

If you only want to output data for a specified period (registration date) passed from an app, you should filter the results the "Get rows" action returned based on the specific period (passed from an app) before the "Create CSV Table" action.

I have made a test on my side, please take a try with the following workaround:

My Excel table data structure as below:6.JPG

The Flow's configuration as below:7.JPG

 

8.JPG

Within "Filter array" action, From set to output of "Get rows" action. Then click "Edit in advanced mode", type the following formula:

@equals(formatDateTime(item()?['Due_x0020_Date'], 'mm/dd/yyyy'), formatDateTime(outputs('PassedDateValue'), 'mm/dd/yyyy'))

On your side, you should type:

@equals(formatDateTime(item()?['Registration_x0020_Date'], 'mm/dd/yyyy'), formatDateTime(outputs('PassedDateValue'), 'mm/dd/yyyy'))

Note: The 'Due_x0020_Date' represents the Due Date column in my Excel table, the 'PassedDateValue' represents the "Compose" action.

 

App's configuration as below:11.JPG

The flow works successfully as below:

9.JPG

 

10.JPG

More details about using expression in flow actions, please check the following blog:

Use expression in flow actions

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: File can not be output with a specified period

hi @v-xida-msft ,

Thank you. I'm happy to reply.

 

1. Acquire data for one day
2. Add date
3. Acquire data after 1 day
Repeat this. It seems that you can get data for the specified period.

However, it is difficult to combine data and it is struggling.
In "flow" it is difficult to join arrays.
I'll try to do my best.

 

Thank you very much.

 

Best regards,

sheep

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,479)