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

[Anonymous]

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?   

[wyotim]

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!

[v-yutliu-msft · Accepted solution]

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