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

HELP :) - Excel - DATE format, but in power app I have error - this formula uses scope which is not presently supported for evaluation

they are two colums from the test database in excel(in atach baza_test2).

data_pop         data_nast

02.02.202004.03.2020
03.02.202005.03.2020

 

When I create a label i have this screen below

2020-03-11 15_13_43-Microsoft Edge.png

 

It is probalby foul this, that I change types of this colums in the excel. Before there be a text and date in text like 03-02-2020.

I want use the date in if, and I change it to date type.

 

 

 
4 REPLIES 4
eka24
Super User
Super User

Try this:
Text(ThisItem.Data_Nast,"dd-mmm-yyyy")

this same:(

Max44
Helper V
Helper V

What I have done in these situations is changed the column to just be text. Then when I get the data into PowerApps I use DateValue to convert it to a date object. Then before sending it back to Excel make it text again.

Not ideal but that has worked for me.

mdevaney
Super User
Super User

@Kordian 
If you want to convert this date from the data_pop column (assuming the format is mm.dd.yyyy).

03.02.2020

 

Then you can do this.

Date(Right(ThisItem,4), Left(ThisItem.data_pop,2), Mid(ThisItem.data_pop,4,1))

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,803)