Unanswered

Daily check if user send all records to database

(2) Share

Report

Posted on by RodolfoMaia

Hi all,

I have a canvas app built using power apps. The app works offline with data stored in collections and at the end of the shift users upload the inspections records to the database (SharePoint). The inspections are stored in a collection called colInspection and it has a filed called Status that is either "in progress" or "complete", only inspections with Status = "complete" are uploaded.

I am trying to build a flow to check every morning at 8am, if the inspections with Status = "complete" were uploaded, if not send to the user a push notification.

I am ok with the trigger in the start of the flow, using recurrence every day at 8am, I am also ok with sending the push notification to the user. The part that I am struggling with is the going to every user's app/phone and check if colInspection has any record with Status = "complete". Can anyone help me please?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU01080144-1

If I may ask a question.

Do the work items, already exist in the back end (DV/SharePoint) you just dont know if they have been updated yet from the phone?

The reason I ask is, because the Modified Column in the back end will tell you this without reaching out to the phone,... which I am not sure you can even do and would give you a clearer picture of the last time that line item was updated.

Will that solve your issue?

Was this reply helpful? Yes No
RodolfoMaia 10 on at

Like (0)

Report

Hi Michael E. Gernaey,

Thank you for your question. No, the work items are on the phone only.

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @RodolfoMaia

I guess though I am confused (easily) because you said

I am trying to build a flow to check every morning at 8am, if the inspections with Status = "complete" were uploaded, if not send to the user a push notification.

NM I get it.

You could build a Mobile Scheduled Flow and make them install it so it runs on their phone at 8 AM and sends them a reminder locally.

Was this reply helpful? Yes No
RodolfoMaia 10 on at

Like (0)

Report

Hey Michael E. Gernaey,

I liked your suggestion of building a Mobile Scheduled Flow.

Which action should I use to get the collection on the phone to check if Status = "complete". I am successful to create a flow like Image below, where I am passing the colInspection and the User to be notified, then I can successfully check for Status = "in progress"

but how can I add for the flow to run everyday at 8am?

Was this reply helpful? Yes No