Help, is it impossible to filter data in PowerApps using calculated columns in SharePoint?

(0) Share

Report

Posted on by XiaohuLiu

101

Thank you very much for watching!

My problem is this, I made a calendar in Powerapps, and then I have a column in SharePoint that belongs to "Date and Time" called "Start Date". I created a new "End Time" column based on the "Start Time" column through a calculated column in SharePoint.

When I filter the data in the power apps calendar, the "Start Date" column is perfectly fine, but when I use the "End Date" column, I can't filter the data, I would like to ask what is this?

Thank you very much for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,074 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @XiaohuLiu ,
SharePoint calculated columns work very poorly with Power Apps and should not be used. You need to do the calculation in Power Apps and populate a Date/Time field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
XiaohuLiu 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,
Thank you very much for your reply. What you mean is that I first create an empty 'date' column in SharePoint, then create a field in PowerAppsd's Form, apply some formulas, calculate the value directly, then submit it directly and store it in SharePoint, please ask this logic Is it right?

Was this reply helpful? Yes No
WarrenBelz 156,074 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @XiaohuLiu ,

Yes - you can make the calculation the DefaultDate of the Date Picker on the Form if this is always going to be the calculation.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
XiaohuLiu 101 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz ,
By the way, I would like to ask you a question, when I store data in Powerapps to SharePoint, the data in SharePoint will automatically add a comma, right?
I am very curious about this phenomenon, thank you

Was this reply helpful? Yes No
WarrenBelz 156,074 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@XiaohuLiu ,

What comma are you referring to ?

Was this reply helpful? Yes No