cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gavinleung
Level 8

Update Sharepoint List by Flow or PowerApps ?

Hi all, 

 

I'm developing a simple solution to the users, allowing them to define tasks by day by month, replicate repetitive tasks to another month, update the time spent. Now, I'm using PowerApps to define tasks, and let users to update the time spent on a specific task. The records are stored in Sharepoint List with the following fields:

1. Title (task title) --- Text

2. Assigned To (the leader assigns a task to a member) --- Person / Group

3. Expected Time Spent --- Date/Time

4. Actual TIme Spent --- Date/Time

5. Completed ? {Yes | No} --- Yes/No

6. Recurrence ? {Daily | Weekly | Monthly} --- Text

 

I can't find any reference by using PowerApps to create multiple List records (if recurrence is checked). So I planned to use Flow to trigger an action when Recurrence contains value. 

 

Any advice / any experience / any idea to share ? 

 

Much thanks!

Gavin

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Update Sharepoint List by Flow or PowerApps ?

 

Hi @gavinleung ,

 

You could use Switch to do different configurations for different Recurrence values.

Use addDays() function to add some days to Assignment Date.

Expression reference:

addDays(triggerBody()?['AssignmentDate'],7)

Image reference:

91.PNG

 

Best Regards,

Community Support Team _ Barry
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

4 REPLIES 4
Dual Super User
Dual Super User

Re: Update Sharepoint List by Flow or PowerApps ?

Hi @gavinleung 

 

In order to create multiple items using PowerApps, you can use the ForAll and Patch function to add/update items based on a collection

 

You can also use Flow to achieve the same

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Community Support Team
Community Support Team

Re: Update Sharepoint List by Flow or PowerApps ?

 

Hi @gavinleung ,

 

Do you mean that the specified action is executed when Recurrence field is empty from the value contained?

You could refer to the methods mentioned in this blog to monitor whether the specified field values have changed as expected.

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Check-for-a-Change-in-a-SharePoint...

For example, I have a field named Recurrence in List2, the type is single line of text. 

Expression reference:

Current version

body('Send_an_HTTP_request_to_SharePoint')['d']['results'][0]['Recurrence']

Previous version

body('Send_an_HTTP_request_to_SharePoint')['d']['results'][1]['Recurrence']

Image reference:

72.PNG73.PNG

Hope it helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gavinleung
Level 8

Re: Update Sharepoint List by Flow or PowerApps ?

Thanks @v-bacao-msft . 

 

What I want to achieve is that when the "Recurrence" field is having value, then trigger an action to :

1. create a new list record

2. the "Assignment Date" is to add some days (weekly = 7) of the original record

 

cap1.png

Community Support Team
Community Support Team

Re: Update Sharepoint List by Flow or PowerApps ?

 

Hi @gavinleung ,

 

You could use Switch to do different configurations for different Recurrence values.

Use addDays() function to add some days to Assignment Date.

Expression reference:

addDays(triggerBody()?['AssignmentDate'],7)

Image reference:

91.PNG

 

Best Regards,

Community Support Team _ Barry
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
firstImage

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,597)