Update Sharepoint List by Flow or PowerApps ?

(0) Share

Report

Posted on by gavinleung

216

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

RezaDorrani 12,143 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report
Copy link

Link copied!
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-List-Column-Value/bc-p/248270#M503

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:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
gavinleung 216 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Copy link

Link copied!
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:

Best Regards,

Was this reply helpful? Yes No