Power Platform Community Forum Thread Details

Hi All,

I'm using excel as the connector. I used the list rows where i got the excel values.

I'm using the filter array where i need to filter the 60 days record from current date. As we already know the date is coming as numbers and we need to format the date

My formula is:

formatdatetime(adddays('1899/12/30',int(item()?['Created'])),'MM/dd/yyyy')

its working fine incase if i have the records of 5000. i cutt of my records to 10 and 100 the same formula is not working

My filter array action should be worked for both the criteria if its multiple of 5000 records or even for 100 records.

Could you please suggest me how to acheive this. I tried applying the multiple formula but i'm getting the error is int is invoked not a valid parameter.

Thanks in advance.

Categories:

General topics