POWER AUTOAMTE to POWER APPS

(0) Share

Report

Posted on by YamiteKudasai

195

Hello everyone,

I would like to ask if is it possible to update a power apps textinput field using power automate without pressing a button?

Scenario:

- I have an input field which status is from a SP List, if the status is "completed" based on SP list data. I would like to automatically reflect that in the input field which is in power apps.

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @YamiteKudasai

Is there any reason why you cannot connect your SPO list to the app? - If you do this, that will then allow you to achieve the desired result directly in the app.

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AmDev ,

Actually I can do that.

But the scenario is. Example I have 2 list.
1st SP Plist is named 'Request List' - contains id and request_status
2nd SP List is named planview - contains id, status

What I plan to do is get the data from 2nd sp list and save it in a collection in power apps. I think, in that case I will have the textinput status value.

Now the next thing to be done is when ever the value of that textinput is completed the request status of 1st sp list should also update without clicking a button using power automate. is that possible?

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @YamiteKudasai - where does the user change the status to 'completed'? - is this just in the app or is it updated outside the app directly in the SPO list?

The reason I ask is, if that change to 'completed' only ever happens in the app - you will be able to achieve what you want directly in Power Apps (i.e. when user selects 'completed' in list 2, the app will save this data to list 1 also)

However, if the status changes to 'completed' outside the app directly on list 2 and you want an instant update to list 1, this would require Power automate.

Both approaches are possible.

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

The txtinput value which is "completed" is from a sp list 1.
if sp 1 has completed value based on id the sp list 2 status should be 'delivery complete' for example

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

That's fine, anything can be written to list 2.

With regards my question - where does the user change the status to 'completed'? - is this in the app or is it updated outside the app directly in the SPO list?

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like
a
(0)

Report
Copy link

Link copied!

It is outside the app directly in the SPO list

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YamiteKudasai ,

You could use Timer control to repeat a formula.

For example:

Set(Var,First(LIST193).Title);Refresh(LIST193);Set(Var2,First(LIST193).Title);If(Var<>Var2,Set(Var3,Var3+1))

If I directly update the Titele Column in the SPO list, Var3 will increase by 1.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YamiteKudasai - sorry for the delay.

If the status is updated in the SPO list and you want an automated instant update / syncing between the two lists, you will need to use Power Automate and you can follow these steps:

Create Automated Cloud Flow
Add the following trigger 'When an Item is Created or Modified'
Insert your list 1 URL
Choose your source list (1)
Go to settings and add a trigger condition - so that the flow only triggers with the status is changed to "Completed" - (note if the item changed to complete will have other changes after this point, you may want to include a means to turn the flow trigger off to prevent it triggering unnecessarily. i.e. potentially have users select 'Notify Completion', then have the flow update the list 1 item status to 'Completed' - For this latter scenario, your flow trigger phrase would then be 'Notify Complete'.
Add the following Action 'Get Items'
Insert your list 2 URL
Choose your destination list (2)
Select 'show advanced options' at bottom and use the 'filter query' to match source ID with the corresponding destination ID
Setting up this filter will allow you to isolate the destination record you want in List 2 to allow you to update in the next step
Add the following Action 'Update Item'
Insert your list 2 URL
Choose your destination list (2)
Choose the ID dynamic content from the Get Items step and insert this into the ID field - this will automatically wrap these actions in a 'for each' loop, even though you just have one item.
Now insert 'delivery complete' in the relevant column and that's it.

Hopefully this is still of use and my understanding of your requirements from the above thread is correct. let me know if you have any queries on the above.

Good luck!

Was this reply helpful? Yes No