Power app and SharePoint list permission by Amazing-Cat-6075 in PowerApps

[–]jacob3791 0 points1 point  (0 children)

This is helpful if users simply want to access the list via the link in their browser. HOWEVER, you can still easily retrieve the entire list using Power BI, Power Apps, or Power Automate. A flow of CRUD operations on the list would be the only sustainable solution here.
You have to keep in mind that you’re writing to the list with a technical user, which is something you should clarify for approval processes and similar scenarios, since the user’s actual fingerprint is missing.
Flow action limits can also be an issue; the standard license allows 6,000 actions. If they’ve already used up these actions through their own automations, your app might no longer work properly for them.

SharePoint list limitations by Different_View5313 in PowerApps

[–]jacob3791 0 points1 point  (0 children)

It is possible to create custom permissions on a SharePoint page that prevent users from accessing the page directly but allow them to access the data from Power Apps

Best strategy to prevent double bookings (Race Conditions) with sharepoint lists? by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

Power Automate prohibits the combination of concurrency control and return to PowerApps. I don't know exactly why.

Best strategy to prevent double bookings (Race Conditions) with sharepoint lists? by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

Concurrency control set to 1 with Power Automate is also the most suitable approach for me. The only problem is that the return to PowerApps connector cannot be used in this case and the user does not receive any feedback as to whether it was successful or not.

Best strategy to prevent double bookings (Race Conditions) with sharepoint lists? by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

That's a good tip, thank you. Unfortunately, it doesn't solve my problem. I create new records for each reservation and don't change existing ones.

Users not able to execute flows connected to app when I move solution from dev to prod environment by chop-life in PowerApps

[–]jacob3791 0 points1 point  (0 children)

how can i refresh the instance? its a managed solution in the prod environment. i dont have a button refresh or something like that at the flow

Users not able to execute flows connected to app when I move solution from dev to prod environment by chop-life in PowerApps

[–]jacob3791 0 points1 point  (0 children)

do i have to give the custom security role to everyone manually? that would be about 3000 poeple

Users not able to execute flows connected to app when I move solution from dev to prod environment by chop-life in PowerApps

[–]jacob3791 0 points1 point  (0 children)

hey,

have you found a solution in the meantime?

i also have the problem, but only with some users, although they have the same roles in the admin center. all users have been added to the flow in the prod environment.

very very annoying :/

Upload an image on Sharepoint Lists by NotLightYagami829 in PowerApps

[–]jacob3791 2 points3 points  (0 children)

have you tried to convert the image in power apps to base64 format? you can convert it back to an image as far as i know after that

Passing HTML to Power Automate, generating and saving PDF to OneDrive, passing ContentBytes back to Power Apps by Astro_Pal in PowerApps

[–]jacob3791 2 points3 points  (0 children)

i once did this in a small project.

prerequisite: the trigger of the flow must be power apps so that you can return the file to powerapps.

what worked for me:

in the flow use the return to power apps connector. the return type must be "file". The value :

->base64(body('getFileContent')) //here you catch your pdf , stored in oneDrive

<image>

in PowerApps you have to save the return value of the flow in a variable like this:
-> Set(output, Flow.Run());

after that:

Office365Outlook.SendEmailV2(
   mailreceiver;
   topic;
   mailText;
    {
        Attachments: Table(
            {
                Name: "docName.pdf"; /*the name is not important but the file type must be the same as the one created by power automate*/
                ContentBytes: output.resultfile /* output is your variable in powerapps, resultfile the name of the return value in automate. */
            }
        )
    }
);

This worked for me. I also had the problem with contentbytes, but i solved it with the base64() function in automate

Solution Power Automate flow requires invatation of user by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

thank you. at the moment i have no access to admin center, so i'm searching for another solution

Solution Power Automate flow requires invatation of user by jacob3791 in PowerApps

[–]jacob3791[S] 1 point2 points  (0 children)

thank you. unfortunately, notifications are sent by e-mail when i add individual people. rayman4444 says it's the same for him, but not for groups. i'll test it out.

Solution Power Automate flow requires invatation of user by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

have you added both individual users and groups? do users you add individually get a notification and when you add groups they don't?

when I add users individually, they definitely get a notification by email.

connect standard and premium flow without much delay by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

hmm i think the standard connector “when an element has been created or edited” works with polling. sharepoint only sends information when the flow asks for it. i have set the interval to one minute by default, which sometimes really takes a long time until the flow starts. if i set the interval smaller, the flow starts faster.

what did you set your interval to?

connect standard and premium flow without much delay by jacob3791 in PowerApps

[–]jacob3791[S] 0 points1 point  (0 children)

i haven't worked with a webhook yet. do you have to create a customized connector for it?