Automatic patch/updateif based on date

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a power app in which I need to do an automatic patch based on the date. Is it possible?

The data source is SharePoint.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

What is the nature of the patch. You can consider a Power Automate if it has to occur based on occurrence of a date.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No

Community Power Pla... Microsoft Employee on at

Like (0)

Report

Copy link

Link copied!

Hi @eka24

This is the data below:

Customer	User ID	Client Grouping	Country	Status	Date Ready
Gotham Trading	100	500	Spain	In Progress	27/05/2020
Gotham Trading	104	500	Spain	In Progress	27/05/2020
Gotham Trading	105	500	Spain
Midas Gold	109	600	Canada	In Progress	06/06/2020
Brutus Fruit	112	800	France	Application	15/09/2020

For all the same "Client Grouping", If the date condition is met i.e. today() = "Date Ready" update all the "Status" to 'Finalise' . On the Power App I need to prevent updating of the records after said date so I have a condition on the Visible of the button, which is used to update the Status of the client grouping, to the date condition. However, I need to update the "Status" column in the data source.

Was this reply helpful? Yes No

KroonOfficeSol 587 on at

Like (0)

Report
Copy link

Link copied!
First, you could better use Power Automate to do this kind of thing.

When you really want to do this in PowerApps you could have a ForAll() formula on App.Start doing the update. Would work something like this:
ForAll(Filter(DataSource, "Date Ready" <= today()), Patch())

Hope this helps,

Paul

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

If you want to use Powerapps instead of Power Automate then put you Datasource on a Gallery by filtering as:
Filter(Datasource, ReadyDate=Today())

With this, only Data with ready today will show.All others will be invisible.

You can then Patch using a Button:
ForAll(Gallery1.AllItems, Patch(Datasource,
{Status: "Finalize"}))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@KroonOfficeSol

The issue here is that the app might not be opened again after the "Date Ready", in which case the "Status" would not be updated to finalised.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

As I said earlier, the best approach might be Power Automate. With that whether App is closed or open,it will still work.
Post it on the Power Automate section of the platform.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The end-user might not open the app on said date. I'm essentially needing to lock the client grouping and update the datasource as the datasource feeds a production system to place an order. However, I need to lock the update of the client grouping and update all records in that client grouping to finalised.

The first time the user uses the app the user could have finalised the requirement for all those records and choose a future date(Date Ready) for the requirement to be sent to the source system. However, during the window period to the "Date Ready" a new record could have been added to the client grouping. If the end-user did not return to the app in the window period they would not know there's a new record. Instead I want to default all statuses to finalised based on date ready.

Was this reply helpful? Yes No
KroonOfficeSol 587 on at

Like (0)

Report
Copy link

Link copied!

So, my comment on using Power Automate here makes sense then ;-). Power Automate you can schedule to run every night and finalize all records with dates on and before current.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Okay will look at a power automate option. Thanks @eka24 and @KroonOfficeSol

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,
Please consider accepting one or more solutions to close the item and make it easier for others to find.

Was this reply helpful? Yes No