Forum Widgets
Latest Discussions
Power automate SharePoint list update
Greetings, I want my company SharePoint to show data (a priority list) from another companies SharePoint. I want to auto check for updates and changes as well. Can they give me permission to integrate the list on my SharePoint? Or would I need to copy the file, and then power automate so it looks for changes in their list and then updates my list accordingly?
Patch data from 5 forms in Powerapp to a single line in sharepoint
Hi All, I'm trying to patch data from 5 forms in Powerapp to a single line in sharepoint. I tried using the below formula in the OnSelect for the submit button but it's not working. Any advise? If(Form_approvers.Valid && Form_Payinfo.Valid && Form_eventinfo.Valid && Form_spiltcosts.Valid && Form_receipts.Valid && Form_addline.Valid, Patch(RnRExpenses, Defaults(RnRExpenses), Form_approvers.Updates, Form_Payinfo.Updates, Form_eventinfo.Updates, Form_spiltcosts.Updates, Form_receipts.Updates, Form_addline.Updates))
Limiting powerapps form person field to members of one sharepoint site returns no values
Hi there, I am working on an app, and I would like to limit the output on a Person field to only the Sharepoint Site Members. Whenever I go into the field in SharePoint and set the limit to our Sharepoint Group members in the List Settings, the dropdown does not show any results. How would I work around this, or what might cause this issue?
Word Doc properties not updated in doc body
Hi, sorry if i am repeating the topic, could not find one that would answer my issue. I have a document template with 2 tables on the page: Table 1 contains info from the template like - Document ID, version, Template approver and Template approval date Table 3 contains info from the procedure - Document ID, version, Document approver and Document approval date. Template is being approved through Power Automate flow. Data in table is updated through flow and all works as expected. However, document after approval flow does not update Document properties in the Table 2, specifically document approver and document approval date. Document ID is updated and version also. I have checked Info of the document, and fields are updated but it is not reflected in the table. If i add it manually again, it does place the correct values, but then my this is seen as change and approval flow needs to be triggered again. Any ideas how to solve this? Thanks.
Dynamic Content with PowerApps and PowerAutomate
Hi All, I was using the search function but I couldn't retrieve what I am looking for. I have a PowerApp with 2 fields: ComboBox Text Input In PowerAutomate I have "Add a row into a table" But I can not see my 2 field in the Dynamic content Can somebody help?
Sending a PDF file as an email attachment with Power Automate corrupts attachment
I have followed this great tutorial for creating and sending digital certificates to event participants (https://techcommunity.microsoft.com/t5/educator-developer-blog/send-digital-certificate-to-event-participants-in-8-easy-steps/ba-p/3697139), and everything worked except for the last step which is sending the email with the certificate attached.I am able to receive an email with the pdf attached however, the file is corrupted and I'm unable to open it. When I check the pdf file in my share point it is not corrupted so the issue seems to be in the step of sending the email. I tried usingbase64ToBinary(base64(body('Convert_file'))), when I added this I was able to open the pdf attachment but the pdf was empty and the content was erased. Please let me know if there is any way to overcome this issue.
Flow to replace SharePoint site page text web part content from form entry
I wish to trigger a flow from a form and use a response value to replace the text values in a text web part in a specific page in "Site Pages". I have tried 2 options but neither of them work. I had a look at this method but I found it confusing plus I would not be able to share/email the page because of the dynamic nature of the content. I am getting a error on the final action (version 1) or having the content canvas completely removed including canvas header (version 2). TRIGGER (both options): When a MS Forms response is submitted ACTION 1 (both options): Get response details ACTION 2 (for option 1): Get Digest Token (via Send an HTTP request to Sharepoint (POST)) ACTION 3a (option 1): Update Web Part (via Send an HTTP request to Sharepoint (PATCH)) -- RESULT: Action 'Send_an_HTTP_request_to_SharePoint_-_Option_1' failed: Cannot find resource for the request webparts. clientRequestId: 093cb580-33ec-45b8-a305-f0ccd16e5405 serviceRequestId: 00616aa1-b034-4000-219c-1d33e02fd756 ACTION 3b (option 2): Update CanvasContent1 (via Send an HTTP request to Sharepoint (POST)) -- RESULT: No change to web part and page not modified.
Problem handling data from masked form
Hello dear community, I recently discover PowerApps and I frequently query that powerfull forum to find answers to my questions. Nevertheless I'm experiencing a problem for which I can't find any answer yet. Here is the context : I have a screen containing one form in view mode. The visible control of the form is set to false. On the same screen I also have several radio buttons fields which are set based on the values retrieved from the form The screen and the record to display are called from an email containing a deep link which perfectly works My problem is : when the form visible control is set to false then deep linking results in radio buttons which are not updated, as if the record was not correctly retrieved. But when I turn the visible control of the form to true then it works. Since I don't want to display the form but only the radio buttons, it is a problem not to be able to make the form invisible. Of course I can fix it by reducing the form size and hiding it behind another element of the screen, but I don't think it is the best way to fix the issue. Does somebody know what the problem is and how I can fix it in a more serious way ? Thanks in advance for your advice.
POWER AUTOMATE FLOW - CONVERT MS FORM TO PDF & SEND VIA EMAIL
Hello, I am relatively new to Flows. But, I've created a few for my team. I am trying to create a flow that will take a MS Form response & convert it to a PDF and send an email. I keep getting hung up and it says the test is invalid. I see that the results are coming in, but it's failing to convert utilizing the OneDrive business convert feature. Does any one know the work around for this? Thank you in advance.
