Answered

Autoupdate Sharepoint list / Autorefresh Powerapp page with GPS

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have Lat/Long data on my Powerapp page which is want to continously send to Shareponit list after every 5 min.

I have made the logic and share point list but data is written in share point only 1 time and i need to refresh the page manually or go to another page and come back to this page.

OnVisible Property of Page:

Patch(Testpowerapp,
{
Title: Office365Users.MyProfile().DisplayName,
Lat: Lat.Text,
Long: Long.Text
}

)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Pstork1 69,022 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Not sure doing it every 5 minutes is a good idea, but to do something like this create a Flow with a recurrence trigger set to the time interval. Then in the Flow update the listitem. Otherwise you could just use a timer in the PowerApps page and set it to autostart and update the list using OnTimerEnd.

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

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 , Thanks for your reply.
I have If conditions that if the loction is OUT or IN a given Lat/Long range then, it should update the Sharepoint list.

Set(_flag1,Status.Text);
If(_flag1<>_flag,
Concurrent(Patch(Testpowerapp,
{
Title: Office365Users.MyProfile().DisplayName,
DT: Now() + .0835,
Status: Status.Text
}
) , Set(_flag,_flag1) ) )

Can a timer be used to check IN or OUT lable.text in the page?

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

Like (0)

Report
Copy link

Link copied!

using OnTimerEnd

Was this reply helpful? Yes No
Pstork1 69,022 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Two things I see wrong here.

1) Why are you using Concurrent()? YOu only have one function so why do you need Concurrent?

2) Your Patch statement won't work because you don't identify the record you want to update. The syntax for Patch should be Patch(datasource, record to be updated in deatasource, updates). You have Patch(datasource, updates)

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

Like (0)

Report
Copy link

Link copied!

@Pstork1 wrote:
Two things I see wrong here.
1) Why are you using Concurrent()? YOu only have one function so why do you need Concurrent?
------ I am also updating the Flag

2) Your Patch statement won't work because you don't identify the record you want to update. The syntax for Patch should be Patch(datasource, record to be updated in deatasource, updates). You have Patch(datasource, updates)
------ i want to create a new record everytime.

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

Like (0)

Report
Copy link

Link copied!

Let me know your thoughts - m new to Patch

Was this reply helpful? Yes No
Pstork1 69,022 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

1) you don't need to update the Flag at the same time as the patch. Doing it immediately after the patch should work exactly the same.

2) If you want to create a new record you need to supply defaults(datasource) as the second parameter. YOu use defaults for a new record and an existing record for an update. YOu don't supply either.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

1)Yes, Timer control's OnTimeEnd can be used to set variable.

2)Your three actions are step by step. You do not need to use Concurrent function. Concurrent function is used to act two actions at the same time. Just use ";", which means that act actions in order.

3)The right syntax of Patch should be:

Patch(tablename, Defaults( tablename),{....}) //create a new item

Patch(tablename,one spefic item, {....}) //modify an existing item, please replace one spefic item with the item that you want to modify

Here's a doc about Patch for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch

To sum up, try this formula:

Set(_flag1,Status.Text); If(_flag1<>_flag, Patch(Testpowerapp,Defaults(Testpowerapp), { Title: Office365Users.MyProfile().DisplayName, DT: Now() + .0835, Status: Status.Text } ) ;
Set(_flag,_flag1)

Was this reply helpful? Yes No