Filter SP list via Power Apps variables

[mrleetyler]

hi all,

I have a PA flow triggering from a PowerApp. 

I am trying to run a "Get Items" on my Sharepoint list to filter between 2 dates with the date parameters being entered via SP Date pickers.

Note: If i just do "Created ge <Entry 1>" ....it works fine ...however adding the "and....." it breaks and gives me a "String was not recognized as a valid DateTime." error. 

PA filter box

PowerApp breakdown.

anyone know how to fix this?

note: Figured out the End Date doesn't work even when isolated? so guessing it's trying to read it as a specific date format? where are the start date could be any format DD/MM or MM/DD?

[v-xiaochen-msft · Accepted solution]

Hi @mrleetyler ,

I did a test for you but I did not encounter this error.

Created ge '@{triggerBody()['Getitems_FilterQuery']}' and Created le '@{triggerBody()['Getitems_FilterQuery_1']}'

Please try to remove the flow in your canvas and add it again to check if the error disappears.

If the problem persists, please try the 'Filter array' action.

Best Regards,

Wearsky

[mrleetyler]

thanks Wearsky,

through experimenting realised it wasn't like sending the date format DD/MM/YYYY like we would use in Australia. i forced it to change to US format before sending and it seems ok now. 

luckily straight forward fix but that caught me out for a long time.

that explains why my start date was working and end date which was after the 12th didn't work

[v-xiaochen-msft]

Hi @mrleetyler ,

Glad to see you solved the problem.

This is indeed a problem in flow. I missed it.

I think there is another way to solve it that you also could use formatDateTime() function in flow to solve the problem.

formatDateTime('your date', 'MM-dd-yyyy')

Best Regards,

Wearsky