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
v-yutliu-msft
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
wyotim
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!

v-yutliu-msft
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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (41,850)