cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Replace Date in Excel Column with a New Date from power Apps.

I have an Orienation Scheduling tool that we currently have as an excel flie.   Is in the Current tool I have macro that will recschedule an entire class to a new date.  For example if we created a 11/25 class and then realized that is a holiday or for some reason we can change everyone from 11/25 to a new a date say 11/27.   Is there a way to get Powerapps to feed this data from a dropdown into excel?   

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @Anonymous ,

Do you want to update the date field of all the records?

I suggest you use a date picker control.

You could select a new date to update data.

I've made a similar test for your reference:

1)insert a date picker and a button

2)Set the button's OnSelect:

ClearCollect(collectionname,tablename);    //avoid ambiguity
ForAll(collectionname,Patch(tablename,LookUp(tablename,ID=collectionname[@ID]),{datefieldname:DatePicker1.SelectedDate})

Please replace the collectionname,tablename,datefieldname with the name that you use.

Here's a doc about updating multiple records for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

 

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Resident Rockstar
Resident Rockstar

Hey @Anonymous, by "feed this data" do you mean the data from the macro? If so, PowerApps can't interact with macros in Excel, or formulas for that matter. It is pretty much limited to tables of static data.

 

That said, you could definitely pipe a table of data from Excel into PowerApps and create an app that would assist in changing dates in the Excel table if you want to go that route. Dates in Excel do get a bit funky so there are some caveats to know about if you do go that route, namely that PowerApps treats dates from Excel as if they are UTC dates and will apply a time zone offset to them.

 

For instance, if I had a date of 8/5/2019 in an Excel table, it would show up as 8/4/2019 6:00PM for me because I am in the Mountain time zone, -6 hours from UTC time. There are a number of ways to counteract this and I would be happy to help out with some of those if you need it. 

 

Please let me know if I can give more info or help out further!

Community Support
Community Support

Hi @Anonymous ,

Do you want to update the date field of all the records?

I suggest you use a date picker control.

You could select a new date to update data.

I've made a similar test for your reference:

1)insert a date picker and a button

2)Set the button's OnSelect:

ClearCollect(collectionname,tablename);    //avoid ambiguity
ForAll(collectionname,Patch(tablename,LookUp(tablename,ID=collectionname[@ID]),{datefieldname:DatePicker1.SelectedDate})

Please replace the collectionname,tablename,datefieldname with the name that you use.

Here's a doc about updating multiple records for your reference:

https://powerapps.microsoft.com/en-us/blog/bulk-update-using-forall-and-patch/

 

 

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (5,871)