Power Platform Community Forum Thread Details

Hi,

I was directed here by @RezaDorrani via his Youtube channel (SharePoint Security in Power Apps | Item Level & Folder Permissions - YouTube). I have built an activity logging app that works great with the exception of one thing - items are added to the root folder currently, however I want them to be added to a folder which is created using datacard entries. Here's a summary:

Page 1 - the user enters their name, role and team. When they hit submit, a flow will run which creates the folder within the data source. The folder is named datacardvalue3_datacardvalue5_datacardvalue4_date using the formula DataCardValue3.Text & "_" & DataCardValue5.Selected.Value & "_" & DataCardValue4.Text & "_" & Day(Now()) & Month(Now()) & Year(Now())

This works fine, the flow creates the folder as expected.

Page 2 - this is where the user enters their first activity log. On clicking the submit button, it patches the form on page 1 and the form on page 2 whilst resetting the form on page 2. The formula is:

Patch(
OccurrenceLogs,
Defaults(OccurrenceLogs),
Form2.Updates,
Form2_1.Updates;
);ResetForm(Form2_1);Navigate(OccurrenceView);

Page 3 is a gallery view which currently uses a filter to show the relevant items. There's also a 'new log' button which takes the user back to page 2 and an 'end of shift' button which takes the user back to page 1 and resets the form on page 1.

What I'm looking for is one of the following:

Option 1) The button on page 2, I want it to upload the form to the new folder that has been created instead - so /lists/OccurrenceLogs/DataCardValue3.Text & "_" & DataCardValue5.Selected.Value & "_" & DataCardValue4.Text & "_" & Day(Now()) & Month(Now()) & Year(Now())

Option 2) On click of the end of shift button on page 3, the list items that match the results of the three datacards on page 1 are moved to the newly created folder. I feel like this option may be more challenging than option 1.

Something to bare in mind is that multiple people will be using the app at the same time. Secondly, a collection is probably not the best way to go as the shifts will last 12 hours and the user will not be submitting a log constantly plus I need live data available to the activity manager.

Hope this makes sense and I hope someone is able to help me. Thank you 🙂

Categories:

Building Power Apps